Overview
On Site
Hybrid
USD 60.00 per hour
Full Time
Skills
SQL
NoSQL
Database
ERwin
ER/Studio
Database Administration
Physical Data Model
Business Intelligence
Analytical Skill
Communication
UI
User Experience
Writing
Software Development
Interface Design
Project Delivery
Industry-specific
Project Management
Requirements Elicitation
Data Mapping
Mainframe
Interfaces Management
Data Modeling
Data Warehouse
Data Flow
Reporting
Data Storage
Management
ICD
Documentation
Data Governance
System Integration
Regulatory Compliance
Data Management
Medicaid
Interfaces
Status Reports
Job Details
Date Posted: 08/26/2025
Hiring Organization: Rose International
Position Number: 487640
Industry: Government
Job Title: Data Modeler
Job Location: Sioux Falls, SD, USA, 57101
Work Model: Hybrid
Work Model Details: Onsite at least one day per month.
Shift: 8:00 AM - 5:00 PM
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 7
Min Hourly Rate($): 60.00
Max Hourly Rate($): 65.00
Must Have Skills/Attributes: Data Governance, Data Modeling, ERWIN, SQL
Experience Desired: Proficiency in relational SQL and NoSQL database technologies. (5 yrs)
**C2C is not available**
Job Description
***Only qualified Data Modeler candidates located near the Sioux Falls, SD area to be considered due to the position requiring an onsite presence***
Required Experience & Skills:
Proficiency in relational SQL and NoSQL database technologies
Experience working with data modelling tools such as ERwin or ER/Studio
A deep understanding of database management and design best practices on an enterprise level
Experience with and examples of conceptual, logical, and physical data modeling, data catalogs, and data lineage
Knowledge of data governance frameworks and best practices, and experience in 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
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.
Responsibilities:
Requirements gathering phase working with Client IT resources and other members of Client 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 Client 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 Client and other resources
Work alongside Client Medicaid staff to understand system to system interactions and data flow and map movement of data between different parts of 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 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
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Hiring Organization: Rose International
Position Number: 487640
Industry: Government
Job Title: Data Modeler
Job Location: Sioux Falls, SD, USA, 57101
Work Model: Hybrid
Work Model Details: Onsite at least one day per month.
Shift: 8:00 AM - 5:00 PM
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 7
Min Hourly Rate($): 60.00
Max Hourly Rate($): 65.00
Must Have Skills/Attributes: Data Governance, Data Modeling, ERWIN, SQL
Experience Desired: Proficiency in relational SQL and NoSQL database technologies. (5 yrs)
**C2C is not available**
Job Description
***Only qualified Data Modeler candidates located near the Sioux Falls, SD area to be considered due to the position requiring an onsite presence***
Required Experience & Skills:
Proficiency in relational SQL and NoSQL database technologies
Experience working with data modelling tools such as ERwin or ER/Studio
A deep understanding of database management and design best practices on an enterprise level
Experience with and examples of conceptual, logical, and physical data modeling, data catalogs, and data lineage
Knowledge of data governance frameworks and best practices, and experience in 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
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.
Responsibilities:
Requirements gathering phase working with Client IT resources and other members of Client 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 Client 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 Client and other resources
Work alongside Client Medicaid staff to understand system to system interactions and data flow and map movement of data between different parts of 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 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
- **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client's business needs and requirements.**
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.