Data Test Engineer

This is a fully remote position, open to applicants in Illinois.

📋 Description

• Analyze user stories, interface requirements, data mappings, transformation rules, business rules, and source-to-target specifications to determine data test conditions and acceptance criteria.

• Design, develop, and sustain data test cases, SQL queries, reconciliation checks, test data sets, and expected results for SAP S/4HANA and associated applications.

• Confirm data accuracy, completeness, consistency, integrity, referential relationships, formats, transformations, and adherence to business rules across both source and target systems.

• Conduct testing for data extraction, cleansing, transformation, loading, conversion, and reconciliation tasks.

• Validate migrated data against established source-to-target rules.

• Verify inbound and outbound data exchanged between SAP S/4HANA, SAP Fiori, Mendix applications, interfaces, and external systems.

• Test error handling and exception processing mechanisms.

• Document data defects with queries, evidence, expected versus actual results, and reproducible conditions.

• Monitor issues until resolution and perform retesting as necessary.

• Create and maintain data test plans, test cases, test evidence, traceability, reconciliation results, and data-quality reports.

• Collaborate with data engineers, developers, functional analysts, business stakeholders, and integration teams.

• Engage in sprint planning, daily stand-ups, retrospectives, and other Agile ceremonies.

• Identify opportunities to enhance data testing methods, reusable SQL validation, automation, reporting, and data quality controls.

⛳️ Requirements

• Active Secret clearance (mandatory).

• Bachelor's degree in Computer Science, Information Technology, Data Analytics, Engineering, or a related field (or equivalent professional experience).

• At least 5 years of experience in software testing, with a minimum of 2 years focused on data testing for large-scale enterprise or ERP systems.

• Practical experience in data validation, ETL/ELT testing, source-to-target reconciliation, data migration/conversion testing, and data quality testing.

• Strong SQL proficiency for querying, comparing, aggregating, reconciling, and troubleshooting data across relational databases.

• Solid understanding of the SAFe Framework, SDLC, and Agile development methodologies.

• Exceptional analytical and problem-solving skills.

• Keen attention to detail.

• Strong written and verbal communication capabilities.

• Ability to work both independently and as part of a team.

• Experience with data profiling, ETL tools, APIs, flat files, XML/JSON, and data comparison or reconciliation tools.

• Experience testing SAP S/4HANA or similar ERP data, workflows, integrations, interfaces, or migration activities.

• Familiarity with ServiceNow CWM (Collaborative Work Management) or a similar platform.

🏝️ Benefits

• Flexible time off benefit.

• Comprehensive learning resources.

• Healthcare benefits.

• Wellness benefits.

• Financial benefits.

• Retirement benefits.

• Family support benefits.

• Continuing education benefits.

• Competitive compensation.

• Opportunities for learning and development.