Senior Data Quality & Test Automation Engineer (Hybrid)

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

Job summary

ELLKAY is seeking a Senior Data Quality and Test Automation Engineer in Indiana to design and implement automated validation for data pipelines, interfaces, transformations, migrations, and reconciliations, with emphasis on regulated healthcare data and PHI.

You will lead risk-based testing strategies, build reusable automation, and integrate checks into CI/CD. Collaboration with multiple teams is essential to ensure data integrity across diverse healthcare domains.

Qualifications

• Bachelor's degree in CS/engineering or equivalent practical experience.
• Typically 6+ years in software or data quality engineering, including automation for ETL, integration, analytics, or migration testing.
• Advanced SQL skills and strong programming in Python, Java, or C#, with automated data-testing experience.
• Working knowledge of data warehouses, APIs, and CI/CD practices.
• Strong healthcare data knowledge, HIPAA/PHI handling, auditability, and controlled test-data practices.
• Ability to interpret complex mappings and communicate findings clearly to technical and business stakeholders.

Responsibilities

• Define risk-based data quality and test strategies for healthcare data products, ETL/ELT pipelines, interfaces, warehouses, and migrations.
• Build reusable automation that validates schema, format, completeness, accuracy, uniqueness, referential integrity, and lineage.
• Test healthcare data across claims, eligibility, enrollment, member, provider, clinical, encounter, pharmacy, laboratory, and financial areas.
• Validate formats and standards including CSV, JSON, XML, HL7 v2, FHIR, Parquet/Avro.
• Review mappings, rules, and data contracts to identify ambiguity and quality risks.
• Automate source-to-target comparisons, control totals, balancing, and reconciliation.
• Create test data and masked datasets representing healthcare scenarios while protecting PHI.
• Validate batch, streaming, API, file-transfer, and event-driven integrations including late-arriving data and retries.
• Lead data migration testing from profiling to post-migration reconciliation and production validation.
• Integrate automated checks into CI/CD and publish quality results and diagnostics.
• Collaborate with data engineering, product, analytics, clinical, compliance, and QA teams to triage defects.
• Establish quality metrics and observability for data defects, drift, and pipeline reliability.

Skills

Advanced SQL

Python/Java/C#

CI/CD practices

Healthcare data

Data quality

Stakeholder communication

Education

B.S. in CS/Engineering

Tools

CI/CD tooling

Data warehouses

Healthcare data standards

Job description

ELLKAY is seeking a Senior Data Quality and Test Automation Engineer in Indiana to design and implement automated validation for data pipelines, interfaces, transformations, migrations, and reconciliations, with emphasis on regulated healthcare data and PHI.

You will lead risk-based testing strategies, build reusable automation, and integrate checks into CI/CD. Collaboration with multiple teams is essential to ensure data integrity across diverse healthcare domains.