Developer in Test III - Core Enterprise Data and Analytics, IS Core

Company Description

“We’re not in the shipping business; we’re in the information business” -Peter Rose, Expeditors Founder

Global supply chain management is what we do, but at the heart of Expeditors you will find professionalism, leadership, and a friendly environment, all of which foster an innovative, customer service-based approach to logistics.

• 18,000 trained professionals
• 350+ locations worldwide across 60+ countries
• Fortune 500
• Globally unified systems

Job Description

The Core Enterprise Data and Analytics Group is looking for strong candidates who want to help design and expand our library of automation tools and frameworks. You will be responsible for shaping the direction and quality of our reporting data, applications and the frameworks utilized to test them.
The Developer in Test designs, develops and maintains complex automation and custom test frameworks. They participate in the design and development of systems with an eye towards assuring quality and testability. They fully understand and support the role of the Quality Assurance Engineer by providing automation test strategies and tools for our technologies and systems. They also perform quality assurance tasks such as test planning, test case generation and testing. They act as a driver for progress in their team. This team has a startup culture.

Responsibilities:

• Design test plans for Azure data engineering projects that use services like Databricks and Synapse.
• Perform functional analysis and data validation.
• Perform data completeness testing, duplicate data detection, and data validation rule enforcement.
• Use and create design and mapping documents for transformation rules to ensure proper testing.
• Collaborate with Business Analysts and Developers to define testing requirements.
• Develop overall test strategy, lead testing of all impacted applications/infrastructure, and support post-production activities.
• Write test scripts for inbound and outbound ETL processes and interfaces with other systems.
• Conduct data quality and audit checks on source and target data.
• Prepare mockup/synthetic data to test positive and negative scenarios to meet business requirements.
• Create test-related documents and provide results to various client systems using Azure technology.
• Test large datasets (millions of records) from diverse sources.
• Conduct whitebox and blackbox testing for data transformation processes.
• Verify metadata, including table and column definitions, data types, lengths, constraints, and indexes.

This position is on-site and will reside in the greater Seattle, WA. area at one of the following locations depending on availability. Candidates must be local or willing to relocate. Relocation assistance is not offered for this position.

• Downtown Seattle
• Federal Way
• Lynnwood
• Bellevue (Factoria)

Qualifications

MINIMUM QUALIFICATIONS

• 4+ years of experience with object-oriented languages (Python preferred) and SQL.
• 4+ years of experience in a technical quality assurance role.
• Experience with cloud technologies (Azure preferred).
• Experience working with databases.
• Proficiency in reading and writing code in programming languages such as Python, Java, or JavaScript (Python preferred).
• Strong understanding of SQL and data warehousing concepts.
• Experience with test automation frameworks.
• Ability to generate consensus among team members.
• Customer service-oriented attitude and excellent time management skills.

DESIRED QUALIFICATIONS

• Familiarity with Python development.
• BS in Computer Science or comparable work experience.
• Strong troubleshooting and communication skills.
• Ability to drive technical and process improvements.
• Proficiency with automation tools and writing automation tests, test automation, automation frameworks, and testing best practices.
• Proficiency with Agile methodologies.
• Experience with GIT or other versioning tools, IntelliJ or other IDEs.
• Experience working with Kafka.
• Experience with ETL tools and data validation using Azure technologies (Databricks, Azure SQL Server/Synapse).
• Experience with data validation for on-prem to cloud migration.
• Experience testing large datasets from diverse sources.
• Experience validating front-end data in Power BI reports and ensure it matches the database.
• Strong SQL skills for data comparison and analysis.
• Ability to create and manage test data for various scenarios.
• Understanding of data transformation processes and validation techniques.
• Experience with data profiling and quality tools.
• Knowledge of data warehousing concepts.
• Understanding of cloud platforms (AWS, Azure, GCP).
• Familiarity with test automation frameworks like Cucumber.
• Familiarity with Behavior Driven Development/Test Driven Development.

PREFERRED EXPERIENCE

• Previous experience in a similar role, particularly in testing cloud-based solutions.
• Experience with CI/CD pipelines and DevOps practices.
• Experience with data completeness testing, duplicate data checks, and data integrity checks.
• Experience with whitebox and blackbox testing for data transformation processes.
• Experience with metadata testing, including verification of table and column definitions, data types, lengths, constraints, and indexes.
• Ability to identify gaps in testing processes.

Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not transfer or sponsor applicants for U.S. work authorization (such as an H-1B visa) for this opportunity.

Additional Information

Expected base salary: $120,000 to $170,000

Expeditors offers excellent benefits:

• Paid vacation
• Holidays (10)
• Flexible Days (2)
• Paid Sick Time (accrual rate of 1 hour of sick time per 30 hours paid)
• 401(k) Retirement Savings Plan with employer match
• Employee Stock Purchase Plan (ESPP)
• Medical, Prescription Drug, Dental & Vision Coverage
• Health Savings Account (HSA)
• Life and Disability Insurance
• Paid Parental Leave (additional eligibility criteria)
• Dependent Care Flexible Spending Account (DC FSA)
• Commuter Benefit
• Employee Assistance Program (EAP)
• Training and Personnel Development Program
• Educational Assistance and Reimbursement
• Position is full time (40 hours per week) Monday through Friday 
• Business professional dress code

All your information will be kept confidential according to EEO Guidelines.