UAT Test Analyst – Data Warehouse, Analytics, and Federal Reporting (Remote)

UAT Test Analyst – Data Warehouse, Analytics, and Federal Reporting 

Location: Remote

About Us:

Known for “Delighting the Client” through performance, innovation, and an employee-centric culture, S2Tech is a fast-growing IT consulting company serving clients in over a quarter of the United States. We are widely recognized as a leading provider of both technical and business services in support of Health and Human Services-related projects. Feel free to learn more at www.s2tech.com.

Why S2Tech?:

• Stable privately-owned company with a strong reputation for building long-term client relationships through the delivery of consistent value-based service
• 25+ years providing IT and Business services to private customers and government programs throughout the United States
• Expansive client portfolio and active projects – employees benefit from innovative project exposure and in-house skill development training/courses  
• Corporate culture that emphasizes the importance of family and promotes a healthy work-life balance
• Offer competitive pay and a range of benefits, including:
• Medical / Dental / Vision Insurance – insurance premium assistance provided
• Additional Insurance (Life, Disability, etc.)
• Paid Time Off
• 401(k) Retirement Savings Plan & Health Savings Account
• Various training courses to promote continuous learning
• Corporate Wellness Program
• Be part of a company that gives back through its non-profit organization, Fortune Fund, which was launched in 2001. The goal of the Fortune Fund is to close the rural/urban divide by ensuring children in rural communities in India and the United States understand the importance of education & are aware of professional career opportunities, allowing them to link their professional & educational goals

Job Overview:

We are seeking an experienced UAT Tester with strong expertise in data warehouse testing, test scenario identification, and UAT use case development to support a state Medicaid agency as part of an MES Modernization Program. This role will focus on defining UAT test coverage for the Data Warehouse and Reporting modules, ensuring accuracy, compliance, and traceability in alignment with CMS and federal reporting requirements.

The primary responsibility of this position is to work closely with business stakeholders to identify UAT test scenarios and create comprehensive use cases. While the State client will conduct UAT execution, this role will provide guidance, preparation, and support throughout the process, including assisting with issue triage and test coverage validation. The individual will collaborate with business and technical teams to ensure UAT efforts are well-defined, efficient, and aligned with project goals under the Testing Center of Excellence (TCOE) framework.

Responsibilities:

• Partner with business users and stakeholders to identify UAT test scenarios based on business processes, reporting needs, and data requirements
• Develop detailed UAT use cases and supporting documentation that clearly define expected outcomes
• Ensure UAT test coverage across data warehouse ETL pipelines, staging areas, and reporting outputs
• Support data mapping and traceability between source systems, transformations, and reporting requirements
• Validate test scenarios against business and reporting requirements to ensure accuracy and completeness
• Provide guidance and assistance to the State client during UAT execution, including defect documentation and triage support
• Collaborate with the Optum data warehouse team, state stakeholders, and modular vendors to align UAT priorities and address gaps
• Track progress and provide input on UAT readiness, risks, and issues to project leadership

Qualifications:

• 3–5 years of experience in software testing, UAT preparation, or quality assurance, with a strong focus on data warehouse and reporting validation
• Demonstrated experience in test scenario identification and use case development for business-driven testing
• Proficiency in writing SQL queries to support data analysis and validation during UAT preparation
• Experience validating reports and dashboards in Power BI (data accuracy, calculations, and visualizations)
• Familiarity with schema testing, metadata validation, and data lineage concepts
• Strong documentation skills and ability to communicate effectively with both technical and non-technical stakeholders
• Experience working in multi-vendor, modular IT environments

Preferred:

• Experience with Medicaid data and federal reporting requirements (e.g., T-MSIS, CMS dashboards)
• Familiarity with the Optum Medicaid Data Warehouse or similar large-scale Medicaid DW systems
• Knowledge of CMS reporting guidelines and data quality standards
• Exposure to data governance, MDM, or data management practices

S2Tech is committed to hiring and retaining a diverse workforce. We are an equal opportunity employer making decisions without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected class.