Senior Data Quality and Test Automation Engineer

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

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.

Senior Data Quality and Test Automation Engineer

Engineering Shared Services Full Time IN

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:

The Senior Data Quality and Test Automation Engineer ensures that healthcare data remains accurate, complete, consistent, secure, and traceable as it moves across source systems, integration layers, data platforms, and consumer applications. This role designs and implements automated validation for data pipelines, interfaces, transformations, migrations, and reconciliations, with particular attention to regulated healthcare data and PHI.

Key responsibilities

• Define risk-based data quality and test strategies for healthcare data products, ETL and ELT pipelines, interfaces, warehouses, and migration programs.
• Build reusable automation that validates schema, format, completeness, accuracy, uniqueness, referential integrity, timeliness, lineage, transformation logic, and source-to-target reconciliation.
• Test healthcare data across claims, eligibility, enrollment, member, provider, clinical, encounter, pharmacy, laboratory, authorization, and financial subject areas.
• Validate structured and semi-structured formats and standards, including relational data, CSV, fixed-width files, JSON, XML, Parquet or Avro, HL7 v2, FHIR resources.
• Review mapping specifications, transformation rules, code-set crosswalks, business rules, and data contracts; identify ambiguity, gaps, and downstream quality risks before implementation.
• Automate source-to-target comparisons, control totals, balancing, duplicate detection, exception reporting, and historical or incremental-load validation using SQL and a general-purpose programming language.
• Create test data and synthetic or masked datasets that represent realistic healthcare scenarios while protecting PHI and complying with organizational privacy controls.
• Validate batch, streaming, API, file-transfer, and event-driven integrations, including late-arriving data, replay, error handling, retries, idempotency, and recovery behavior.
• Lead data migration testing across profiling, cleansing, conversion, cutover rehearsal, rollback, post-migration reconciliation, and production validation.
• Integrate automated checks into CI/CD and data orchestration workflows; publish actionable quality results, thresholds, and failure diagnostics.
• Partner with data engineering, product, analytics, clinical, compliance, and QA teams to triage defects, determine root cause, and prevent recurrence.
• Establish quality metrics and observability for data defects, rejected records, drift, reconciliation variance, rule coverage, and pipeline reliability.

Required qualifications

• Bachelor's degree in computer science, engineering, information systems, data science, or equivalent practical experience.
• Typically 6+ years in software or data quality engineering, including substantial hands-on automation for ETL, integration, analytics, or migration testing.
• Advanced SQL skills and strong programming experience in Python, Java, C#, or a comparable language; experience with automated data-testing frameworks and version control.
• Working knowledge of data warehouses platforms, APIs, message or file-based integrations, and CI/CD practices.
• Strong healthcare data knowledge and an understanding of HIPAA, PHI handling, auditability, and controlled test-data practices.
• Ability to interpret complex mappings, isolate data defects across multiple layers, and communicate findings clearly to technical and business stakeholders.

Preferred qualifications

• Experience with cloud data platforms, distributed processing, data catalog or lineage tools, and data observability solutions.
• Familiarity with healthcare interoperability and terminology standards such as FHIR, HL7, X12, ICD-10, CPT, HCPCS, LOINC, SNOMED CT, or RxNorm.

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.