Software Tester

TalentOla; Chicago (IL); On-site; USD 120,000 - 180,000; Full time

Job summary

TalentOla in Chicago is seeking a Senior QA professional to lead data validation for AI-assisted extraction and transformation. You will own test strategy across ETL, validation and automation, ensuring data integrity and regulatory compliance in a scalable path.

You will design source-to-target validation, establish risk-based priorities, and build automated regression harnesses across Databricks, SQL Server and Vertica, with emphasis on precision and recall metrics and governance.

Qualifications

• 10+ years in data / ETL testing with strategy ownership on large migrations.
• Proven reconciliation and equivalence testing defending conclusions to stakeholders.
• Expert SQL with complex validation queries against unfamiliar schemas.
• Databricks / PySpark for validation; Python for test automation.
• Experience testing PHI-scoped healthcare data and synthetic data helpful.
• Defect management and reporting in Azure Boards; team leadership experience.
• Preferred: evaluating LLM/GenAI systems with MLflow, LangSmith, Weights & Biases.

Responsibilities

• Own test strategy and reconciliation methodology for data validation.
• Define equivalence standards and where they apply in the data path.
• Design source-to-target validation across ingestion and transformation.
• Establish risk-based prioritisation and build a test plan for client review.
• Author test strategy and plan; evaluate agents with a golden reference set.
• Stand up an evaluation harness in MLflow for scoring and comparison.
• Define measures for precision, recall, override rate, calibration and cost.
• Operate the regression gate; ensure no prompt or model change passes without evaluation.
• Characterise failure modes: hallucinated outputs, wrong column selection, data leaks.
• Lead automated regression harness; repeatable execution for agent revisions.
• Design cross-member isolation tests; ensure regulatory-compliant data access.
• Produce evidence packs for executive review; defend methodology and sample sizes.

Skills

ETL testing

SQL

Azure Databricks

Agentic AI evaluation

Web testing

Test automation tools

Tools

Great Expectations

dbt tests

pytest

MLflow

LangSmith

Weights & Biases

Databricks

SQL Server

Vertica

Azure Boards

Job description

Looking for a Senior QA professional skilled in ETL, SQL, Azure Databricks, Agentic AI evaluation, web testing, and test automation tools, driving data integrity, compliance, and scalable validation strategies

Roles and Responsibilities

• We are building AI agents that generate the extraction queries and transformation logic instead plus the Workbench through which humans review and approve everything they produce.
• The agents emit metadata; the client's existing data platform executes it. What you'll do Own test strategy and reconciliation methodology Define the equivalence standard: what must match exactly, what may vary within tolerance, and at which layer each applies Design source-to-target validation across the redesigned path - raw ingestion, consolidated transformation, domain refined
• Establish risk-based prioritisation; the schedule does not permit exhaustive coverage of hundreds of tables Author the Test Strategy and Test Plan for review with the client in Phase 2 Own agent evaluation Build and maintain a golden reference set from existing production extracts, validated with the Epic SME, with strict separation between evaluation data and anything used to develop or tune the agents Stand up the evaluation harness in MLflow - scoring runs, versioning, candidate comparison
• Define and report the measures that matter mapping precision and recall, override rate, confidence calibration, run-to-run consistency, escalation correctness and cost per case Operate the regression gate - no prompt, skill or model change is promoted without passing evaluation.
• A prompt change can silently degrade quality with no data-level symptom Characterise how agents fail, not just how often: hallucinated tables, plausible-but-wrong column selection, silent omission of required fields, mis-selected join grain.
• Own the automated regression harness Automated comparison of new-path output against current production extracts Row counts, aggregate reconciliation, field-level comparison, type and precision validation, null and duplicate profiling, referential integrity Repeatable execution so every agent revision can be re-validated cheaply
• Design the control-critical test suites Member, health-system and facility isolation. Facility mapping is moving downstream, creating real regression risk against the guarantee that one member cannot see another member's data.
• A cross-member leak is the highest-severity failure mode on this engagement Contract-scope validation.
• Data-sharing contracts restrict access at facility, column and product level. Verifying that generated queries stay inside permitted scope is a testable control with legal consequences if missed Acquisition cost validation.
• Confirm optimised queries touch fewer source tables than baseline and that facility consolidation genuinely works Lead and report Direct two QA engineers; set standards, review coverage, own the defect taxonomy
• Confirm downstream compatibility across Databricks, SQL Server and Vertica Produce evidence packs suitable for client executive review, and defend methodology, sample sizes and statistical claims under scrutiny.

Mandatory skills

• 10+ years 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 prioritisation, 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.