Back to jobs

Business Data Analyst - Medicaid

Pay
Pay not listedSimilar roles state $95K–$145K
Work setting
Hybrid — work setting source
Work setup in the employer’s posting: Hybrid
From the employer’s posting
Employment
Not stated

What you’ll work on

Full posting
  • Gather, document and manage requirements for EDW reports, extracts and federal reporting

  • Write SQL to profile Medicaid enrollment, claims, provider and financial data

  • Translate federal and State Medicaid policy into business rules

  • Facilitate working sessions with State users and Optum technical teams

  • Support testing and UAT with scenarios, acceptance criteria and defect follow-up

From the employer’s posting
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.
Write SQL to profile and analyze Medicaid enrollment, eligibility, provider, claims, encounter, and financial data to answer business questions and confirm requirements.
Help translate federal and State Medicaid policy and reporting guidance into business rules and requirements, with direction from the Medicaid SME.
Schedule and facilitate working sessions with State business users, Optum technical teams, and other partners.
Support testing and UAT, including test scenarios, acceptance criteria, defect reporting, and follow-up.

What you’ll bring

All qualifications

Core experience

  • Bachelor’s degree in business, information systems, public health, or a related field, or equivalent experience.
  • Experience with CMS federal reporting such as CMS-64/CMS-21, MARS, T-MSIS, PERM, or similar projects.
  • 8+ years of business analysis experience, including requirements gathering, documentation, stakeholder facilitation, and user acceptance testing.
  • Knowledge of quality measures such as CMS Core Set, HEDIS, or CHIPRA.
  • 5+ years of experience working with healthcare data such as claims, encounters, eligibility/enrollment, provider, or financial data.
  • Knowledge of health insurance, HMO, and managed care principles, including Medicaid and Medicare regulation, the Affordable Care Act, and eligibility.
Qualification wording
Bachelor’s degree in business, information systems, public health, or a related field, or equivalent experience.
Experience with CMS federal reporting such as CMS-64/CMS-21, MARS, T-MSIS, PERM, or similar projects.
8+ years of business analysis experience, including requirements gathering, documentation, stakeholder facilitation, and user acceptance testing.
Knowledge of quality measures such as CMS Core Set, HEDIS, or CHIPRA.
5+ years of experience working with healthcare data such as claims, encounters, eligibility/enrollment, provider, or financial data.
Knowledge of health insurance, HMO, and managed care principles, including Medicaid and Medicare regulation, the Affordable Care Act, and eligibility.
Education & alternatives
Requirements - Bachelor’s degree in business, information systems, public health, or a related field, or equivalent experience. - 8+ years of business analysis experience, including requirements gathering, documentation, stakeholder facilitation, and user acceptance testing.
Apply at CSpring

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026
Employer says posted
Oct 23, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 5 and day 43.

From 16,009 similar postings that came down. Coming down is not always a hire.

CSpring is hiring

5 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Azure
  • Excel
  • Power BI
  • Tableau
  • Teradata
Where the posting names them
- 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.
- 3+ years of experience with Medicaid or public-sector healthcare programs, such as State Medicaid/CHIP agencies, MMIS/MES vendors, Medicaid data warehouses, or Medicaid managed care plans. - 3+ years of experience writing SQL to analyze and validate data in a relational database or data warehouse. - Understanding of Fee for Service and managed care claim adjudication, from eligibility and enrollment through claims processing to funding/finance, including managed care encounters.
- Experience on a Medicaid Enterprise System (MES)/MMIS or Enterprise Data Warehouse DDI project. - Experience with Teradata and SQL Assistant/Query Studio, Business Objects, Tableau, or Power BI. - Familiarity with ETL and reporting processes.
- 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 DevOps. - Support end-user training and training materials related to reports and data.
- Experience with knowledge management tools such as Microsoft 365, SharePoint/Teams, and AI-enabled search. - Experience with Azure DevOps or JIRA, and Agile/Scrum projects. - CBAP, CCBA, or PMI-PBA certification.
- Experience facilitating meetings and documenting outcomes. - Proficient in MS Word, Excel, PowerPoint, Visio, MS Project, SharePoint, and Teams. - Strong written and verbal communication skills, with the ability to explain data findings to both technical and non-technical audiences.

Your next step

Complete your application on recruiting.paylocity.com. The employer’s form will show what is required.

Applying through Paylocity

  • “Upload your resume and we’ll automatically fill out your application”: the form fills itself from your file, so check it before sending.

Already applied? Track this application

Job description

View original posting ↗

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 Do

 

You’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 DevOps.
  • 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 of business analysis experience, including requirements gathering, documentation, stakeholder facilitation, and user acceptance testing.
  • 5+ years of experience working with healthcare data such as claims, encounters, eligibility/enrollment, provider, or financial data.
  • 3+ years of experience with Medicaid or public-sector healthcare programs, such as State Medicaid/CHIP agencies, MMIS/MES vendors, Medicaid data warehouses, or Medicaid managed care plans.
  • 3+ years of experience writing SQL to analyze and validate data in a relational database or data warehouse.
  • Understanding of Fee for Service and managed care claim adjudication, from eligibility and enrollment through claims processing to funding/finance, including managed care encounters.
  • Basic understanding of CMS reporting requirements for Medicaid.
  • Experience writing use cases, user stories, and acceptance criteria and supporting testing/UAT.
  • Experience facilitating meetings and documenting outcomes.
  • Proficient in MS Word, Excel, PowerPoint, Visio, MS Project, SharePoint, and Teams.
  • Strong written and verbal communication skills, with the ability to explain data findings to both technical and non-technical audiences.
  • Organized and detail-oriented, and able to manage competing priorities and tight deadlines with limited supervision.
  • Ability to travel to Springfield, IL up to three (3) times per year or as needed.

Bonus Experience

  • Experience with CMS federal reporting such as CMS-64/CMS-21, MARS, T-MSIS, PERM, or similar projects.
  • Knowledge of quality measures such as CMS Core Set, HEDIS, or CHIPRA.
  • Knowledge of health insurance, HMO, and managed care principles, including Medicaid and Medicare regulation, the Affordable Care Act, and eligibility.
  • Experience on a Medicaid Enterprise System (MES)/MMIS or Enterprise Data Warehouse DDI project.
  • Experience with Teradata and SQL Assistant/Query Studio, Business Objects, Tableau, or Power BI.
  • Familiarity with ETL and reporting processes.
  • Experience with knowledge management tools such as Microsoft 365, SharePoint/Teams, and AI-enabled search.
  • Experience with Azure DevOps or JIRA, and Agile/Scrum projects.
  • CBAP, CCBA, or PMI-PBA certification.
  • Located within driving distance of Springfield, IL.

Come Build With Us

At CSpring, we unlock the potential of people and data. If you're ready to lead meaningful projects, collaborate with passionate teams, and grow your career in a people-first consulting environment—apply today!

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Springfield, IL

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.