Data Analytics Tester

Socket.dev; O'Fallon (IL); On-site; USD 75,000 - 158,000; Full time

Job summary

CACI is seeking a Data Analytics Tester to validate data quality, dashboards, and end-to-end data flows within the JTMS SAP S/4HANA integration for USTRANSCOM. You will partner with developers, data engineers, analysts, and product owners to ensure accurate, complete, and trusted analytics for mission-critical decisions.

Responsibilities include analyzing requirements, building test data, executing source-to-target validation, documenting defects, and contributing to SAFe Agile ceremonies while

Qualifications

• Bachelor's degree or equivalent professional experience in a relevant field.
• 3+ years in data analytics development and testing, data testing, or quality assurance for large-scale systems.
• Strong SQL skills and experience with relational databases, data interfaces, ETL/ELT pipelines, and BI tools.

Responsibilities

• Requirements Analysis: Review user stories, data requirements, business rules, source-to-target mappings, and acceptance criteria to identify data and analytics test scenarios.
• Test Development: Design, build, and maintain test scripts and test data for data pipelines, ETL/ELT processes, interfaces, dashboards, reports, KPIs, and analytical outputs.
• Data and Analytics Testing: Execute source-to-target validation, data reconciliation, database testing, report and dashboard validation, and end-to-end data testing across JTMS within a SAFe Agile framework.
• Defect Management: Document data and analytics defects with detailed reproduction steps and supporting evidence, track issues to resolution, and communicate findings effectively to development and data teams.
• Stakeholder Collaboration: Work closely with developers, data engineers, business analysts, product owners, and business stakeholders to clarify data requirements and maximize test coverage.
• Test Documentation: Create and maintain comprehensive test plans, test cases, SQL validation queries, test data sets, reconciliation results, and traceability matrices aligned with SAFe Agile practices.
• Agile Participation: Actively engage in sprint planning, daily stand-ups, retrospectives, demonstrations, defect triage, and other Agile ceremonies.
• Continuous Improvement: Identify opportunities to improve data validation, analytics testing, test automation, data-quality controls, and quality assurance practices.

Skills

SQL

Power BI

Tableau

Data reconciliation

ETL/ELT testing

Dashboards & KPIs

Analytics validation

SAFe Framework

Education

Bachelor's degree in Computer Science / Information Technology / Data Analytics / Information Systems or related field

Tools

ServiceNow CWM

Job description

Job Title: Data Analytics TesterJob Category: EngineeringTime Type: Full timeMinimum Clearance Required to Start: SecretEmployee Type: RegularPercentage of Travel Required: Up to 10%Type of Travel: Continental US* * *

The Opportunity:

Join our team supporting USTRANSCOM's Joint Transportation Management System (JTMS), a mission-critical enterprise platform that modernizes transportation, logistics, and financial operations through SAP S/4HANA ERP integration. We're looking for an accomplished Data Analytics Tester to validate data quality, analytics, dashboards, reports, and end-to-end data flows across this large-scale SAP implementation. Your expertise in SQL-based validation, source-to-target reconciliation, ETL/ELT testing, and analytics verification will be essential to ensuring that JTMS data is accurate, complete, consistent, and reliable for operational and business decision-making. In this role, you'll partner with cross-functional teams—including developers, data engineers, business analysts, and product owners—to deliver trusted, high-quality data and analytics solutions.

Responsibilities:

• Requirements Analysis: Review user stories, data requirements, business rules, source-to-target mappings, and acceptance criteria to identify data and analytics test scenarios
• Test Development: Design, build, and maintain test scripts and test data for data pipelines, ETL/ELT processes, interfaces, dashboards, reports, KPIs, and analytical outputs
• Data and Analytics Testing: Execute source-to-target validation, data reconciliation, database testing, report and dashboard validation, and end-to-end data testing across JTMS within a SAFe Agile framework
• Defect Management: Document data and analytics defects with detailed reproduction steps and supporting evidence, track issues to resolution, and communicate findings effectively to development and data teams
• Stakeholder Collaboration: Work closely with developers, data engineers, business analysts, product owners, and business stakeholders to clarify data requirements and maximize test coverage
• Test Documentation: Create and maintain comprehensive test plans, test cases, SQL validation queries, test data sets, reconciliation results, and traceability matrices aligned with SAFe Agile practices
• Agile Participation: Actively engage in sprint planning, daily stand-ups, retrospectives, demonstrations, defect triage, and other Agile ceremonies
• Continuous Improvement: Identify opportunities to improve data validation, analytics testing, test automation, data-quality controls, and quality assurance practices

Qualifications:

• Security Clearance: Active Secret clearance (required)
• Education: Bachelor's degree in Computer Science, Information Technology, Data Analytics, Information Systems, or related field (or equivalent professional experience)
• Experience: Minimum 3 years in data analytics development and testing, data testing, or quality assurance for large-scale enterprise systems
• Data Analytics Expertise: Proven hands-on experience with SQL, Power-Bi, Tableau, data reconciliation, ETL/ELT testing, and validation of dashboards, reports, KPIs, and analytical calculations
• Agile Methodology: Strong working knowledge of SAFe Framework, SDLC, and Agile development practices
• Core Competencies: Excellent analytical and problem-solving abilities, strong attention to data accuracy and detail, strong written and verbal communication skills, and ability to work independently and collaboratively in team environments

Desired:

• Analytics Tools: Experience validating dashboards and reports using Power BI, Tableau, or similar business intelligence platforms
• Technical Skills: Strong SQL skills and experience with relational databases, data interfaces, ETL/ELT pipelines, and ServiceNow CWM for Agile test management and defect tracking
• DevSecOps Knowledge: Familiarity with CI/CD pipelines, automated data validation, Jenkins, Git, and DevSecOps best practices
• Government Experience: Previous experience supporting federal agencies or Department of Defense clients

What You Can Expect:

A culture of integrity.

At CACI, we place character and innovation at the center of everything we do. As a valued team member, you'll be part of a high-performing group dedicated to our customer's missions and driven by a higher purpose - to ensure the safety of our nation.

An environment of trust.

CACI values the unique contributions that every employee brings to our company and our customers - every day. You'll have the autonomy to take the time you need through a unique flexible time off benefit and have access to robust learning resources to make your ambitions a reality.

A focus on continuous growth.

Together, we will advance our nation's most critical missions, build on our lengthy track record of business success, and find opportunities to break new ground - in your career and in our legacy.

Pay Range:

There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits.

Since this position can be worked in more than one location, the range shown is the national average for the position.

The proposed salary range for this position is:

$75,200-$158,100

CACI is anEqualOpportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any otherprotectedcharacteristic.