Business Data Analyst - Medicaid

Fully Remote
• Springfield, IL Description

At CSpring, we believe in the power of data to drive decisions and real-world impact. We’re a purpose-driven consulting firm specializing in data strategy, data engineering, and data analytics. Our clients span the public and private sectors, and our work helps them solve complex problems, gain insights, and achieve measurable results.  We're seeking talented professionals who are collaborative, curious, and committed to making a difference that thrive at the intersection of data, technology, and business strategy.

Whether you're passionate about transforming public programs, enabling executive decision-making, or modernizing legacy systems, you'll find meaningful work and purpose here.

Why You’ll Love Working Here Purposeful Projects – Improve systems that serve real people by delivering smarter data, streamlined processes, and strategic insight.

People-First Culture – We’re as committed to your growth as we are to delivering high-impact solutions. You’ll find support, autonomy, and community here.

Strategic, Hands-On Work – From data architecture and documentation to client workshops and solution delivery, you’ll influence every step of the process.

Collaborative Trust – Our clients rely on us to listen carefully, deliver consistently, and guide wisely. We partner with integrity, curiosity, and heart.

What You’ll DoYou’ll own the day-to-day documentation, coordination and analysis that keep Medicaid reporting deliverables moving, with limited supervision and guidance from the Medicaid SME:

Gather, document, and manage business requirements for EDW reports, extracts, and enhancements, including federal reporting such as CMS-64/CMS-21 support, MARS, T-MSIS, and PERM.Analyze current business processes and systems and document requirements for new or changed processes.

Help translate federal and State Medicaid policy and reporting guidance into business rules and requirements, with direction from the Medicaid SME.Write clear requirements artifacts: business requirements, business rules, use cases, user stories, acceptance criteria, data mappings, and process flows.

Maintain requirements traceability from request through design, testing, and delivery.

Schedule and facilitate working sessions with State business users, Optum technical teams, and other partners. Capture minutes, decisions, action items, and follow-ups.

Track open questions, dependencies, and risks for assigned work, and escalate issues to the SME and project lead when needed.

Write SQL to profile and analyze Medicaid enrollment, eligibility, provider, claims, encounter, and financial data to answer business questions and confirm requirements.

Identify and document data anomalies and report variances, and work with ETL, BI, and QA teams to resolve them.

Share use cases with data and quality analysts for profiling, review results, and confirm alignment with project requirements and Medicaid/CMS guidelines.

Support testing and UAT, including test scenarios, acceptance criteria, defect reporting, and follow-up.

Prepare presentations, summaries, and status updates for the SME, internal leadership, and the customer.

Maintain business documentation, data definitions, the Operations Guide, and related process documentation in SharePoint and Azure Dev Ops.

Support end-user training and training materials related to reports and data.

Mentor junior analysts and serve as backup to the Medicaid SME on day-to-day business questions and reporting processes.

Peer review project artifacts and help manage intake and change requests, including impact analysis and BA effort estimates.

Requirements Bachelor’s degree in business, information systems, public health, or a related field, or equivalent experience.
8+ years…