Remote MS Purview Data Architect (control systems/15+)

InnoSoul•Sioux Falls, SD

1d•Remote

About The Position

The MS Purview Data Architect will support South Dakota’s Medicaid Modernization by developing Medicaid-related data definition, governance, and management deliverables. The work includes gathering requirements with state IT resources and DSS staff, assessing data sources, current data mappings, and interface structures, and documenting system interactions and data flows. Direct access to mainframe data will not be available; work involving that data must be conducted through state IT resources. Deliverables include a Medicaid application Interface Registry; missing Interface Control Documents (ICDs); an Interface Management Plan; data models and, if needed, a data warehouse structure; a data catalog and data lineage; a Data Governance and Management Plan; and recommendations for tools and improvements to data governance, documentation, management, sharing, and system integration. The architect will identify risks such as data inconsistencies, integration challenges, and security or compliance issues, and provide monthly status reports. Work unrelated to Medicaid data management deliverables is out of scope. The project is based in Sioux Falls, South Dakota, and is described as remote.

Requirements

Proficiency with relational SQL and NoSQL database technologies.
Expert-level knowledge of Microsoft Purview.
Minimum senior-level healthcare services knowledge; expert-level knowledge preferred.
Experience with data modeling tools such as ERwin or ER/Studio.
Deep understanding of enterprise database management and design best practices.
Experience and examples in conceptual, logical, and physical data modeling, data catalogs, and data lineage.
Knowledge of data governance frameworks and best practices, and experience implementing data governance programs.
Understanding of business intelligence concepts.
Strong analytical and communication skills.
Proficiency with modern tools.
Knowledge of user interface and user experience.
Experience writing interface control documents.
Knowledge of design principles.
Ability to troubleshoot and optimize interface functionality.
Practical experience in software development and interface design.
Ability to ensure seamless project delivery.
Professional certifications in control systems or related disciplines.
Familiarity with industry-specific control system software and tools.
Strong project management skills and experience handling multiple projects.

Nice To Haves

Expert-level healthcare services knowledge.

Responsibilities

Gather requirements with state IT resources and DSS members regarding data sources, current data mapping, and interface structures.
Create an Interface Registry for South Dakota Medicaid applications.
Document and write ICDs for Medicaid-related interfaces listed in the registry that lack an associated ICD.
Create a Medicaid-related Interface Management Plan.
Create Medicaid-related data models and a data warehouse structure if none exists.
Create a Medicaid data catalog and data lineage.
Develop a Medicaid-related Data Governance and Management Plan in consultation with DSS and other State resources.
Work with SD State Medicaid staff to understand system interactions, data flows, reporting, storage, organization, and security.
Recommend improvements to data governance, management, ICDs, data control documents, data cataloging, interface documentation, and related tools.
Identify risks in current data management and interface structures, including data inconsistencies, integration challenges, and security or compliance issues.
Recommend ways to streamline data management, data sharing, governance, and system integration.
Prepare monthly status reports covering work accomplished and timelines.
Perform other related duties as assigned.