Medicaid Data Management / Data Governance & Interface Documentation Consultant

Roles/Responsibilities:

• Requirements gathering phase working with state IT resources and other members of DSS to assist with data sources, current data mapping and current interface structure with the understanding that access to the mainframe data directly will not be possible (working through state IT resources will be required).
• Create Medicaid-related Interface Registry for all South Dakota (SD) Medicaid applications.
• Document and write Medicaid-related Interface Control Documents (ICDs) for any interface listed in the Interface Registry that does not have an associated ICD.
• Create a Medicaid-related Interface Management Plan
• Create Medicaid related data modeling, data warehouse structure if none exists.
• Create Medicaid data catalog and data lineage.
• Create Medicaid-related Data Governance and Management Plan in consultation with DSS and other State resources.
• Work alongside SD State Medicaid staff to understand system to system interactions and data flow and map movement of data between different parts of SD Medicaid systems and processes, reporting of data to internal and external partners, and data storage, organization and security.
• Recommendations on improvements to current data governance and management, ICD's and other data control documents for all SD Medicaid systems and applications, including recommendations on data governance, data cataloging, data interface documentation, and other data related tools.
• Identification of risks related to current data management and interface structure.
• Recommendations on streamlining data management, data sharing, data governance and system integration. This may include data inconsistencies, integration challenges and security or compliance issues.
• Any effort that is not related to creating Medicaid-related data management deliverables is out of scope for this project. For example, any work to document non-Medicaid interfaces in the interface registry deliverable is out of scope.
• Creating a monthly status report associated with any work accomplished timelines related to this work order.
• Other related duties as assigned.

Mandatory Skills:

1. Proficiency in relational SQL and NoSQL database technologies.
2. Expert level of knowledge in the use of Microsoft Purview.
3. Minimum senior level / preferred expert level healthcare services knowledge.
4. Experience working with data modeling tools such as ERwin or ER/Studio
5. A deep understanding of database management and design best practices on an enterprise level.
6. Experience with and examples of conceptual, logical, and physical data modeling, data catalogs, and data lineage.
7. Knowledge of data governance frameworks and best practices, and experience in implementing data governance programs.
8. Understanding of business intelligence concepts.
9. Strong analytical and communication skills.
10. Proficiency with modern tools.
11. Knowledge of user interface and user experience
12. Experience writing interface control documents
13. Design principles
14. Ability to troubleshoot and optimize interface functionality
15. Practical experience in software development and interface design
16. Ability to ensure seamless project delivery
17. Professional certifications in control systems or related disciplines
18. Familiarity with industry-specific control system software and tools
19. Strong project management skills and experience handling multiple projects.