← Back to jobsJob ID col-cmwjhcgaq0hzh89hqce5gek5x

MSR Technology GroupPosted 11 days ago

Senior Medicaid Business Data Analyst – EDW & SQL

Contract
Remote
8+ years
Competitive
Posted 11 days ago

MSR Technology Group is seeking a Senior Medicaid Business Data Analyst to support a State Medicaid Enterprise Data Warehouse. The role combines business analysis and hands-on SQL to gather requirements, analyze Medicaid data, support reporting, investigate data issues, and assist with testing and UAT.

Posted
11 days ago
Source
msrtechnologies.com
Sector
Consulting

Opens the employer's application page in a new tab

Responsibilities

  • Gather and document business requirements for EDW reports, extracts, enhancements, and Medicaid reporting initiatives
  • Develop business requirements, business rules, use cases, user stories, acceptance criteria, data mappings, and process flows
  • Work with Medicaid reporting initiatives including CMS-64/CMS-21, MARS, T-MSIS, and PERM
  • Translate Medicaid policy and reporting needs into clear business and data requirements
  • Write SQL to analyze and validate Medicaid claims, encounters, eligibility/enrollment, provider, and financial data
  • Research data questions, anomalies, and reporting variances
  • Work closely with ETL, BI, QA, and business teams to resolve data issues
  • Facilitate business and technical working sessions
  • Document decisions, action items, risks, dependencies, and follow-ups
  • Support testing and UAT, including test scenarios, acceptance criteria, and defect follow-up
  • Maintain requirements traceability through design, testing, and delivery
  • Prepare project summaries, presentations, and status updates
  • Support change requests, impact analysis, documentation, and training

Qualifications

  • 8+ years of Business Analysis experience
  • 5+ years working with healthcare data, including claims, encounters, eligibility/enrollment, provider, or financial data
  • 3+ years of Medicaid or public-sector healthcare experience
  • 3+ years of hands-on SQL experience analyzing and validating data
  • Experience with State Medicaid, CHIP, MMIS/MES, Medicaid data warehouses, or Medicaid managed care
  • Understanding of Fee-for-Service and managed care claim adjudication
  • Understanding of eligibility/enrollment, claims processing, managed care encounters, and healthcare funding/finance
  • Basic understanding of CMS Medicaid reporting requirements
  • Experience writing use cases, user stories, acceptance criteria, and supporting UAT
  • Strong requirements gathering and stakeholder facilitation experience
  • Strong written and verbal communication skills
  • Bachelor's degree in Business, Information Systems, Public Health, or a related field, or equivalent experience

Preferred

  • CMS-64/CMS-21, MARS, T-MSIS, and/or PERM
  • Medicaid Enterprise Systems (MES) or MMIS
  • Medicaid Enterprise Data Warehouse projects
  • Tableau, Power BI, or Business Objects
  • ETL and enterprise reporting processes
  • Azure DevOps or JIRA
  • CMS Core Set, HEDIS, or CHIPRA
  • CBAP, CCBA, or PMI-PBA certification
  • Medicaid Enterprise Systems (MES)
  • Medicaid Enterprise Data Warehousing

Required skills

Business AnalysisCMS Medicaid Reporting CMS-64/CMS-21CMS Medicaid Reporting MARSCMS Medicaid Reporting PERMCMS Medicaid Reporting T-MSISMMIS/MESMedicaid Claims AdjudicationMedicaid Enterprise Data WarehousesMedicaid Healthcare DataPower BIRequirements Gathering and AnalysisTableauTeradata

Nice to have

Agile/ScrumAzure DevOps or JIRA

Full job description

MSR Technology Group is seeking a Senior Medicaid Business Data Analyst to support a State Medicaid Enterprise Data Warehouse. The role combines business analysis and hands-on SQL to gather requirements, analyze Medicaid data, support reporting, investigate data issues, and assist with testing and UAT.

Responsibilities

  • Gather and document business requirements for EDW reports, extracts, enhancements, and Medicaid reporting initiatives
  • Develop business requirements, business rules, use cases, user stories, acceptance criteria, data mappings, and process flows
  • Work with Medicaid reporting initiatives including CMS-64/CMS-21, MARS, T-MSIS, and PERM
  • Translate Medicaid policy and reporting needs into clear business and data requirements
  • Write SQL to analyze and validate Medicaid claims, encounters, eligibility/enrollment, provider, and financial data
  • Research data questions, anomalies, and reporting variances
  • Work closely with ETL, BI, QA, and business teams to resolve data issues
  • Facilitate business and technical working sessions
  • Document decisions, action items, risks, dependencies, and follow-ups
  • Support testing and UAT, including test scenarios, acceptance criteria, and defect follow-up
  • Maintain requirements traceability through design, testing, and delivery
  • Prepare project summaries, presentations, and status updates
  • Support change requests, impact analysis, documentation, and training

