Overview DecisionPoint seeks a
Senior Data Quality & Test Automation Engineer to independently validate data pipelines, schemas, calculations, datasets, and reporting outputs supporting the USMEPCOM ENLIST program's AI integration and data analysis activities.
This position will develop SQL reconciliation tests, automated regression checks, access tests, and data freshness and performance tests. The engineer will verify that data remains accurate, complete, consistent, appropriately accessible, and traceable as it moves from source systems through transformations, warehouses, analytical models, dashboards, and reports.
The Data Quality & Test Automation Engineer will work with data engineers, AI/ML engineers, business analysts, developers, cybersecurity personnel, and Government stakeholders to identify defects, document evidence, verify corrections, and provide independent assessments of data and reporting quality.
This position is remote, with Chicago-area candidates preferred.
Note: By applying to this position, you acknowledge and consent to having your resume included in an active competitive government contract bid.
Duties & Responsibilities The Data Quality & Test Automation Engineer will:
- Independently validate data pipelines, schemas, transformation logic, calculations, datasets, and reporting outputs against documented requirements and business rules.
- Develop SQL reconciliation tests comparing source data with intermediate datasets, warehouse tables, analytical outputs, dashboards, and reports.
- Verify record counts, totals, aggregations, joins, mappings, calculated fields, and source-to-target completeness.
- Test data schemas, field types, required values, relationships, referential integrity, and handling of schema changes.
- Build automated regression checks to detect unintended changes following pipeline, schema, calculation, application, or reporting updates.
- Validate data-quality controls for accuracy, completeness, consistency, uniqueness, validity, and timeliness.
- Develop access tests to verify authorized access, role restrictions, data visibility, and expected behavior for unauthorized users.
- Test data freshness, refresh schedules, processing latency, pipeline execution times, and reporting performance.
- Validate error handling for missing, duplicate, malformed, late-arriving, or otherwise invalid data.
- Maintain repeatable test datasets, expected results, reconciliation rules, and automated dataset checks.
- Verify that training, validation, testing, and analytical datasets meet their documented quality and preparation requirements.
- Maintain traceability among requirements, business rules, test cases, test data, execution results, defects, and retest evidence.
- Integrate automated data-quality and regression checks into approved delivery pipelines and scheduled validation processes.
- Document test procedures, execution results, supporting queries, discrepancies, and reproducible evidence.
- Record and track defects, coordinate investigation with responsible teams, and verify corrections through retesting.
- Assess the effect of data or calculation defects on downstream models, dashboards, reports, and mission decisions.
- Support user acceptance testing by preparing validated datasets, reconciling expected results, and investigating reported discrepancies.
- Provide test status, defect trends, unresolved risks, and release-readiness findings to technical teams and Government stakeholders.
- Maintain test documentation, defect records, dataset checks, and retest results for program reviews and inspections.
- Improve test coverage and automation based on recurring defects, production findings, and lessons learned.
Qualifications Required Qualifications The following must-have qualifications are drawn from the supplied position requirements:
- Active Secret clearance or higher.
- Minimum of eight years of relevant professional experience.
- Bachelor's degree in computer science, information systems, data analytics, or a related field, or a permitted equivalent.
- Experience developing and executing SQL reconciliation tests.
- Experience validating data pipelines.
- Experience developing or maintaining automated regression tests.
- Experience performing access testing.
- Experience implementing or validating data-quality controls.
- Ability to independently validate schemas, calculations, datasets, and reporting outputs.
- Ability to develop and execute data freshness and performance tests.
- Ability to maintain test evidence, defect records, dataset checks, and retest results.
- CompTIA Security+ CE or another approved IAT Level II certification when applicable to assigned duties.
Preferred Qualifications The following qualifications are preferred but are not required:
- ISTQB test automation certification or Certified Data Management Professional (CDMP) certification.
- Experience supporting federal or Department of Defense data, analytics, or software programs.
- Experience testing data warehouses, ETL/ELT processes, data integrations, or analytical platforms.
- Experience validating Power BI or comparable dashboards, semantic models, calculated measures, and self-service reports.
- Experience with Python or another scripting language used for data testing and automation.
- Experience integrating automated tests into CI/CD pipelines.
- Familiarity with data lineage, metadata management, data governance, and controlled test environments.
- Experience validating datasets used by AI or machine learning systems.
- Strong analytical troubleshooting, technical documentation, and cross-team communication skills.
Our Equal Employment Opportunity Policy - EEO and Affirmative Action Policy: DecisionPoint Corporation is an Equal Employment Opportunity and Affirmative Action employer. It is the policy of DecisionPoint Corporation to provide equal employment opportunity in accordance with all applicable Equal Employment Opportunity/Affirmative Action laws, directives and regulations to all employees and qualified applicants without regard to race, ethnicity, color, religion, national origin, sex, age, disability status, pregnancy, sexual orientation, gender identity, genetic information, protected veteran status, or any other protected status under Federal, State or Local laws.
- Pay Transparency Policy: In accordance with Presidential Executive Order 13665, DecisionPoint Corporation will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.
- Authorization to Share Resume and Personal Information: By expressing your interest and submitting your resume for this position, you authorize DecisionPoint Corporation to share your resume, as well as personal information included on the resume, with its subsidiaries, affiliates and teaming partners for the purpose of considering you for this position and other available positions requiring comparable skills, education and experience. Should DecisionPoint Corporation. or its affiliates and teaming partners wish to initiate pre-employment discussions, you will be asked to complete an employment application and related employment documents.
