Senior Data Quality, Test Automation Engineer

This is a fully remote position, open to applicants in Illinois.

📋 Description

• Independently verify data pipelines, schemas, transformation logic, calculations, datasets, and reporting outputs against established requirements and business rules

• Create SQL reconciliation tests that compare source data with intermediate datasets, warehouse tables, analytical outputs, dashboards, and reports

• Confirm record counts, totals, aggregations, joins, mappings, calculated fields, and source-to-target completeness

• Evaluate data schemas, field types, required values, relationships, referential integrity, and handling of schema changes

• Develop automated regression checks for updates to pipelines, schemas, calculations, applications, and reporting

• Validate data-quality controls for accuracy, completeness, consistency, uniqueness, validity, and timeliness

• Create access tests for authorized access, role restrictions, data visibility, and behaviors of unauthorized users

• Assess data freshness, refresh schedules, processing latency, pipeline execution times, and performance of reporting

• Validate error handling for missing, duplicate, malformed, late-arriving, or invalid data

• Maintain consistent test datasets, expected results, reconciliation rules, and automated dataset checks

• Ensure training, validation, testing, and analytical datasets comply with documented quality and preparation standards

• Preserve traceability among requirements, business rules, test cases, test data, execution results, defects, and retest evidence

• Integrate automated data-quality and regression checks into sanctioned delivery pipelines and scheduled validation processes

• Document testing procedures, execution results, supporting queries, discrepancies, and reproducible evidence

• Log and monitor defects, coordinate investigations, and confirm corrections through retesting

• Evaluate the impact of data or calculation defects on downstream models, dashboards, reports, and mission-critical decisions

• Assist in user acceptance testing by preparing validated datasets, reconciling expected results, and exploring discrepancies

• Communicate test status, defect trends, unresolved risks, and release-readiness findings to technical teams and Government stakeholders

• Maintain test documentation, defect logs, dataset checks, and retest results for program evaluations and inspections

• Enhance test coverage and automation based on recurring defects, production insights, and lessons learned

• Collaborate with data engineers, AI/ML engineers, business analysts, developers, cybersecurity personnel, and Government stakeholders

⛳️ Requirements

• Active Secret clearance or higher

• Minimum of eight years of pertinent professional experience

• Bachelor’s degree in computer science, information systems, data analytics, or a related field, or an acceptable equivalent

• Proficiency in developing and executing SQL reconciliation tests

• Experience in validating data pipelines

• Background in developing or maintaining automated regression tests

• Familiarity with access testing

• Experience in implementing or validating data-quality controls

• Capability to independently validate schemas, calculations, datasets, and reporting outputs

• Skill in developing and executing data freshness and performance tests

• Ability to maintain test evidence, defect logs, dataset checks, and retest outcomes

• CompTIA Security+ CE or another approved IAT Level II certification relevant to assigned responsibilities

🏝️ Benefits

• Regular full-time employment

• Remote work arrangement

• Preference for candidates in the Chicago area

• Opportunity to contribute to a USMEPCOM ENLIST government contract program

• Equal employment opportunity and affirmative action protections