Defect Management: Ability to analyze test failures, troubleshoot data issues, document defects, and coordinate resolution with development teams.
Agile Experience: Comfortable working in Agile environments and collaborating with cross-functional technical and business teams.
What the Client Needs You to Do
The primary objective is to ensure that previously developed data pipelines are functioning correctly and delivering accurate, reliable data across connected systems. The successful candidate will take ownership of ETL validation, develop Python-driven automation, investigate pipeline failures, and identify data quality issues.
This person will operate as a testing-focused engineering resource, similar to an SDET, working closely with developers, business analysts, and other stakeholders to resolve issues and improve overall pipeline reliability. The emphasis is on hands-on execution, automation, troubleshooting, and ensuring data integrity throughout the integration process.
Key Responsibilities
Perform comprehensive ETL testing to validate data extraction, transformation, and loading processes across enterprise data environments.
Validate source-to-target mappings, transformation rules, business logic, and data movement between integrated systems.
Develop, enhance, and maintain Python-based test automation frameworks for repeatable data pipeline testing.
Execute functional, integration, API, and regression testing to identify defects and ensure system stability.
Create detailed test plans, test scenarios, test cases, and testing strategies aligned with project requirements.
Write and execute complex SQL queries to verify data accuracy, completeness, consistency, and integrity.
Investigate pipeline failures, troubleshoot data discrepancies, analyze test execution results, and identify root causes.
Document, track, and prioritize defects while coordinating with development teams to support timely resolution.
Collaborate with developers, business analysts, product teams, and technical stakeholders within Agile delivery environments.
Identify opportunities to improve automation coverage, testing efficiency, and overall data quality processes.
Additional Information
Preferred Skills and Technologies
The following skills and experience would be beneficial
Generative AI: Exposure to Generative AI technologies and their application within software engineering or data environments.
Data Quality and Observability: Familiarity with data validation, data observability, and testing tools such as Great Expectations and dbt tests.
Python Testing Frameworks: Experience using Pytest for developing and executing automated test suites.
Healthcare Domain: Previous experience working with healthcare data, including familiarity with data privacy, regulatory requirements, and compliance considerations.
Cloud Technologies: Working knowledge of cloud-based data ecosystems and enterprise data platforms.
Streaming Technologies: Exposure to Kafka or other messaging and real-time data streaming platforms.
UI Automation: Familiarity with Playwright automation.
BDD Frameworks: Exposure to Gherkin syntax, Behavior-Driven Development (BDD), and Cucumber.
Technical Environment
ETL Testing and Data Pipeline Validation
Python Automation and Pytest
Complex SQL and Data Reconciliation
REST API Testing
Functional and Regression Testing
Data Quality and Data Integrity Validation
Agile / Scrum Methodologies
Cloud Data Ecosystems
Kafka and Streaming Technologies
Important Candidate Consideration: This is primarily an ETL testing and Python automation position, not a traditional data engineering or software QA role. Candidates must have practical experience testing Python-based data pipelines. ETL testing and Python automation are mandatory; the additional technologies are preferred rather than required.
W2 employees of Overture Partners who work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), 401(k) starting on day one, a variety of voluntary benefits including life and disability insurance, and sick time if required by law in the worked-in state/locality.
#25707