Data Modeler (ERwin / ER Studio)

Dhaka Technology Limited; United States; On-site; USD 78,000 - 123,000; Full time

Job summary

Dhaka Technologies Limited Company is hiring a Data Modeler to support a Medicaid modernization initiative for a state government agency. The role will design conceptual, logical, and physical data models for Medicaid data, define a data warehouse structure where none exists, and support the Medicaid data catalog and data lineage.

The position requires close collaboration with State Medicaid staff and IT resources.

Qualifications

• Hands-on experience with ERwin or ER/Studio.
• Experience in conceptual, logical, and physical data modeling.
• Proficiency with relational SQL and NoSQL databases.
• Deep understanding of enterprise database management and design best practices.
• Minimum senior level healthcare services knowledge; Medicaid/MMIS experience strongly preferred.
• Knowledge of data governance frameworks and best practices.
• Understanding of business intelligence concepts.
• Preferred: working knowledge of Microsoft Purview.
• Strong analytical, written, and verbal communication skills.
• Ability to work onsite in Sioux Falls, South Dakota for the duration of 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.
• Work alongside State Medicaid staff to 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

ERwin/ER Studio

Data modeling (conceptual/logical/phys

Data catalogs & data lineage

SQL & NoSQL

Enterprise DB design

Medicaid/MMIS knowledge

Data governance

BI concepts

Microsoft Purview

Analytical & communication skills

Onsite work in Sioux Falls SD

Job description

Dhaka Technologies Limited Company | Contract

Work Arrangement: Remote

Employment Type: Contract (approximately 8 months)

Note: Three professional references from previous employment are required with the application. Each reference must include the organization name, reference's name, phone number, and email address . Resumes submitted without three professional references will not be reviewed.

Position Summary

Dhaka Technologies Limited Company is hiring for the role of Data Modeler on behalf of its client, a state government agency, to support a Medicaid modernization initiative. The data modeler will design conceptual, logical, and physical data models for Medicaid data, define a data warehouse structure where none exists, and support the creation of the Medicaid data catalog and data lineage. The role works onsite with State Medicaid staff and State IT resources to understand how data moves between systems and to document it in clear, reusable models.

Key Responsibilities

• Gather requirements with State IT resources and agency staff to understand data sources, current data mapping, and existing interface structures. Mainframe data is accessed only through State IT resources.
  
• 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.
  
• Work alongside State Medicaid staff to 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.
  

Requirements

Required Qualifications

• Hands-on experience with data modeling tools such as ERwin or ER/Studio.
  
• Experience with, and examples of, conceptual, logical, and physical data modeling, data catalogs, and data lineage.
  
• Proficiency with relational SQL and NoSQL database technologies.
  
• Deep understanding of enterprise database management and design best practices.
  
• Minimum senior level healthcare services knowledge, expert level preferred. Medicaid or MMIS experience is strongly preferred.
  
• Knowledge of data governance frameworks and best practices.
  
• Understanding of business intelligence concepts.
  
• Preferred: working knowledge of Microsoft Purview.
  
• Strong analytical, written, and verbal communication skills.
  
• Ability to work onsite in Sioux Falls, South Dakota for the duration of the engagement.