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)
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...DataWork at office
$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...DataHourly payContract workFor contractors1 day per week- ...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...DataFor contractorsWork experience placementWork at officeRemote work1 day per week
- ...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...DataContract workFor contractors3 days per week1 day per week
- ...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),...DataWork at officeRemote workFlexible hours
$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...DataRemote jobWork experience placementSummer workInternshipLocal area$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...DataFull timeLocal areaRemote work- ...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...DataRemote work
- ...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
$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...DataFull timeWork experience placementWork at officeLocal areaRemote work$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...DataContract workTemporary workLocal area- ...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...DataContract workLocal area
- ...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...DataContract workH1b
- 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
- ...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
$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...DataWork at officeLocal areaRemote work- ...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...DataLocal area
- 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...DataContract workRemote work
- ...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...DataFull timeLocal areaWork visa
- ...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...DataContract workWorldwide
- ...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...DataFor contractors
- ...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...DataWork at office
- 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
- ...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...DataWork at office
$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...DataLocal area- 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...DataFull time
- ...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
- ...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...DataFor contractors2 days per week
$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...DataFor contractorsWork at office2 days per week$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...DataWork at officeNight shift
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Reporting & UAT Analyst. Be the first to apply!
Related searches
- neuroscience data analyst Richmond, VA
- data center analyst Richmond, VA
- talent data analyst Richmond, VA
- remote data analyst Richmond, VA
- data protection analyst Richmond, VA
- data analyst supply chain analytics Richmond, VA
- data warehouse analyst Richmond, VA
- data integrity analyst Richmond, VA
- senior healthcare data analyst Richmond, VA
- senior information security analyst Richmond, VA






