Senior Data Quality, Test Automation Engineer

DecisionPoint Corporation

. Independently validate data pipelines, schemas, transformation logic, calculations, datasets, and reporting outputs against documented requirements and business rules .

Posted 10/28/2026full-timeRemote • Illinois • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in validating data pipelines, schemas, and reporting outputs while ensuring data quality and integrity through automated testing and reconciliation processes. Proficient in SQL and experienced in collaborating with cross-functional teams to support data-driven decision-making.

Highest-signal resume keywords

SQL Reconciliation TestingData Pipeline ValidationAutomated Regression TestingData Quality Control ImplementationAccess Testing

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ValidationSQL DevelopmentAutomated TestingData Freshness TestingPerformance TestingSchema ValidationDefect TrackingData Quality AssuranceTest DocumentationData Analysis

Soft Skills

CollaborationProblem-SolvingAttention to DetailCommunication

Certifications & Qualifications

CompTIA Security+ CEActive Secret Clearance

Industry Keywords

Data AnalyticsData EngineeringBusiness RulesUser Acceptance TestingGovernment Stakeholders

Tech Stack

Tools & technologies

Cyber SecuritySQL

About the role

Key responsibilities & impact

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 schema-change handling
Build automated regression checks for pipeline, schema, calculation, application, and reporting updates
Validate data-quality controls for accuracy, completeness, consistency, uniqueness, validity, and timeliness
Develop access tests for authorized access, role restrictions, data visibility, and unauthorized-user behavior
Test data freshness, refresh schedules, processing latency, pipeline execution times, and reporting performance
Validate error handling for missing, duplicate, malformed, late-arriving, or invalid data
Maintain repeatable test datasets, expected results, reconciliation rules, and automated dataset checks
Verify training, validation, testing, and analytical datasets meet 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 investigations, 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 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
Collaborate with data engineers, AI/ML engineers, business analysts, developers, cybersecurity personnel, and Government stakeholders

Requirements

What you’ll need

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

Benefits

Comp & perks

Regular full-time employment
Remote work arrangement
Chicago-area candidates preferred
Opportunity to support a USMEPCOM ENLIST government contract program
Equal employment opportunity and affirmative action protections