Senior Business Analyst – Medicaid Data Warehouse & MMIS Reporting - Remote

Senior Business Analyst – Medicaid Data Warehouse & MMIS Reporting

Location: Remote Type: Full-Time

Role Summary

We are seeking a Senior Business Analyst with strong Medicaid data domain expertise to support the transition, stabilization, and enhancement of a Medicaid Data Warehouse (MDW)

This role is critical to bridging business, data, and technical teams, with a focus on:

• Understanding Medicaid claims, encounters, eligibility, and provider data
  
• Performing data analysis, mapping, and impact assessments
  
• Supporting system implementations, transitions, and reporting modernization
  

The ideal candidate brings a combination of hands-on data analysis, Medicaid program knowledge, and experience in Medicaid Data Warehouse systems or supporting large-scale system implementations or transitions.

Key Responsibilities

1.     Medicaid Data Analysis & Mapping

• Analyze Medicaid data domains including claims, encounters, eligibility, provider, and reference data
  
• Develop and validate source-to-target mappings across upstream systems (e.g., MCO submissions, MMIS, vendor systems) and the MDW
  
• Perform data profiling, reconciliation, and validation to ensure accuracy and completeness
  
• Support definition of business rules, transformations, and derived metrics
  

2.     MMIS Reporting & Data Warehouse Support

• Support ongoing operations of the Medicaid Data Warehouse and reporting platforms (e.g., Cognos)
  
• Partner with stakeholders to define and refine reporting requirements and data models
  
• Assist in improving data accessibility, usability, and performance
  

3.     System Implementation & Transition Support

• Support transition/takeover activities from vendor systems, including knowledge transfer and gap analysis
  
• Participate in system implementation lifecycle activities:
  
• Requirements gathering
  
• Functional and data analysis
  
• UAT support (validation of reports and data outputs)
  
• Collaborate with technical teams to ensure accurate translation of business requirements into data solutions
  

4.     Operations & Issue Resolution

• Monitor and support daily data warehouse operations, including ETL/data pipelines and reporting jobs
  
• Investigate and resolve data issues, discrepancies, and production incidents
  
• Conduct root cause analysis and recommend corrective actions
  

5.     Compliance & Governance

• Ensure alignment with CMS reporting requirements, HIPAA, and state data governance policies
  
• Support audit readiness and documentation of data lineage, mappings, and transformations
  

6.     Documentation & Stakeholder Communication

• Produce clear documentation including:
  
• Business requirements
  
• Data mappings
  
• Data dictionaries
  
• Process flows
  
• Communicate effectively with business users, program teams, and technical teams
  

 Required Qualifications

• 8+ years of experience as a Business Analyst in:
  
• Medicaid / healthcare data environments
  
• Data warehouse or analytics platforms
  
• Strong understanding of Medicaid data domains, including:
  
• Claims and encounters
  
• Member eligibility
  
• Provider data
  
• Managed Care (MCO) data flows
  
• Experience supporting MMIS systems or Medicaid reporting environments
  
• Strong SQL skills for data analysis, validation, and troubleshooting
  
• Experience with data mapping, source-to-target design, and data validation
  
• Experience supporting system implementations, transitions, or large data initiatives
  
• Familiarity with cloud data platforms (AWS, Azure, etc.)
  
• Strong communication skills with ability to work across technical and business stakeholders
  

Preferred Qualifications

• Experience with Cognos or similar enterprise reporting tools
  
• Experience with vendor transition / system takeover scenarios
  
• Exposure to ETL tools (DataStage, Informatica, etc.)
  
• Prior experience working with State Medicaid agencies