Data Reporting & UAT Analyst

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.