Data Reporting & UAT Analyst

Data Reporting & UAT Analyst
Richmond, VA
Hybrid

Key Responsibilities

• Data Testing & Validation: Design, execute, and document comprehensive test plans, validation scripts, and data QA processes to ensure accuracy and consistency across pipelines, ETL processes, and reports.

• Data Extraction & Reporting: Write, optimize, and execute advanced SQL queries within a Teradata data warehouse to generate scheduled and ad-hoc operational and analytical reports.

• Reporting & Visualization: Translate complex business requirements into intuitive dashboards and actionable visual reports utilizing Tableau, Power BI, or Looker.

• Vendor & Stakeholder Collaboration: Serve as the primary technical point of contact for the data warehouse vendor, troubleshooting data loading issues, escalating bottlenecks, and coordinating system updates with IT infrastructure teams and DBAs.

• Governance & Documentation: Maintain transparent organization-wide documentation encompassing data definitions, reporting logic, UAT procedures, and warehouse schemas.

• Project Execution: Plan, organize, and monitor large-scale, time-sensitive data initiatives while prioritizing workflows and maintaining a high standard of accuracy with minimal direction.

Required Qualifications

• Education: Bachelor’s degree in Computer Science, Statistics, Data Analytics, Mathematics, or a related discipline.

• Experience: 3+ years in a Data Analyst, Data Quality Analyst, or similar role with a heavy emphasis on identifying data anomalies, performing validation, and executing SQL development.

• Communication: Exceptional interpersonal and presentation skills, with a proven ability to distill complex analytical concepts and present clear reports to audiences at all levels of the organization.

• Work Style: Highly organized and detail-oriented, capable of managing multiple complex assignments seamlessly within short timeframes.

Technical & Analytical Expertise

• Advanced SQL & Teradata: Deep proficiency in Teradata environments, including performance tuning, BTEQ, and Teradata SQL Assistant.

• Quantitative Analysis: Strong background in statistical validation techniques, data mining, predictive modeling construction, and utilizing SAS and SQL.

• Visualization Tools: Hands-on experience developing insights with industry-standard platforms (Tableau, Power BI, Looker).

• Software Proficiency: Advanced working knowledge of the Microsoft Office Suite (Access, Excel, PowerPoint, Word).

Healthcare Domain Experience

• Medicaid/Medicare Expertise: 5+ years of domain experience, with a strong preference for candidates deeply familiar with Medicaid eligibility, enrollment data, and health plan operations (encounters, claims, clinical quality).

• Policy Implementation: Prior experience supporting federal or state legislative policy implementations, such as CMS rules, HR1 provisions, or Medicaid expansion/unwinding efforts.

• Regulatory Reporting: Comprehensive working knowledge of state and federal Medicaid policies and regulatory reporting requirements.