Preferred

  • CMS-64/CMS-21, MARS, T-MSIS, and/or PERM
  • Medicaid Enterprise Systems (MES) or MMIS
  • Medicaid Enterprise Data Warehouse projects
  • Teradata
  • Tableau, Power BI, or Business Objects
  • ETL and enterprise reporting processes
  • Azure DevOps or JIRA
  • Agile/Scrum
  • CMS Core Set, HEDIS, or CHIPRA
  • CBAP, CCBA, or PMI-PBA certification
  • CMS-64/CMS-21
  • MARS
  • T-MSIS
  • PERM
  • Medicaid Enterprise Systems (MES)
  • MMIS
  • Medicaid Enterprise Data Warehousing
  • Tableau
  • Power BI
  • Business Objects
  • ETL
  • Enterprise Reporting
  • Azure DevOps
  • JIRA
  • Agile
  • Scrum
  • CMS Core Set
  • HEDIS
  • CHIPRA
  • CBAP Certification
  • CCBA Certification
  • PMI-PBA Certification

Benefits

  • Remote – Continental U.S.

Company

  • Professional services for technology and industry domains
  • Wilmington, Delaware, USA
  • https://www.msrtechnologies.com/
  • 1001-5000 employees

Qualifications

  • 8+ years of Business Analysis experience
  • 5+ years working with healthcare data, including claims, encounters, eligibility/enrollment, provider, or financial data
  • 3+ years of Medicaid or public-sector healthcare experience
  • 3+ years of hands-on SQL experience analyzing and validating data
  • Experience with State Medicaid, CHIP, MMIS/MES, Medicaid data warehouses, or Medicaid managed care
  • Understanding of Fee-for-Service and managed care claim adjudication
  • Understanding of eligibility/enrollment, claims processing, managed care encounters, and healthcare funding/finance
  • Basic understanding of CMS Medicaid reporting requirements
  • Experience writing use cases, user stories, acceptance criteria, and supporting UAT
  • Strong requirements gathering and stakeholder facilitation experience
  • Strong written and verbal communication skills
  • Bachelor's degree in Business, Information Systems, Public Health, or a related field, or equivalent experience
  • CMS-64/CMS-21, MARS, T-MSIS, and/or PERM
  • Medicaid Enterprise Systems (MES) or MMIS
  • Medicaid Enterprise Data Warehouse projects
  • Teradata
  • Tableau, Power BI, or Business Objects
  • ETL and enterprise reporting processes
  • Azure DevOps or JIRA
  • Agile/Scrum
  • CMS Core Set, HEDIS, or CHIPRA
  • CBAP, CCBA, or PMI-PBA certification

Required skills

  • Business Analysis, CMS Medicaid Reporting CMS-64/CMS-21, CMS Medicaid Reporting MARS, CMS Medicaid Reporting PERM, CMS Medicaid Reporting T-MSIS, MMIS/MES, Medicaid Claims Adjudication, Medicaid Enterprise Data Warehouses, Medicaid Healthcare Data, Power BI, Requirements Gathering and Analysis, Tableau, Teradata

Preferred skills

  • Agile/Scrum, Azure DevOps or JIRA, CBAP, CCBA, or PMI-PBA certification, CMS Core Set, HEDIS, or CHIPRA, CMS-64/CMS-21, MARS, T-MSIS, and/or PERM, ETL and enterprise reporting processes, Medicaid Enterprise Data Warehouse projects, Medicaid Enterprise Systems (MES) or MMIS, Tableau, Power BI, or Business Objects

Experience

  • 8+ years

Job details

Employment type

Contract

Seniority level

8+ years

Sector · Sub-sector

Consulting · IT Consulting

Date posted

Nov 9, 2026

Work mode

Remote

Job source

msrtechnologies.com

Company

MSR Technology Group

Consulting

Professional services for technology and industry domains

See all 4 jobs from MSR Technology Group →

Similar jobs

Matched on role, skills and location · live jobs only

See more Business Analyst jobs

Dice

4d ago

Retirement Service Subject Matter Expert (SME) - Business Analyst Experience

Full-timeRemoteUnited StatesCompetitive

Systems Engineering Services is recruiting for an unnamed client that is integrating an acquired company’s data and systems into its IT ecosystem.

Why similarSame roleBusiness Analysis

Matricstek Inc.

4d ago

Junior Business Analyst

Full-timeOn-siteNew York, NYCompetitive

Matricstek Inc. is hiring an entry-level Business Analyst to support data analysis and business process improvement.

Why similarSame roleBusiness AnalysisPower BI

Envision

4d ago

IT Business Analyst

TemporaryRemoteUnited StatesCompetitive

Envision is seeking an IT Business Analyst to perform technical business analysis and support project coordination, agency onboarding, vendor coordination, requirements development, and platform improvements.

Why similarSame role

Get new Business Analyst jobs by email

Create job alert

Senior Medicaid Business Data Analyst – EDW & SQL

MSR Technology Group · Competitive

Apply on company site