Data Reporting & UAT Analyst

Smart IMS•Richmond, VA

2d•Hybrid

About The Position

As a Data Reporting & UAT Analyst, you will support data validation, user acceptance testing, reporting, and business analysis activities for enterprise data initiatives. This role involves reviewing requirements and design documentation, identifying gaps, coordinating with stakeholders, validating data quality, developing reports and dashboards, and ensuring successful project delivery through effective testing and issue resolution.

Requirements

5+ years of experience working with Medicaid, Medicare, healthcare programs, or regulated healthcare environments.
3+ years of experience as a Data Analyst, Data Quality Analyst, UAT Analyst, or similar role focused on data testing and SQL development.
Advanced SQL expertise, including Teradata, query optimization, performance tuning, BTEQ, and Teradata SQL Assistant.
Strong experience developing test plans, executing UAT, performing data validation, and identifying data anomalies.
Experience creating dashboards and reports using tools such as Tableau, Power BI, Looker, or similar BI platforms.
Experience collaborating with third-party vendors, database administrators, infrastructure teams, and technical stakeholders.
Strong analytical skills with experience using SQL, SAS, data mining, statistical validation, and reporting techniques.
Proficiency with Microsoft Office Suite including Excel, Access, PowerPoint, and Word.
Bachelor's degree in Computer Science, Data Analytics, Statistics, Mathematics, or a related field.
Excellent communication, documentation, organization, and stakeholder management skills with the ability to manage multiple priorities in fast-paced environments.

Responsibilities

Review requirements and design documents to identify gaps, risks, and improvement opportunities.
Design, execute, and document UAT test cases, test scenarios, and data validation activities.
Write and optimize SQL queries to support reporting, data analysis, and validation efforts.
Develop operational and analytical reports, dashboards, and visualizations.
Collaborate with business users, QA teams, developers, and stakeholders throughout the project lifecycle.
Act as the primary liaison for data-related issues, vendor coordination, and issue resolution.
Map and validate data across multiple systems, interfaces, and data pipelines.
Develop workflows, document business processes, and recommend solution improvements.
Track issues from identification through resolution and ensure timely ownership and closure.
Support pre-implementation, go-live, and post-production activities through testing, demonstrations, and stakeholder communication.