Data Test Engineer

CACI • Scott AFB, IL

7d • $75,200 - $158,100

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 a large-scale SAP implementation, helping ensure data is accurate, complete, consistent, and reliable. The engineer collaborates with developers, data engineers, business analysts, functional teams, and product owners in a SAFe Agile environment.

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.
• Strong analytical and problem-solving abilities, attention to detail, 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 data 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 business-rule compliance 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.
• Healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level