Data Analyst

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

📋 Description

• Review user stories, data requirements, business rules, source-to-target mappings, and acceptance criteria to pinpoint data and analytics test scenarios.

• Design, develop, and sustain test scripts and test data for data pipelines, ETL/ELT processes, interfaces, dashboards, reports, KPIs, and analytical outputs.

• Conduct source-to-target validation, data reconciliation, database testing, report and dashboard validation, and comprehensive data testing across JTMS within a SAFe Agile framework.

• Document data and analytics defects with comprehensive reproduction steps and supporting evidence.

• Track issues to resolution and communicate findings to development and data teams effectively.

• Collaborate with developers, data engineers, business analysts, product owners, and business stakeholders.

• Create and maintain test plans, test cases, SQL validation queries, test data sets, reconciliation results, and traceability matrices.

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

• Identify opportunities to enhance data validation, analytics testing, test automation, data-quality controls, and quality assurance practices.

• Support USTRANSCOM's Joint Transportation Management System, a mission-critical platform modernizing transportation, logistics, and financial operations through SAP S/4HANA integration.

⛳️ Requirements

• Active Secret clearance (mandatory).

• Bachelor’s degree in Computer Science, Information Technology, Data Analytics, Information Systems, or a related field, or equivalent professional experience.

• At least 3 years of experience in data analytics development and testing, data testing, or quality assurance for large-scale enterprise systems.

• Hands-on experience with SQL, Power BI, Tableau, data reconciliation, ETL/ELT testing, and validation of dashboards, reports, KPIs, and analytical calculations.

• Strong understanding of the SAFe Framework, SDLC, and Agile development practices.

• Excellent analytical and problem-solving skills.

• Meticulous attention to data accuracy and detail.

• Strong written and verbal communication abilities.

• Capacity to work independently and collaboratively within team environments.

• Experience in validating dashboards and reports using Power BI, Tableau, or similar business intelligence platforms.

• Proficient SQL skills and experience with relational databases, data interfaces, ETL/ELT pipelines, and ServiceNow CWM for Agile test management and defect tracking.

• Familiarity with CI/CD pipelines, automated data validation, Jenkins, Git, and DevSecOps best practices.

• Previous experience supporting federal agencies or Department of Defense clients is preferred.

• Up to 10% travel may be required.

• Active Secret security clearance is mandatory.

🏝️ Benefits

• Flexible time off benefit.

• Extensive learning resources.

• Healthcare benefits.

• Wellness benefits.

• Financial benefits.

• Retirement benefits.

• Family support benefits.

• Continuing education benefits.

• Time off benefits.

• Competitive compensation.

• Opportunities for learning and development.