ETL Tester at Arkhya Tech Inc. Chicago, IL

Arkhya Tech Inc.; Chicago (IL); On-site; USD 120,000 - 170,000; Full time

Job summary

Healing Strides Counseling in Chicago is seeking a Senior Data QA Engineer to lead data validation across large migration projects. You will own ETL testing strategy, ensure output equivalence with legacy systems, and drive data quality through automated frameworks. Strong SQL and experience with Databricks are essential.

Ideal candidates will have PHI data testing exposure, stakeholder communication skills, and the ability to mentor teams while presenting evidence to executives.

Qualifications

• Extensive ETL testing experience with strategy ownership on large migrations.
• Ability to prove data equivalence between rebuilt and legacy pipelines.
• Advanced SQL with validation against unfamiliar schemas.
• Experience with data quality frameworks and test automation tooling.
• Familiarity with PHI healthcare data testing and governance.
• Defect management and reporting using Azure Boards.
• Leadership in setting coverage standards and reviewing teams.
• Comfort arguing quality positions with senior stakeholders.
• Preferred exposure to evaluating LLM/GenAI systems and related tooling.
• Applied statistics methods for sampling, confidence intervals and significance tests.

Responsibilities

• Design and execute validation strategies for data pipelines.
• Perform multi-database validation and ensure output equivalence.
• Develop and maintain data quality tests and automation harnesses.
• Lead testing teams and communicate risk-based priorities.
• Present test evidence to clients and executives when required.

Skills

ETL testing

Reconciliation testing

SQL

Data quality

Test automation

Test strategy

Stakeholder management

Team leadership

Statistics

Code/test quality practices

Software design

Continuous learning

ETL

Education

PHI healthcare data experience

Tools

Great Expectations

dbt tests

pytest

Azure Boards

MLflow

LangSmith

Weights & Biases

Epic EHR data

Caboodle/Clarity

Databricks

SQL Server/Vertica

Job description

• Experience in data / ETL testing, including strategy ownership on at least one large migration or re-platforming programme
• Proven reconciliation and equivalence testing — demonstrating that a rebuilt pipeline produces output equivalent to a legacy one, and defending that conclusion to stakeholders
• Expert SQL — complex analytical validation queries written independently against unfamiliar schemas Databricks / PySpark for validation at data volume Python for test automation and harness development
• Data quality and test automation frameworks — Great Expectations, dbt tests, pytest or equivalent Test strategy authorship — coverage models, risk-based prioritization, entry and exit criteria, defect taxonomy multi-target validation across at least two of Databricks, SQL Server, Vertica or comparable
• Experience testing PHI-scoped healthcare data, including de-identified or synthetic test data Defect management and reporting in Azure Boards Team leadership — setting standards and reviewing others' coverage
• Ability to state an uncomfortable quality position to senior stakeholders and hold it Preferred Experience evaluating LLM or GenAI systems — MLflow, LangSmith, Weights & Biases or equivalent; LLM-as-judge design and its failure modes Applied statistics — sampling design, confidence intervals, significance testing, calibration measurement Epic EHR data experience
• Caboodle or Clarity Clinical coding systems: ICD, CPT, SNOMED, LOINC Multi-tenant data isolation testing Experience testing code- or SQL-generation systems Prior work where test evidence was presented directly to client executives
• Software Design and Best Practices: Apply software design principles such as SOLID and Domain-Driven Design.
• Understand code patterns and practices.
• Maintain currency in technical skills and industry trends.
• Skills ETL, SQL, Azure Databricks, Agentic AI testing, Web testing Any Data Automation tool.