Data Reporting & UAT Analyst

Ampcus Inc. • Richmond, VA

22h • Hybrid

About The Position

Ampcus Inc. is seeking an experienced Data Reporting & UAT Analyst to support Medicaid data testing, validation, reporting, and data warehouse operations. The role reviews design documents, identifies requirements gaps, maps data across interface systems, develops test scenarios, coordinates with stakeholders, and helps resolve project-related issues. The ideal candidate has strong SQL skills, hands-on Teradata experience, and knowledge of Medicaid or Medicare programs and regulatory requirements.

The role includes designing and executing data quality tests; querying a Teradata warehouse for scheduled and ad hoc reports; coordinating technical issues with a data warehouse vendor; developing dashboards and visualizations; and maintaining documentation. The analyst also contributes to test planning, stakeholder demonstrations, workflow development, and analysis and reporting related to Medicaid policies and regulatory requirements.

The position is hybrid in Richmond, Virginia. Initially, onsite work is expected one day per week, with the regular team schedule to be discussed later. The employee must pick up equipment in person. Parking is not provided for contractors.

Requirements

• At least 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.
• At least 3 years of experience as a Data Analyst, Data Quality Analyst, or in a similar role, focused on data testing and SQL development.
• Advanced SQL skills in Teradata environments, including performance tuning, BTEQ, and Teradata SQL Assistant.
• 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 and accuracy, and the ability to prioritize and manage multiple complex assignments within short time frames with minimal direction.
• Experience working with end users or customers to understand and develop requirements for technical solutions to meet business needs (5 years).
• Experience analyzing project requirements and developing detailed technical specifications (5 years).
• Experience working with technical developers to strategize solutions aligned with business requirements (5 years).
• Recent SQL-writing experience (5 years).
• Experience facilitating customer requirements-gathering meetings, sessions, or JAD sessions (5 years).
• Working knowledge of relational databases and database structures (5 years).
• Requirements traceability experience (5 years).
• BI reporting tools experience (5 years).
• Experience developing test data and test scenarios (5 years).
• Bachelor’s degree or equivalent work experience.

Nice To Haves

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

Responsibilities

• Design, execute, and document test cases and validation scripts to check accuracy, integrity, and consistency across data pipelines, ETL processes, and reports.
• Write, optimize, and execute complex SQL queries against a Teradata data warehouse for scheduled and ad hoc operational and analytical reports.
• Serve as the primary technical point of contact for the data warehouse vendor; escalate performance bottlenecks, troubleshoot data-loading issues, and track resolutions.
• Translate business requirements into data visualizations and dashboards using tools such as Tableau, Power BI, or Looker.
• Maintain documentation of data definitions, reporting logic, testing procedures, and data warehouse schemas.
• Review design documents, identify requirements gaps and issues, and map data between interface systems.
• Assist the lead analyst with project collaboration, documentation, and coordination.
• Review and contribute to test plans and collaborate with stakeholders to develop test scenarios.
• Demonstrate work to internal teams and project stakeholders, and collaborate with business, QA, and development teams on pre- and post-go-live issues.
• Develop workflows, recommend solutions, track issues through resolution, ensure timely resolution, and assign ownership accurately.
• Support data analysis and reporting related to state and federal Medicaid policies and regulatory requirements.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level