DMAS - Data Reporting & UAT Analyst

The Custom Group of Companies
Richmond, VA, United States
4 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$114,400.0 - $122,720.0
Working hours
Regular working hours

Tech stack

Microsoft Excel Data Analysis Business Systems Databases Data Validation Extract Transform Load (ETL) Data Mining Relational Databases Database Queries Database Testing Federal Information Processing Standards (FIPS) Systems Analysis
+16 more
JAD Network Troubleshooting Performance Tuning Power BI Standard Sql Requirements Traceability SAS (Software) SQL Databases Systems Integration Tableau (Software) Teradata SQL Test Data Freeform SQL Sql Optimization Tools for Reporting Looker Analytics

Job description

We are seeking an experienced Senior Medicaid Data Analyst with strong SQL, Teradata, data validation, and business systems analysis experience to support healthcare data initiatives., Develop complex SQL queries using Teradata for data extraction, analysis, validation, and reporting. * Review technical designs, identify gaps, and develop specifications aligned with business needs. * Create and execute test plans, test cases, and data validation scripts across databases, ETL processes, and interfaces. * Investigate data discrepancies, troubleshoot system issues, and coordinate resolutions with technical teams and vendors. * Develop reports, dashboards, and visualizations using Tableau, Power BI, Looker, or similar tools. * Support system implementations, user testing, production issues, and post-go-live activities. * Maintain data definitions, workflows, technical documentation, and regulatory reporting standards.

Requirements

Acceptance Testing, Analysis Skills, NCR Teradata, Medicaid, Data Quality, Data Analysis, Systems Analysis, Business Solutions, Healthcare, SQL (Structured Query Language), The ideal candidate will have a solid background in Medicaid or Medicare systems, requirements gathering, data testing, reporting, and system integrations, with the ability to collaborate effectively with business stakeholders, developers, QA teams, and vendors., 5+ years of experience with Medicaid, Medicare, or comparable healthcare systems. * 5+ years of SQL experience, including complex queries and relational databases. * 5+ years of experience gathering business requirements, developing technical specifications, and maintaining requirements traceability. * Experience facilitating stakeholder meetings, requirements workshops, and JAD sessions. * Strong experience with Teradata SQL, including performance tuning, BTEQ, or Teradata SQL Assistant. * Experience developing test scenarios, test data, and performing data quality validation. * Experience with BI reporting tools and working closely with developers, QA teams, and vendors. * Strong analytical, problem-solving, documentation, and communication skills. * Bachelor’s degree in a related field or equivalent professional experience.

Preferred Qualifications * Experience with Medicaid eligibility, enrollment, claims, encounters, or managed care data. * Knowledge of CMS regulations, Medicaid policy, and state or federal reporting requirements. * Experience with SAS, statistical analysis, or predictive modeling. * Proficiency with Tableau, Power BI, Excel, and other reporting tools.

Ideal Candidate A hands-on Data Analyst who combines advanced SQL/Teradata expertise, Medicaid domain knowledge, business requirements analysis, and data testing experience. The successful candidate will be comfortable working independently, resolving complex data issues, and translating business needs into effective technical solutions.

Candidates must be physically located in the United States for the duration of the assignment.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…