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.
• Bachelors 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.