This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Clover Consulting (a Myticas Co.) is are seeking a highly experienced EDW Medicaid Subject Expert – Data Specialist/Federal Reporting. You’ll work on mission-driven projects that directly support Medicaid programs, public health outcomes, and federal compliance. You’ll collaborate with talented peers, work with modern data platforms, and have opportunities for continuous learning and career growth—while making a meaningful impact at scale. This position is a Medicaid Subject Matter (SME) Expert for the Illinois Enterprise Data Warehouse supporting the State of Illinois Medicaid program. This role requires significant expertise of Medicaid Enterprise System modules and data warehousing or decision support systems. This role provides the guidance and direction to support a large data warehouse implementation and maintenance & operations. The selected SME will provide the required decisions for the business and technical team members to modify, change, enhance or correct within the system, related to claims, provider, and recipient data. Roles in this function will partner with stakeholders to understand data requirements and support development tools and models such as interfaces, dashboards, data visualizations, decision aids and business case analysis to support the organization. Additional roles include producing and managing the delivery of activity, value analytics and critical deliverables to external stakeholders and clients. This is a telecommuting position with some (<25%) required travel to Springfield, IL for onsite customer meetings.
Job Responsibility
Provide direction, guidance and recommendations supporting decision making for large Medicaid data warehouse implementation and operations
With the specialized knowledge of the Medicaid and Children’s Health Insurance Programs, lead and guide internal and external stakeholders to make determinations relating to complex processes involving claims processing/adjudication, recipient/provider eligibility, and third-party liability
Proactively identify and understand state Medicaid agency data needs and determines the recommended solution to meet them with credible reason, justification and validated proof of concepts
Direct technical and business teams on healthcare topics understanding and utilizing healthcare data appropriately
Proactively suggest and recommend enhancements and improvements throughout the project processes, driven by Medicaid best practices, standards and policies.
Requirements
More than ten (10) years of experience in information technology with five (5) years of experience working directly with/for State Medicaid agencies or equivalent supporting business initiatives through data analysis, writing business requirements and testing/validation of various systems
More than five (5) years of experience serving as the subject matter expert for CMS and State Medicaid federal reporting, including T-MSIS, PERM, MARS, and other CMS-mandated submissions, ensuring data accuracy, compliance, and audit readiness
Understanding of claims, recipient/eligibility, and provider/enrollment data processes
Advanced SQL proficiency with over 5 years of experience analyzing large Medicaid data sets (claims, eligibility, provider, and federal extracts) within an EDW environment
Knowledge of the Centers for Medicare and Medicaid Services reporting requirements and the programs covered
Excellent verbal/written communication and presentation skills, manager/executive/director-level client facing, team collaboration, and mentoring skills
Strong culture fit, demonstrating our culture values in action (Integrity, Compassion, Inclusion, Relationships, Innovation, and Performance)
Ability to travel to Springfield, IL two (3) to three (4) times per year
Candidates absolutely must have Medicaid experience working for a state in the US, must be familiar with and have worked on projects with large data sets.
Nice to have
More than 2 years of experience in HEDIS, CHIPRA or similar quality metrics
Experience with data analysis using Teradata Database Management System or other equivalent database management system
Experience using JIRA, Rally, DevOps or equivalent
Previous experience on large implementation project.