Medicaid Data Analytics Lead

CSpring; Springfield (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

CSpring seeks a seasoned Business Analyst to lead Medicaid reporting efforts in Springfield, IL. You will gather requirements, translate federal guidance into actionable rules, and coordinate with the SME, ETL, and QA teams to deliver accurate dashboards and reports.

You’ll mentor junior analysts, drive UAT, and maintain documentation in SharePoint and Azure DevOps, while communicating insights to both technical and non-technical stakeholders. Travel to client sites is occasional.

Qualifications

• Bachelor’s degree or equivalent experience.
• 8+ years of business analysis experience including requirements gathering, documentation, stakeholder facilitation, and user acceptance testing.
• 5+ years working with healthcare data (claims, eligibility, enrollment, provider, or financial data).
• 3+ years with Medicaid/public-sector healthcare programs and Medicaid data warehouses.
• 3+ years writing SQL to analyze data in a relational database or data warehouse.
• Understanding of CMS reporting requirements for Medicaid.
• Experience writing use cases, user stories, and acceptance criteria and supporting testing/UAT.
• Proficient in MS Word, Excel, PowerPoint, Visio, MS Project, SharePoint and Teams.

Responsibilities

• Gather, document, and manage requirements for EDW reports, extracts, and CMS reporting support.
• Analyze current processes and document requirements for new or changed processes.
• Translate Medicaid policy and reporting guidance into business rules with SME direction.
• Write clear artifacts: BRs, rules, use cases, user stories, acceptance criteria, data mappings, and flows.
• Maintain requirements traceability from request through design, testing, and delivery.
• Schedule and facilitate sessions with State users, Optum technical teams, and partners; capture minutes and actions.
• Write SQL to profile Medicaid enrollment, eligibility, provider, claims, and financial data.
• Identify data anomalies and coordinate with ETL/BI/QA to resolve them.
• Share use cases with data analysts for profiling and validation.
• Support testing and UAT including test scenarios and defect reporting.
• Prepare presentations and status updates for SME and leadership.
• Maintain documentation in SharePoint and Azure DevOps; support end-user training.
• Mentor junior analysts and back up Medicaid SME on daily questions.
• Peer review artifacts and help manage change requests.

Skills

Stakeholder facilitation

Requirements gathering

User acceptance testing

Data analysis

Education

Bachelor's degree in a related field

Tools

MS Word

Excel

PowerPoint

Visio

MS Project

SharePoint

Teams

Azure DevOps

JIRA

Power BI

Job description

CSpring seeks a seasoned Business Analyst to lead Medicaid reporting efforts in Springfield, IL. You will gather requirements, translate federal guidance into actionable rules, and coordinate with the SME, ETL, and QA teams to deliver accurate dashboards and reports.

You’ll mentor junior analysts, drive UAT, and maintain documentation in SharePoint and Azure DevOps, while communicating insights to both technical and non-technical stakeholders. Travel to client sites is occasional.