Loading, Please wait..!!
Data Reporting & UAT Analyst
-
Posted on: Oct 28, 2026
-
Richmond, Virginia
-
Onsite
-
Full-time
Curious about compensation?
Explore the historical salary trends, average pay, and estimated compensation for Data Reporting & UAT Analyst roles in Virginia.
View Salary Guide →Find your match !
Job Title :
Data Reporting & UAT Analyst
Job Type :
Full-Time
Job Location :
Richmond Virginia United States
Remote :
No
Job Description :
Job Description
Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.
Job Title: Data Reporting & UAT Analyst
Location(s): Richmond, VA
(Hybrid)
Job Summary
We are seeking an experienced Medicaid Data Quality Analyst to support data testing, validation, reporting, and data warehouse operations. The role involves reviewing design documents, identifying requirements gaps, mapping data across interface systems, developing test scenarios, coordinating with stakeholders, and resolving project-related issues. The ideal candidate will have strong SQL skills, hands-on Teradata experience, and a solid understanding of Medicaid or Medicare programs and regulatory requirements.
Work Arrangement
- Initially, onsite work is expected one day per week, with the regular team schedule to be discussed later.
- Must be able to pick up equipment in person.
- Parking is not provided for contractors.
Key Responsibilities
- Data Testing and Validation: Design, execute, and document comprehensive test cases and validation scripts to ensure data accuracy, integrity, and consistency across data pipelines, ETL processes, and reports.
- Data Extraction and Reporting: Write, optimize, and execute complex SQL queries against a Teradata data warehouse to generate scheduled and ad hoc operational and analytical reports.
- Vendor Collaboration: Serve as the primary technical point of contact for the data warehouse vendor, escalate performance bottlenecks, troubleshoot data-loading issues, and track resolutions.
- Reporting and Visualization: Translate business requirements into actionable data visualizations and dashboards using tools such as Tableau, Power BI, or Looker.
- Data Governance and Documentation: Maintain documentation of data definitions, reporting logic, testing procedures, and data warehouse schemas.
- Requirements and Design Review: Review design documents, proactively identify requirements gaps and issues, and map data between interface systems.
- Test Planning and Execution: Assist the lead analyst with project collaboration, documentation, and coordination. Review and contribute to test plans and work with stakeholders to develop test scenarios.
- Stakeholder Collaboration: Provide demonstrations to internal teams and project stakeholders and collaborate with business teams, QA, and development teams on pre- and post-go-live issues.
- Workflow and Issue Management: Develop workflows, recommend solutions, track issues through resolution, ensure timely resolution, and assign ownership accurately.
- Regulatory Reporting: Support data analysis and reporting activities related to state and federal Medicaid policies and regulatory requirements.
Required Qualifications
- 5+ years of experience with Medicaid or Medicare.
- Experience implementing federal or state legislative policies, such as CMS rules, HR1 provisions, Medicaid expansion, or Medicaid unwinding initiatives.
- 3+ years of experience as a Data Analyst, Data Quality Analyst, or in a similar role, with a strong focus on data testing and SQL development.
- Advanced SQL skills in Teradata environments, including performance tuning, BTEQ, and Teradata SQL Assistant.
- Demonstrated experience developing test plans, performing data validation, and identifying data anomalies and discrepancies.
- Experience collaborating with third-party vendors, IT infrastructure teams, or database administrators to manage system updates and resolve technical issues.
- Bachelor's degree in Computer Science, Statistics, Data Analytics, Mathematics, or a related field.
- Excellent interpersonal, verbal, and written communication skills, including the ability to prepare and present complex concepts and findings to all organizational levels.
- Strong quantitative and analytical skills, including working knowledge of SAS, SQL, data mining software, statistical validation techniques, predictive modeling, and data visualization.
- Proficiency in Microsoft Office applications, including Access, Excel, PowerPoint, and Word.
- Ability to plan, organize, implement, and monitor large-scale, time-sensitive projects while collaborating across teams.
- Strong organizational skills, attention to detail, accuracy, and the ability to prioritize and manage multiple complex assignments within short time frames with minimal direction.
Preferred Qualifications
- Experience working with Medicaid eligibility and enrollment data.
- Experience with health plan operations and data, including encounters, claims, and clinical quality.
- Working knowledge of state and federal Medicaid policies and regulatory reporting requirements.
Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.
Similar Jobs You May Be Interested In
Data Reporting & UAT Analyst
Data Reporting & UAT Analyst
Data Reporting & UAT Analyst
DMAS - Data Reporting & UAT Analyst
DMAS - Data Reporting & UAT Analyst
Data Reporting Uat Analyst
Data Reporting & UAT Analyst
Position Details
Posted:
Oct 28, 2026
Reference Number:
421b2c6c
Employment:
Full-time
City:
Richmond
Job Origin:
ziprecruiter
Share this job:
Please wait..!!

