Data REporting & UAT Analyst

Data Reporting & UAT Analyst

Richmond, VA

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 against 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.