Data Quality & Test Automation Engineer (Senior)

DecisionPoint Corporation

United States

Remote

USD 120,000 - 180,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

DecisionPoint Corporation seeks a Senior Data Quality & Test Automation Engineer to independently validate data pipelines, schemas, calculations, datasets, and reporting outputs. You will develop SQL reconciliation tests and automated regression checks to ensure data accuracy, completeness, and traceability across source to target systems.

The role collaborates with data engineers, AI/ML engineers, and government stakeholders, emphasizes data-quality controls, and supports validation of

Qualifications

  • Active Secret clearance or higher.
  • Eight years of relevant professional experience.
  • Experience developing and executing SQL reconciliation tests.
  • Experience validating data pipelines.
  • Experience developing or maintaining automated regression tests.
  • Experience performing access testing and data-quality controls.

Responsibilities

  • Independently validate data pipelines, schemas, transformations, and reports against requirements.
  • Develop SQL reconciliation tests between source data and outputs.
  • Verify record counts, totals, joins, mappings, and source-to-target completeness.
  • Test data schemas, field types, required values, and referential integrity.
  • Build automated regression checks for pipeline, schema, and reporting updates.
  • Validate data-quality controls for accuracy and timeliness.
  • Develop access tests for authorized/unauthorized data access.
  • Test data freshness, processing latency, and reporting performance.
  • Record defects, coordinate with teams, and verify corrections.

Skills

Independent validation
SQL testing
Data quality controls
Regression testing
Data pipelines validation
Test automation

Education

Bachelor's degree in CS/IS/Data Analytics
CompTIA Security+ CE

Tools

SQL
Power BI
Python
CI/CD

Job description

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
  • 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
  • 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
  • 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 Affi... ... Policy

DecisionPoint Corporation is an Equal Employment Opportunity and Aff…tion 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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Data/ETL Engineer
Lead Data/ETL Engineer

DecisionPoint Corporation • United States

Remote
USD 140,000 - 180,000
Data/ETL Engineer (Journeyman)
Data/ETL Engineer (Journeyman)

DecisionPoint Corporation • United States

Remote
USD 110,000 - 150,000
Software Developer (Journeyman)
Software Developer (Journeyman)

DecisionPoint Corporation • United States

Remote
USD 110,000 - 170,000
Data/ETL Engineer (Senior)
Data/ETL Engineer (Senior)

DecisionPoint Corporation • United States

Remote
USD 120,000 - 180,000
API/Integration Engineer (Journeyman)
API/Integration Engineer (Journeyman)

DecisionPoint Corporation • United States

Remote
USD 120,000 - 170,000
AI/ML, MLOps Engineer
AI/ML, MLOps Engineer

DecisionPoint Corporation • United States

Remote
USD 180,000 - 240,000
QA/Test Automation Engineer (Senior)
QA/Test Automation Engineer (Senior)

DecisionPoint Corporation • United States

Remote
USD 95,000 - 135,000
QA Specialist - Program Quality (Journeyman)
QA Specialist - Program Quality (Journeyman)

DecisionPoint Corporation • Chicago (IL)

Remote
USD 80,000 - 110,000
Remote work
Integration/Test Automation Engineer (Journeyman)
Integration/Test Automation Engineer (Journeyman)

DecisionPoint Corporation • United States

Remote
USD 110,000 - 150,000
AI/Cloud Engineer/Architect
AI/Cloud Engineer/Architect

DecisionPoint Corporation • United States

Remote
USD 60,000 - 100,000