Healthcare Data Quality & 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

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.