Medicaid Data Reporting & UAT Analyst

Novalink Solutions LLC; Richmond (VA); On-site; USD 90,000 - 115,000; Full time

Job summary

Novalink Solutions LLC in Richmond, VA is seeking a DMAS Data Reporting & UAT Analyst. The role focuses on reviewing design documents, mapping data between interfaces, and supporting testing and validation across ETL pipelines and reports.

The ideal candidate brings 5+ years of Medicaid/Medicare experience, advanced SQL in Teradata, and proven skills in data extraction, reporting, and visualization with tools like Tableau or Power BI. Collaboration with vendors and stakeholders is essential.

Qualifications

• 5+ years of experience with Medicaid or Medicare.
• 3+ years as a Data Analyst, Data Quality Analyst, or similar role with a heavy focus on data testing and SQL development.
• Advanced SQL skills specifically within Teradata environments (including performance tuning, BTEQ, and Teradata SQL Assistant).
• Experience writing test plans, performing data validation, and identifying data anomalies or discrepancies.

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.

Skills

SQL

Teradata

Data analysis

Data visualization

Tableau

Power BI

Looker

QA/testing

Education

Bachelor's degree in Computer Science, Statistics, Data Analytics, Mathematics, or a related field

Tools

Teradata SQL Assistant

BTEQ

Job description

Novalink Solutions LLC in Richmond, VA is seeking a DMAS Data Reporting & UAT Analyst. The role focuses on reviewing design documents, mapping data between interfaces, and supporting testing and validation across ETL pipelines and reports.

The ideal candidate brings 5+ years of Medicaid/Medicare experience, advanced SQL in Teradata, and proven skills in data extraction, reporting, and visualization with tools like Tableau or Power BI. Collaboration with vendors and stakeholders is essential.