Senior Medicaid Data Analyst - EDW & SQL (Remote)

MSR Technology Group; Chicago (IL); Remote; USD 110,000 - 160,000; Full time

Job summary

MSR Technology Group is seeking a Senior Medicaid Business Data Analyst to support a large-scale Medicaid EDW environment. The role combines strong business analysis with hands-on SQL, focusing on Medicaid data, reporting, and data quality.

The ideal candidate will gather requirements, analyze data, and collaborate with ETL/BI teams, participating in testing and UAT, with occasional travel to Springfield, IL. This is a remote-continuous role within the Continental U.S.

Qualifications

• 8+ years of business analysis experience in a healthcare context.
• 5+ years working with healthcare data including claims, encounters, eligibility/enrollment, provider or financial data.
• 3+ years Medicaid or public-sector healthcare experience.
• 3+ years hands-on SQL experience analyzing and validating data.
• Experience with state Medicaid, CHIP, MMIS/MES, Medicaid data warehouses or Medicaid managed care.
• Strong requirements gathering and stakeholder facilitation skills.
• Ability to write use cases, user stories, acceptance criteria, and support UAT.
• Bachelor's degree or equivalent experience in a related field.

Responsibilities

• Gather and document business requirements for EDW reports, extracts, enhancements, and Medicaid reporting initiatives.
• Develop business rules, data mappings, use cases, and process flows.
• Translate Medicaid policy and reporting needs into clear data requirements.
• Write SQL to analyze and validate Medicaid claims, encounters, eligibility/enrollment, provider, and financial data.
• Collaborate with ETL, BI, QA, and business teams to resolve data issues.
• Support testing and UAT including test scenarios and defect follow-up.

Skills

Business Analysis

Healthcare data

Medicaid experience

SQL

Requirements gathering

Stakeholder facilitation

Documentation

Testing/UAT support

Communication skills

Education

Bachelor's degree

Tools

Azure DevOps

JIRA

Tableau

Power BI

Business Objects

ETL tools

Job description

MSR Technology Group is seeking a Senior Medicaid Business Data Analyst to support a large-scale Medicaid EDW environment. The role combines strong business analysis with hands-on SQL, focusing on Medicaid data, reporting, and data quality.

The ideal candidate will gather requirements, analyze data, and collaborate with ETL/BI teams, participating in testing and UAT, with occasional travel to Springfield, IL. This is a remote-continuous role within the Continental U.S.