Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Reporting & UAT Analyst

Ampcus Incorporated

Job Description

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:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Skill Required / Desired Amount of Experience Expertise Rating Move 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.
Vacancy posted 23 days ago
Similar jobs that could be interesting for youBased on the Data Reporting & UAT Analyst in Richmond, VA vacancy
  •  ...Job Description Job Description Ideal Candidate Profile: Seeking a Data Reporting & UAT Analyst with Medicaid/Medicare experience and strong expertise in data testing, validation, and SQL development, particularly in Teradata environments. The ideal candidate will... 
    Data
    Work at office

    Accylerate, Inc

    Richmond, VA
    23 days ago
  • $55 - $59 per hour

     ...Job Description Job Description SR. Data Analyst (SQL/Teradata/Medicaid) Location: Richmond, VA Work Arrangement: Hybrid, initially...  ...or Medicare systems, requirements gathering, data testing, reporting, and system integrations , with the ability to collaborate... 
    Data
    Hourly pay
    Contract work
    For contractors
    1 day per week

    The Custom Group of Companies

    Richmond, VA
    23 days ago
  •  ...Job Description Job Description DMAS - Data Reporting & UAT Analyst (813718) Virginia Information Technology Agency Title/Role: DMAS - Data Reporting & UAT Analyst Region Description: Req. Status: Open No. of Openings: 1 Start Date: 11/02/2026 End... 
    Data
    For contractors
    Work experience placement
    Work at office
    Remote work
    1 day per week

    PeopleNTech LLC

    Richmond, VA
    23 days ago
  •  ...EPM Reporting Analyst Stress Testing & GL Modernization Location: Richmond, VA Contract (1 year) Hybrid 3 days onsite a week Our client...  ...of our general ledger which will result in changes to data dimension and will have downstream impacts to how data is organized... 
    Data
    Contract work
    For contractors
    3 days per week
    1 day per week

    Ace Stack

    Richmond, VA
    1 day ago
  •  ...Oracle ERP / Fusion Data Intelligence Reporting Analyst Harris Williams is seeking an Oracle ERP / Fusion Data Intelligence Reporting Analyst to support financial, operational, and management reporting across Oracle ERP Cloud, Oracle Fusion Data Intelligence (FDI),... 
    Data
    Work at office
    Remote work
    Flexible hours

    Harris Williams

    Richmond, VA
    1 day ago
  • $20.91 - $45.04 per hour

     ...enable the distribution of power, signal and data to advance next-generation transportation...  ...partnering closely with the Senior Analyst and cross-functional business stakeholders...  ...provide any personal information, and to report the incident to your local authorities... 
    Data
    Remote job
    Work experience placement
    Summer work
    Internship
    Local area

    TE Connectivity

    Richmond, VA
    23 hours ago
  • $90k

    Start Your Adventure at Via Logic Role: Business and Data Analyst Location: Remote; work must be performed within the United States....  ...ensure solutions meet stakeholder expectations. Data Analysis & Reporting: Analyze application and program data, clarify reporting... 
    Data
    Full time
    Local area
    Remote work

    Via Logic LLC

    Richmond, VA
    3 days ago
  •  ...full lifecycle of analytics automation and data integration solutions, including...  ...applications, and integrations that power reporting, budgeting, forecasting, cost modeling, and...  ...environment Alteryx Server instances (DEV, UAT, PROD) Work with cloud services (AWS... 
    Data
    Remote work

    Varite, Inc

    Richmond, VA
    2 days ago
  •  ...Business Analyst/ Product Manager We are seeking an experienced...  ...Product Owner / Scrum Master for a Data track to drive end to end...  ...data platforms, analytics, and reporting initiatives. This hybrid role...  ...walkthroughs, story validation, and UAT planning. Ensure clarity on... 
    Data

    Jconnect Infotech Inc

    Richmond, VA
    1 day ago
  • $84.4k - $127k

     ...targeting our core business hours of 9am-5pm EST.YOUR ROLEThe Data Product & Integration Analyst serves as a key connector between business stakeholders,...  ...assets that support customer segmentation, business reporting, analytics, and informed decision-making across critical... 
    Data
    Full time
    Work experience placement
    Work at office
    Local area
    Remote work

    Genworth Financial

    Richmond, VA
    3 days ago
  • $40 - $50 per hour

     ...This Data Analyst role is a 12 - Month Contract with a client located in Richmond, VA . Pay Range: $40/hr. - $50/hr. The rate may be negotiable based on experience, education, geographic location, and other factors. Key Responsibilities: Backbook Data... 
    Data
    Contract work
    Temporary work
    Local area

    Akkodis

    Richmond, VA
    29 days ago
  •  ...Sr Technical Recruiter @ Decca Recruiting | MBA in Human Resources The ideal candidate will use their passion for big data and analytics to provide insights to the business covering a range of topics. They will be responsible for conducting both recurring and ad hoc analysis... 
    Data
    Contract work
    Local area

    Decca Recruiting

    Richmond, VA
    2 days ago
  •  ...Robotics Technologies is hiring a Data Analyst for a contract role based in Richmond, VA on site. This position focuses on collecting,...  ...engineering and business intelligence teams to deliver reliable reporting, insights, and automated analytics processes. Key... 
    Data
    Contract work
    H1b

    Robotics Technologies LLC

    Richmond, VA
    4 days ago
  • The Virginia Department of Health seeks an HR Analyst I to independently perform a broad range of human resources functions in support of...  ..., procedures, and regulations while conducting analyses of data, trends, and job information to inform decisions and recommendations... 
    Data

    Go VCE

    Richmond, VA
    3 days ago
  •  ...Role: Data AnalystLocation: Richmond, VA or Meclan, VA (Hybrid)Employment: W2Exp: 7+NotesData engineer or Analyst – a mix of both is goodIn general, he wants a combination of both skill setsMainly looking for technical skills- Python, scripting, databricksAI toolsPythonAWSCloud... 
    Data

    Lorvenk Technologies

    Richmond, VA
    3 days ago
  • $96.7k - $145k

     ...it better. We create fulfilling purpose-driven careers by learning from the world and each other. POSITION TITLE Data Governance Analyst At this time, Genworth will not sponsor a new applicant for employment authorization for this position. POSITION LOCATION... 
    Data
    Work at office
    Local area
    Remote work

    Genworth

    Richmond, VA
    3 days ago
  •  ...We are seeking an experienced Data Analyst to collect, analyze, interpret, and visualize business data to support data-driven decision...  ...expertise in SQL, Excel, Python, data visualization tools, and reporting. Key Responsibilities Collect, clean, validate, and analyze... 
    Data
    Local area

    Valiant Technologies LLC

    Richmond, VA
    2 days ago
  • The Senior Clinical Data Manager is responsible for leading all data management activities...  .... Oversee User Acceptance Testing (UAT) and ensure all study requirements are met...  ...quality metrics and provide regular status reporting. Oversee integration and reconciliation... 
    Data
    Contract work
    Remote work

    Lightship

    Richmond, VA
    4 days ago
  •  ...MARKETview Education Partners is seeking bright, talented and motivated individuals to join our data and analytics team. These individuals will be critical contributors to a fast-growing, early-stage education technology business and will have the unique benefit of joining... 
    Data
    Full time
    Local area
    Work visa

    MARKETview Education Partners, LLC

    Richmond, VA
    12 hours ago
  •  ...seeking a Director, HR Technology & Data to work closely with the VP,...  .... Manages a global team of analysts and specialists to ensure...  ...onsite Tuesdays & Thursdays). It reports to the Vice President, HR Operations...  ...projects; Experience writing UAT criteria or scripts for... 
    Data
    Contract work
    Worldwide

    International Justice Mission

    Richmond, VA
    2 days ago
  •  ...Job Description Job Description Requirements Minimum Qualifications: Minimum 10 years of experience in data analysis, data governance, data management, data quality, business analysis, metadata management, or related disciplines. Minimum 10 years of experience... 
    Data
    For contractors

    HCL Global Systems Inc.

    Richmond, VA
    23 days ago
  •  ...Virginia Department of Health seeks an experienced Human Resource Analyst in Richmond to perform a broad set of HR functions including...  ...benefits administration. The role interprets HR policies and conducts data analysis to support personnel decisions, with potential... 
    Data
    Work at office

    Virginia Department of Health

    Richmond, VA
    2 days ago
  • TECHEAD is seeking a Benefits Analyst to manage day-to-day operations for domestic employee reward and coverage programs. You will oversee...  ...alignment with the compensation strategy. The role emphasizes data integrity, vendor oversight, and responsive employee support across... 
    Data

    Techead

    Richmond, VA
    4 days ago
  •  ...Overview The Senior GIS Development & Data Analyst is responsible for developing GIS-related software applications and performing advanced...  ...complex geospatial datasets to produce maps, dashboards, and reports. Source, compile, and validate data from multiple inputs... 
    Data
    Work at office

    Brooksource

    Richmond, VA
    24 days ago
  • $84.4k - $140.6k

     ...growth through innovation.Work you'll doAs a Data Engineer II on the AI & Data team, you...  ...visualizations, Power BI dashboards, and reports using DAXSupporting the development and...  ...Engineer Professional, or Databricks Data Analyst Associate certificationFamiliarity with international... 
    Data
    Local area

    Deloitte

    Richmond, VA
    4 days ago
  • Position: Data Science Analyst/ Data Engineer Location: Richmond Virginia 23219 (Hybrid)  Duration: 12 months  Job ID: 180986 High...  ...data pipelines and ETL/ELT solutions to support analytics, reporting, and AI/ML use cases, ensuring solutions are robust and production... 
    Data
    Full time

    PTR Global

    Richmond, VA
    7 days ago
  •  ...Senior Data Analyst The organization is seeking a Senior Data Analyst to lead critical initiatives within data management and analytics...  ...maintain, and optimize interactive dashboards and analytical reporting tools. Translate complex data structures into actionable... 
    Data

    Apex Systems

    Richmond, VA
    1 day ago
  •  ...Job Description Job Description Title: Data Governance Analyst Location: Richmond, Virginia (Hybrid) Duration: 12 Months Interview...  ...classification, retention, and internal data sharing processes. Reporting & Communication Produce governance dashboards and... 
    Data
    For contractors
    2 days per week

    Apollo Technology Solutions LLC

    Richmond, VA
    23 days ago
  • $81.7 per hour

     ...Job Description Job Description DBHDS - Data Governance Analyst (CDC Funded) (807900) Virginia Information Technology Agency Title/...  ...classification, retention, and internal data sharing processes. Reporting & Communication Produce governance dashboards and... 
    Data
    For contractors
    Work at office
    2 days per week

    PeopleNTech LLC

    Richmond, VA
    23 days ago
  • $79.92k - $88.8k

     ...Data Analyst II, Medicaid Fraud Control Unit Title: Data Analyst II, Medicaid Fraud Control Unit State Role Title: Data Analyst Hiring Range: $79,920 - $88,800 Pay Band: UG Agency: Attorney General & Dept of Law Location: Office of the Attorney General... 
    Data
    Work at office
    Night shift

    Virginia Department of Human Resource Management

    Richmond, VA
    2 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Reporting & UAT Analyst. Be the first to apply!