Job details

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.

Average salary estimate

$145000 / YEARLY (est.)

min

max

$120000K

$170000K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About Developer in Test III - Core Enterprise Data and Analytics, IS Core, Expeditors

At Expeditors, we’re not just about shipping; we’re about information, and as a Developer in Test III within our Core Enterprise Data and Analytics team, you’ll be right at the heart of this mission. Located in the vibrant city of Seattle, WA, you'll work in a lively startup culture that promotes creativity and teamwork. Your key responsibility will be designing and enhancing our automation tools and frameworks, which are essential for ensuring the quality of our reporting data and applications. This isn’t just a job—it’s about shaping the future of our data quality initiatives. You'll get hands-on as you write test scripts for intricate ETL processes, conduct functional analyses, and collaborate closely with Business Analysts and Developers. If you thrive in environments that encourage problem-solving and technical innovation, Expeditors is the place for you. Your expertise in Python, SQL, and cloud technologies like Azure will be put to the test as you lead teams in developing test strategies and ensuring data accuracy, working with both small datasets and massive volumes of records. Plus, with a range of excellent benefits like paid vacation, flexible days, and career development programs, we make sure to take care of our own. Join us and play a pivotal role in our quest for data excellence!

Frequently Asked Questions (FAQs) for Developer in Test III - Core Enterprise Data and Analytics, IS Core Role at Expeditors

What does a Developer in Test III at Expeditors do?

A Developer in Test III at Expeditors is responsible for designing and developing automation and custom test frameworks. This role involves performing quality assurance tasks like test planning, functional analysis, and creating test scripts, ensuring data accuracy and quality in various applications.