Data Analyst Expert

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; and 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 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. 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. 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. 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. 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. 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. Experience with data warehouse or analytics platforms. Strong understanding of Medicaid data domains: claims, 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 or system takeover scenarios. Exposure to ETL tools (DataStage, Informatica, etc.). Prior experience working with State Medicaid agencies. J-18808-Ljbffr