Senior Business Analyst – Medicaid Data Warehouse & MMIS Reporting - Remote
About The Position
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.
Requirements
- 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
Nice To Haves
- 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
Responsibilities
- Medicaid Data Analysis & Mapping
- 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
- 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
- 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
- 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
- Ensure alignment with CMS reporting requirements, HIPAA, and state data governance policies
- Support audit readiness and documentation of data lineage, mappings, and transformations
- Produce clear documentation including: Business requirements Data mappings Data dictionaries Process flows
- Communicate effectively with business users, program teams, and technical teams
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
Number of Employees
1-10 employees
