MS Data Management Consultant - 26-13761

Job Description

Job DescriptionJob Title: MS Data Management Consultant

Duration: 8 Months Contract (NO BENEFITS)

Location: Sioux Falls, South Dakota

Job Overview

We are seeking an experienced Data Management Consultant to support Medicaid data governance, data architecture, and integration documentation initiatives. The consultant will work with state IT teams and Medicaid stakeholders to assess existing data structures, document system interfaces, establish data catalogs and lineage, and develop comprehensive data governance and management recommendations.

The ideal candidate will have strong expertise in Microsoft Purview, healthcare data management, enterprise data modeling, interface documentation, and data governance frameworks.

Key Responsibilities Data Governance and Management

• Develop a comprehensive Medicaid Data Governance and Management Plan in collaboration with stakeholders.

• Assess existing data management practices and recommend improvements to governance, data quality, security, and compliance.

• Establish data governance standards, policies, and best practices for Medicaid applications.

• Identify risks associated with current data management processes and interface structures.

• Recommend tools and strategies for improving data cataloging, governance, and system integration.

Data Catalog and Data Lineage

• Create and maintain a Medicaid-related data catalog covering relevant data assets.

• Document data lineage to track data movement, transformation, and usage across systems.

• Develop conceptual, logical, and physical data models.

• Assess existing data warehouse structures and recommend improvements or new structures where necessary.

• Use Microsoft Purview and other appropriate tools to support metadata management and data discovery.

Interface Registry and Documentation

• Create and maintain an interface registry covering South Dakota Medicaid applications.

• Develop Interface Control Documents (ICDs) for interfaces that lack existing documentation.

• Create a comprehensive Interface Management Plan.

• Document system-to-system interactions, data flows, integrations, and data exchange processes.

• Identify interface gaps, data inconsistencies, integration challenges, and potential security or compliance risks.

• Recommend improvements to interface documentation and data-sharing practices.

Requirements Gathering and Stakeholder Collaboration

• Work with state IT resources and Medicaid stakeholders to gather business and technical requirements.

• Analyze existing data sources, data mappings, and interface structures.

• Collaborate with state technical teams to understand legacy systems and mainframe data, recognizing that direct mainframe access may not be available.

• Map data flows between Medicaid systems, business processes, internal reporting, and external partners.

• Document data storage, organization, access, and security practices.

Reporting and Project Delivery

• Prepare monthly status reports detailing completed activities, progress, and timelines.

• Identify project risks, dependencies, and potential delivery challenges.

• Coordinate with stakeholders to ensure deliverables meet project requirements.

• Provide recommendations for streamlining data management, governance, and system integration.

• Ensure all project activities remain focused on Medicaid-related data management deliverables.

Required Skills and Qualifications

• Expert-level proficiency with Microsoft Purview.

• Senior-level or expert-level knowledge of healthcare services and healthcare data management.

• Strong experience with relational SQL and NoSQL database technologies.

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

• Demonstrated expertise in conceptual, logical, and physical data modeling.

• Experience developing data catalogs, data lineage documentation, and metadata management solutions.

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

• Knowledge of data governance frameworks and experience implementing data governance programs.

• Experience writing Interface Control Documents (ICDs) and documenting system integrations.

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

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

• Ability to assess existing systems and recommend improvements to data governance, interface management, and system integration.

• Experience coordinating multiple workstreams and managing project deliverables.

Preferred Qualifications

• Experience with Medicaid systems, healthcare data, or government healthcare programs.

• Familiarity with healthcare data exchange, reporting requirements, and regulatory compliance.

• Experience with enterprise metadata management and data governance tools.

• Knowledge of data architecture, interface design principles, and user experience considerations.

• Practical experience with software development, interface troubleshooting, and integration optimization.

• Relevant professional certifications in data management, data governance, Microsoft Purview, or related disciplines.

• Strong project management skills and experience delivering enterprise data management initiatives.