Data Quality and Test Automation Engineer

Ellkay, Llc; Indiana; Hybrid; USD 75,000 - 110,000; Full time

Job summary

ELLKAY seeks a Data Quality and Test Automation Engineer to develop, execute, and maintain automated tests for healthcare data pipelines using SQL and Python. You will validate mappings, ensure data quality, and collaborate with data engineers, product QEs, and analysts in a hybrid work environment.

The role emphasizes CI/CD testing, data privacy, and reproducible evidence of defects, with opportunities to work with cloud platforms and modern data-testing frameworks.

Qualifications

• 3+ years in software testing, quality engineering, or data validation.
• 2+ years validating ETL/ELT processes or databases.
• Hands-on SQL and Python for automated data checks.
• Experience with Git, defect tracking, and CI/CD workflows.
• Ability to explain data discrepancies and produce reproducible evidence.

Responsibilities

• Develop, execute, and maintain SQL- and Python-based automated checks.
• Validate data mappings, completeness, accuracy, and referential integrity.
• Reconcile source-to-target records across ingestion, transformation, and reporting.
• Collaborate with Data Engineers, product QEs, analysts, and SMEs.
• Run data regression tests in CI/CD pipelines and document results.
• Prepare synthetic or masked datasets following privacy rules.
• Use AI tools to assist with SQL, Python, and test scenarios.

Skills

SQL

Python

ETL/ELT validation

Data validation

Git

CI/CD

Education

Bachelor's degree in CS/Engineering/IS

Tools

pytest

dbt tests

Great Expectations

Databricks

Snowflake

Azure/AWS/GCP

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Quality and Test Automation Engineer

Engineering Shared Services Full Time IN

2 days ago Requisition ID: 1414

ELLKAY started out providing connectivity solutions to laboratories and within a few years, grew to also provide data management solutions to ambulatory organizations. ELLKAY is now a trusted data management partner in five healthcare segments. ELLKAY’s solutions continue to serve laboratories and ambulatory practices and have expanded to empower hospitals and health systems, healthcare IT vendors, ambulatory practices, health plans, and other healthcare organizations with cutting-edge technologies and solutions that drive their growth and interoperability strategies. Today, ELLKAY remains true to our core values, building strong partner relationships and offering unparalleled service and support while providing innovative, scalable solutions to the challenges our customers face in today’s data-rich world. ELLKAY's experience, customer-focused approach, and reputation for innovation, speed, and accuracy differentiate ELLKAY as a premier partner for your interoperability needs and data management strategy.

Job Description:

Develop, execute, and maintain automated tests for healthcare data pipelines, integrations, transformations, and reporting outputs. Use SQL and Python to validate data mappings, reconcile source and target records, and identify missing, duplicate, inconsistent, or incorrectly transformed data. Work within established frameworks to provide dependable validation evidence and timely feedback on data quality.

Reporting and collaboration

Report to the Senior Manager QE Technology and Innovation and receive technical guidance from the Senior Data Quality Engineer and Principal Quality Architect. Collaborate with Data Engineering, product QEs, analysts, and the Healthcare SME to validate assigned data flows against documented business rules.

Key responsibilities

Review data requirements, source-to-target mappings, business rules, and acceptance criteria to identify test scenarios and expected results.

Develop and maintain SQL- and Python-based automated checks using approved data-testing frameworks and reusable utilities.

Validate data completeness, accuracy, consistency, timeliness, uniqueness, and referential integrity across assigned datasets.

Reconcile source and target records, counts, totals, and key attributes across ingestion, transformation, and reporting layers.

Test batch and incremental loads, schema changes, error handling, retries, and recovery scenarios under senior technical guidance.

Prepare approved synthetic or masked datasets and follow access, privacy, and sensitive healthcare data-handling procedures.

Execute data regression tests within CI/CD pipelines, analyze failures, and maintain clear validation results and test evidence.

Document reproducible data defects, collaborate with Data Engineers on investigation, and verify fixes and affected downstream outputs.

Use approved AI tools to assist with SQL, Python, test scenarios, and failure analysis while validating generated outputs and protecting sensitive data.

Maintain existing data-quality checks and alerts, contribute to code reviews, and add regression coverage for assigned production data issues.

Page

Experience and qualifications

3+ years in software testing, quality engineering, or data validation, including 2+ years of hands-on ETL/ELT or database testing and SQL-based validation. Experience may overlap.

Required qualifications

Bachelor's degree in computer science, engineering, information systems, or a related field, or equivalent practical experience.

3+ years of relevant testing or data-validation experience, including 2+ years validating data pipelines, transformations, or databases.

Hands-on SQL skills, including joins, aggregations, subqueries, and reconciliation queries across related datasets.

Working Python skills for automated data checks, test execution, result comparison, and debugging.

Understanding of ETL/ELT, relational data models, source-to-target mappings, data-quality dimensions, and batch or incremental processing.

Experience using Git, defect-tracking tools, and automated testing practices; familiarity with CI/CD workflows.

Ability to explain data discrepancies, produce reproducible evidence, collaborate with engineers, and handle confidential information responsibly.

Preferred qualifications

Healthcare data experience involving clinical, laboratory, patient, provider, claims, eligibility, or other relevant workflows.

Exposure to a cloud data platform such as Databricks, Snowflake, Azure, AWS, or GCP and frameworks such as pytest, dbt tests, or Great Expectations.

Familiarity with API or file-based integrations, HL7/FHIR where relevant, and approved AI coding or testing assistants.

Success measures

Reliable automated coverage of assigned critical data rules and reconciliation controls, with timely completion of planned validation work.

Clear, reproducible evidence for data defects and dependable verification of fixes and regression outcomes.

Reduced manual reconciliation effort and growing independence in SQL, Python, data testing, and failure investigation.

Working expectations

Collaborate with India engineering teams and U.S. stakeholders with agreed working-hour overlap. Follow shared testing standards and approved data-access policies, and support release validation and production data investigations under senior guidance.

Additional information

At ELLKAY, we are committed to operating as a hybrid workplace, offering employees flexibility in how they structure their time between in-office and remote work. We recognize the significance of fostering connections, collaboration, and creativity within our office culture and its positive impact on our business. Our philosophy of operating as a hybrid workplace underscores our dedication to enabling employees to tailor work-life balance to their individual preferences. For those who do not live within 40 miles of one of our offices, we are open to considering remote work for candidates whose skills and experience strongly align with the role. While we prioritize a hybrid work environment for most roles, we understand the importance of flexibility and are open to remote work for specific positions and specialized skill sets.

For more information on our company, visit www.ELLKAY.com.

ELLKAY LLC is a Smoke-Free Workplace.

ELLKAY, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.