
Lead Engineer - II_ETL Testing
Futran Solutions · Chicago, IL, United States
Weak hiring record · median 69 days open
- First seen
- 11 November 2026
- Reposted
- Not since September 2026
- Last checked
- Today · still on the employer's board
All reasons
- Open 68 days
- 53% of this employer's openings are over 60 days old
In its favour
- Still listed on the employer's own board
Lead Engineer - II_ETL Testing
Chicago, IL - In person interview and 3 days WFO.
Job Description
ETL Tester with AI Experience
What is in it for you?
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 to join our team in Chicago, IL
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.
Experience: -
10+ Years
Location: -
Chicago, IL (Hybrid – 3 days' Work from Office)
Duration: -
Contract role with CitiusTech
Educational Qualifications: -
Engineering Degree – BE/ME/BTech/MTech/BSc/MSc.
Technical certification in multiple technologies is desirable.
Skills: -
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.
Skills
- ETL
- QA
- Agentic AI
More jobs at Futran Solutions
All 541- .Net Full stack EngineerFutran Solutions · Mississauga, ON, Canadayesterday
- .NET Fullstack EngineerFutran Solutions · Canadayesterday
- SDETFutran Solutions · New Jersey · United Statesyesterday
- Senior Microsoft 365 AdministratorFutran Solutions · Northville, MI, United Statesyesterday
- Platform Architect with Java Full Stack/PythonFutran Solutions · Alpharetta, GA, United States · USD 49–54/hryesterday
Similar roles
- US_East | Data Engineer_L2Datum Software · ILtoday
- Data Engineer - RemoteGenesis10 · Charlotte, NC · USD 10–63/hrtoday
- Data Engineer - RemoteGenesis10 · Charlotte, NC · USD 10–63/hrtoday
- Data Engineer - RemoteGenesis10 · Charlotte, NC · USD 10–63/hrtoday
- Data Engineer - RemoteGenesis10 · Charlotte, NC · USD 10–63/hrtoday
- Data Engineer - RemoteGenesis10 · Charlotte, NC · USD 10–63/hrtoday