Data Reporting & UAT Analyst

Richmond, VA

Instant Apply

5 days ago

Job Description

Job Title: Data Reporting & UAT Analyst
Location: Richmond, VA 23219 (Hybrid)
Duration: 8 Months (Extension Possible)
Interview Mode:Either Phone or In Person

About the role:
This role will review the Design documents, proactively identify requirement gaps and issues, map data between interface systems, assist lead analyst in project collaboration, documentation and coordination, review and contribute to the test plans, work with stakeholders to Build Test Scenarios, provide demonstrations to Internal teams and Project Stakeholders, work closely with Business, QAs, Dev team on project related pre and post go live issues, develop workflows, provide solutions, track issues end to end, ensure timely resolutions and accurate delegation of ownership.

Key Responsibilities:

Data Testing & 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 & Reporting: Write, optimize, and execute complex SQL queries aProductst our data warehouse (in Teradata) to pull scheduled and ad-hoc operational and analytical reports.
Vendor Collaboration: Act as the primary technical point of contact for our data warehouse vendor, escalating performance bottlenecks, troubleshooting data loading issues, and tracking resolutions.
Reporting & Visualization: Translate business requirements into intuitive, actionable data visualizations and dashboards using tools such as Tableau, Power BI, or Looker
Data Governance & Documentation: Maintain documentation of data definitions, reporting logic, testing procedures, and data warehouse schemas to ensure organization-wide transparency.
Preferred Experience: Working knowledge of state and federal Medicaid policy and regulatory reporting requirements preferred.

Qualifications & Requirements:

Domain Knowledge: 5+ years of experience with Medicaid or Medicare. Prior experience working on federal or state legislative policy implementations (e.g., CMS rules, HR1 provisions, Medicaid expansion/unwinding efforts).
Technical Experience: 3+ years of experience as a Data Analyst, Data Quality Analyst, or similar role with a heavy focus on data testing and SQL development.
Technical Expertise: Advanced SQL skills specifically within Teradata environments (including performance tuning, BTEQ, and Teradata SQL Assistant).
Testing & QA: Demonstrated experience writing test plans, performing data validation, and identifying data anomalies or discrepancies.
Collaboration: Experience working closely with third-party vendors, IT infrastructure teams, or database administrators to manage system updates and resolve issues.
Education: Bachelor s degree in computer science, Statistics, Data Analytics, Mathematics, or a related field.

Additional skills/experience should include:

Excellent interpersonal, verbal, and written communications skills, with a demonstrated ability to prepare and present reports on complex concepts and findings to all levels of the organization.
Strong quantitative analysis skills, including working knowledge of SAS, SQL, data mining software, statistical validation techniques, predictive modeling construction and data visualization.
Proficiency in Microsoft Office Suite, including Access, Excel, Power Point and Word.
Demonstrated ability to plan, organize, implement, and monitor large scale/time sensitive projects; and to work collaboratively across teams.
Must be well organized, with the ability to prioritize work and possess a great attention to detail and accuracy and an ability to complete multiple complex assignments within short time frames and with minimal direction.
Experience working with Medicaid eligibility and enrollment data, health plans operations, and data (encounters, claims, clinical quality, etc.) strongly preferred.
Working knowledge of state and federal Medicaid policy and regulatory reporting requirements preferred.

Skill Matrix:

Skill	Required	Amount of Experience	Experience
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
Bachelor s degree or equivalent work experience,	Required

Feel free to forward my email to your friends/colleagues who might be available. We do offer a referral bonus! Thank you for your time and consideration.
I am looking forward to hearing from you.

Numbers & Facts

Location

Richmond, VA

Skills

Acceptance Testingunmatched
Advertising Operationsunmatched
Advertising Schedulingunmatched
Analysis Skillsunmatched
BTEQunmatched
Business Intelligenceunmatched
Centers for Medicare and Medicaid Services (CMS)unmatched
Computer Scienceunmatched
Constructionunmatched
Customer/Client Researchunmatched
Data Analysisunmatched
Data Managementunmatched
Data Mining Softwareunmatched
Data Qualityunmatched
Data Visualizationunmatched
Data Warehousingunmatched
Database Administrationunmatched
Database Extract Transform and Load (ETL)unmatched
Design Documentunmatched
Detail Orientedunmatched
Documentationunmatched
Establish Prioritiesunmatched
Health Plan Membershipunmatched
Healthcare Qualityunmatched
Identify Issuesunmatched
Information Technology & Information Systemsunmatched
Interpersonal Skillsunmatched
Java Decompiler (JAD)unmatched
Logic Testingunmatched
Lookerunmatched
Mathematicsunmatched
Medicaidunmatched
Medicareunmatched
Microsoft Access Databaseunmatched
Microsoft Excelunmatched
Microsoft Officeunmatched
Microsoft PowerPointunmatched
Microsoft Wordunmatched
NCR Teradataunmatched
Operations Planningunmatched
Organizational Skillsunmatched
Performance Tuning/Optimizationunmatched
Policy Implementationunmatched
Power BIunmatched
Predictive Modelingunmatched
Presentation/Verbal Skillsunmatched
Problem Solving Skillsunmatched
Product Demonstrationunmatched
Project Evaluationunmatched
Quality Assuranceunmatched
Quantitative Analysisunmatched
Regulatory Reportsunmatched
Regulatory Requirementsunmatched
Relational Databases (RDBMS)unmatched
Reporting Dashboardsunmatched
Requirements Managementunmatched
SQL (Structured Query Language)unmatched
Scripting (Scripting Languages)unmatched
Software Validationunmatched
Statistical Analysis System (SAS)unmatched
Statisticsunmatched
Systems Administration/Managementunmatched
Systems Maintenanceunmatched
Tableauunmatched
Technical Strategyunmatched
Test Caseunmatched
Test Plan/Scheduleunmatched
Test Scenariounmatched
Testingunmatched
Time Managementunmatched
Validation Testingunmatched
Vendor/Supplier Evaluationunmatched
Writing Skillsunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder

Data Reporting & UAT Analyst

Job Description

Numbers & Facts

Skills

Level up your application

Professional resume templates

Free resume builder

Senior Financial Analyst

Vulnerability Management Analyst

Senior GIS Analyst

IT Hardware Asset Management Analyst

Senior Programmer Analyst (AI/ML, GenAI)

Senior Data Science Analyst

Data Reporting & UAT Analyst

Job Description

Numbers & Facts

Skills

Be found by employers

Level up your application

Professional resume templates

Free resume builder