Medicaid Data Quality & Reporting Analyst (Hybrid)

Ampcus, Inc; Richmond (VA); Hybride; USD 70 000 - 100 000; Plein temps

Résumé du poste

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.

Responsabilités

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

Connaissances

Medicaid/Medicare experience

SQL development

Data testing & validation

Data governance

Communication skills

Analytical skills

Formation

Bachelor's degree in Computer Science or related field

Outils

Teradata

Tableau

Power BI

Looker

SAS

Description du poste

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