Senior Data Governance & Management Consultant - Healthcare/Medicaid

Location: Sioux Falls, South Dakota
Duration: 8 Months
Expected Start Date: November 9, 2026
Division: Division of Medical Services
Project: South Dakota Medicaid Modernization
 

The Client is seeking an experienced Senior Data Governance and Management Consultant to support data management initiatives for the South Dakota Medicaid Modernization project.

The consultant will collaborate with state IT teams, Medicaid program staff, and other stakeholders to assess existing data structures, system interfaces, data flows, and governance practices. The primary responsibility is to develop comprehensive Medicaid-related data management documentation, including data catalogs, data lineage, interface registries, Interface Control Documents (ICDs), an Interface Management Plan, and a Data Governance and Management Plan.

The ideal candidate will possess expert-level knowledge of Microsoft Purview, strong healthcare data management experience, and hands-on expertise in enterprise data modeling, database technologies, data governance, and interface documentation.

• Conduct requirements-gathering sessions with state IT resources, DSS staff, and other stakeholders to understand existing data sources, data mappings, and system interfaces.

• Develop a comprehensive interface registry for all South Dakota Medicaid applications.

• Create and document Interface Control Documents (ICDs) for Medicaid-related interfaces that lack existing documentation.

• Develop a Medicaid Interface Management Plan.

• Create and maintain a Medicaid data catalog and data lineage documentation.

• Develop conceptual, logical, and physical data models and recommend data warehouse structures where necessary.

• Develop a Medicaid Data Governance and Management Plan in collaboration with DSS and other state resources.

• Analyze system-to-system interactions and map data flows across Medicaid applications, business processes, and reporting systems.

• Document data movement, storage, organization, security, and information exchange with internal and external partners.

• Evaluate existing data management practices, governance frameworks, interface documentation, and related controls.

• Recommend suitable tools and technologies for data cataloging, lineage tracking, interface management, and enterprise data governance.

• Identify risks associated with data management, interface structures, data inconsistencies, integration challenges, security, and compliance.

• Recommend improvements to data governance, data quality, data sharing, and system integration processes.

• Coordinate with state IT personnel to understand mainframe data and related interfaces, as direct access to mainframe data will not be available.

• Prepare monthly status reports documenting completed activities, project progress, deliverables, and timelines.

• Ensure all activities remain within the scope of Medicaid-related data management deliverables.

• Expert-level hands-on experience with Microsoft Purview.

• Strong proficiency in relational SQL and NoSQL database technologies.

• Senior-level healthcare industry experience, preferably involving Medicaid, healthcare services, or healthcare information systems.

• Experience with enterprise data modeling tools such as ERwin or ER/Studio.

• Strong understanding of enterprise database architecture, database management, and database design principles.

• Demonstrated experience with conceptual, logical, and physical data modeling.

• Hands-on experience developing data catalogs and documenting data lineage.

• Strong knowledge of data governance frameworks, policies, standards, and best practices.

• Experience implementing or improving enterprise data governance programs.

• Experience preparing Interface Control Documents (ICDs) and technical interface documentation.

• Understanding of business intelligence, data warehousing, and data integration concepts.

• Knowledge of interface design principles, troubleshooting, and interface performance optimization.

• Practical experience in software development and system interface design.

• Familiarity with modern data management and governance tools.

• Understanding of user interface and user experience principles.

• Strong analytical, problem-solving, documentation, and communication skills.

• Strong project management skills, including the ability to manage multiple activities, stakeholders, and deliverables simultaneously.

• Ability to work effectively with technical teams and business stakeholders to ensure successful project delivery.

• Experience with Medicaid modernization or large-scale healthcare IT transformation projects.

• Previous experience supporting state government agencies or public-sector healthcare programs.

• Knowledge of healthcare data security, regulatory compliance, and data management standards.

• Relevant professional certifications in data governance, database management, data architecture, or related disciplines.

• Familiarity with industry-specific data management and interface tools.

1. Medicaid Data Catalog.

2. Medicaid Data Lineage Documentation.

3. Medicaid Application Interface Registry.

4. Interface Control Documents (ICDs) for undocumented Medicaid interfaces.

5. Medicaid Interface Management Plan.

6. Medicaid Data Governance and Management Plan.

7. Data modeling and data warehouse structure recommendations, where applicable.

8. Recommendations for data governance, cataloging, lineage, interface management, and supporting tools.

9. Identification of risks and recommendations for improving data quality, governance, security, and system integration.

10. Monthly project status reports.

• The engagement is expected to last approximately eight months, starting on or around November 9, 2026.

• The project location and evaluation team are based in Sioux Falls, South Dakota.

• The consultant must work through state IT resources to understand mainframe data and interfaces, as direct mainframe access will not be available.

• The scope is limited to Medicaid-related data management deliverables. Documentation of non-Medicaid interfaces is outside the project scope.

Interested candidates must provide:

• An updated resume highlighting relevant experience.

• Three professional references.

• Confirmation of availability for the proposed project start date and duration.

Candidates with strong Microsoft Purview expertise, healthcare data governance experience, and hands-on experience developing interface documentation and data lineage are encouraged to apply.