Data Reporting & UAT Analyst

Ampcus, Inc; Richmond (VA); Hybrid; USD 70,000 - 100,000; Full time

Job summary

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are seeking an experienced Medicaid Data Quality Analyst to support data testing, validation, reporting, and data warehouse operations in Richmond, VA.

The role emphasizes strong SQL skills and Teradata experience within Medicaid programs. The position involves reviewing design documents, mapping data across interfaces, developing test scenarios, coordinating with stakeholders, and

Qualifications

• 5+ years of experience with Medicaid or Medicare.
• 3+ years as Data Analyst/Data Quality Analyst or similar with data testing focus.
• Advanced SQL skills in Teradata environments, including performance tuning, BTEQ, and Teradata SQL Assistant.
• Experience developing test plans, data validation, and identifying data anomalies.
• Experience collaborating with third-party vendors, IT infrastructure teams, or DBAs.
• Bachelor's degree in Computer Science, Statistics, Data Analytics, Mathematics, or related field.

Responsibilities

• Design, execute, and document test cases to ensure data accuracy and integrity across ETL pipelines and reports.
• Write, optimize, and run complex SQL queries against a Teradata data warehouse for reports.
• Serve as primary technical contact for data warehouse vendor; escalate and track resolutions.
• Translate business requirements into data visualizations and dashboards using Tableau, Power BI, or Looker.
• Maintain documentation of data definitions, reporting logic, testing procedures, and warehouse schemas.
• Review design documents, identify requirements gaps, map data between interfaces, and contribute to test plans.
• Assist lead analyst with project coordination; develop test scenarios and execute validation.
• Collaborate with business teams, QA, and development teams on pre- and post-go-live issues.
• Develop workflows, drive issue resolution, and ensure timely ownership assignment.
• Support regulatory reporting related to Medicaid/state policies.

Skills

Medicaid/Medicare experience

SQL development

Data testing & validation

Data governance

Communication skills

Analytical skills

Education

Bachelor's degree in Computer Science or related field

Tools

Teradata

Tableau

Power BI

Looker

SAS

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.

Skills:

• Experience with Medicaid or Medicare or other health systems Required 5 Years
• Exp working with end users/customers to understand and develop requirements for technical solutions to meet business needs Required 5 Years
• Exp w/analyzing project requirements and developing detailed technical specifications Required 5 Years
• Exp with technical developers to strategize solutions to align with business requirements Required 5 Years
• Recent SQL writing experience Required 5 Years
• Exp w/facilitating customer requirements gathering meetings/sessions/JAD Sessions Required 5 Years
• working knowledge of relational databases/database structures Required 5 Years
• Requirements Traceability Required 5 Years
• BI reporting tools Required 5 Years
• developing test data and test scenarios Required 5 Years
• Bachelors degree or equivalent work experience Required

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.