Data Test Engineer

CACI • Scott AFB, IL

5d

About The Position

The Data Test Engineer will support USTRANSCOM’s Joint Transportation Management System (JTMS), a mission-critical enterprise platform modernizing transportation, logistics, and financial operations through SAP S/4HANA ERP integration. The role validates data quality, transformation, migration, interfaces, and reconciliation across the implementation, helping ensure data is accurate, complete, consistent, and reliable.

The engineer works with developers, data engineers, business analysts, functional teams, and product owners in a SAFe Agile environment. Responsibilities include analyzing requirements and data specifications; creating and executing data tests and SQL validations; testing migrations and integrations; managing defects and documentation; and improving testing methods and data-quality controls.

Requirements

• Active Secret security clearance.
• Bachelor’s degree in Computer Science, Information Technology, Data Analytics, Engineering, or a related field, or equivalent professional experience.
• At least 5 years of software testing experience, including at least 2 years dedicated to data testing for large-scale enterprise or ERP systems.
• Hands-on experience with data validation, ETL/ELT testing, source-to-target reconciliation, data migration/conversion testing, and data-quality testing.
• Strong SQL skills for querying, comparing, aggregating, reconciling, and troubleshooting data across relational databases.
• Strong working knowledge of the SAFe Framework, SDLC, and Agile development practices.
• Excellent analytical and problem-solving abilities, attention to detail, strong written and verbal communication skills, and ability to work independently and collaboratively.

Nice To Haves

• Experience with data profiling, ETL tools, APIs, flat files, XML/JSON, and data comparison or reconciliation utilities.
• Experience testing SAP S/4HANA or comparable ERP data, workflows, integrations, interfaces, or migration activities.
• Experience with ServiceNow CWM (Collaborative Work Management) or a comparable tool.

Responsibilities

• Review user stories, interface requirements, data mappings, transformation rules, business rules, and source-to-target specifications to identify test conditions and acceptance criteria.
• Design, build, and maintain data test cases, SQL queries, reconciliation checks, test data sets, and expected results for SAP S/4HANA and integrated applications.
• Validate data accuracy, completeness, consistency, integrity, referential relationships, formats, transformations, and compliance with business rules across source and target systems.
• Test data extraction, cleansing, transformation, loading, conversion, and reconciliation activities, and verify migrated data against approved source-to-target rules.
• Validate inbound and outbound data exchanged among SAP S/4HANA, SAP Fiori, Mendix applications, interfaces, and external systems, including error handling and exception processing.
• Document data defects with queries, evidence, expected and actual results, and reproducible conditions; track issues through resolution and retest.
• Create and maintain data test plans, test cases, test evidence, traceability, reconciliation results, and data-quality reports aligned with SAFe Agile practices.
• Collaborate with data engineers, developers, functional analysts, business stakeholders, and integration teams to resolve data issues and maximize test coverage.
• Participate in sprint planning, daily stand-ups, retrospectives, and other Agile ceremonies.
• Identify opportunities to improve data-testing methods, reusable SQL validation, automation, reporting, and data-quality controls.

Benefits

• Flexible time off benefit.
• Learning resources and learning and development opportunities.
• Healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.
• Competitive compensation and benefits options designed to support and protect employees and their families.

What This Job Offers

• Job Type: Full-time