Remote Medicaid Data Modeler (ERwin/ER Studio)

Dhaka Technologies Limited Company; Sioux Falls (SD); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Dhaka Technologies Limited Company is hiring a Data Modeler to support a Medicaid modernization initiative. The role requires designing conceptual, logical, and physical data models, defining a data warehouse structure, and contributing to data catalogs and data lineage.

The position collaborates with State Medicaid staff and IT resources onsite in Sioux Falls. Remote work is noted in the posting, with an approximately 8-month contract.

Qualifications

• Hands-on data modeling across conceptual, logical and physical layers.
• Experience with Medicaid data or MMIS is strongly preferred.
• Proficiency in SQL and NoSQL databases.
• Experience with data catalogs and data lineage.
• Knowledge of data governance frameworks.
• Understanding of BI concepts.
• Experience with ERwin or ER/Studio.
• Onsite work in Sioux Falls, SD for the engagement.

Responsibilities

• Gather requirements with State IT resources and agency staff to understand data sources, current data mapping, and existing interface structures.
• Develop and maintain conceptual, logical, and physical data models for Medicaid data using ERwin or ER/Studio.
• Design a Medicaid data warehouse structure where none exists, with attention to scalability, performance, and data quality.
• Support the creation of the Medicaid data catalog and data lineage by providing entity definitions, attributes, relationships, and metadata.
• Map system-to-system interactions and the movement of data between Medicaid systems and processes, including reporting to internal and external partners.
• Recommend improvements to database design, data management, and data sharing, and identify data inconsistencies and integration challenges.
• Identify risks related to current data management and data storage, organization, and security.
• Contribute to the monthly status report on work completed and timelines.
• Perform other related duties as assigned.

Skills

Data modelling

SQL

NoSQL

Data catalogs

Data lineage

Data governance

Healthcare knowledge

BI concepts

Communication

Medicaid knowledge

Tools

ERwin

ER/Studio

Microsoft Purview

Job description

Dhaka Technologies Limited Company is hiring a Data Modeler to support a Medicaid modernization initiative. The role requires designing conceptual, logical, and physical data models, defining a data warehouse structure, and contributing to data catalogs and data lineage.

The position collaborates with State Medicaid staff and IT resources onsite in Sioux Falls. Remote work is noted in the posting, with an approximately 8-month contract.