> Markdown version of [/jobs/ext/4462843-data-modeler-erwin-er-studio](https://www.wearedevelopers.com/jobs/ext/4462843-data-modeler-erwin-er-studio). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Modeler (ERwin / ER Studio) - **Company:** Arcadia Inc. - **Location:** Sioux Falls, SD, United States (Remote available) - **Experience:** Expert - **Salary:** $107,000.0 - $160,000.0 - **Contract:** Temporary contract - **Skills:** Artificial Intelligence, Cloud Computing, Databases, Data Governance, Data Sharing, Data Warehousing, Database Design, Metadata Repositories, Medicaid Management Information Systems (MMIS), NoSQL, Standard Sql, Data Storage Technologies, Data Lineage, Data Management, Physical Data Models, Data Inconsistencies - **Published:** October 10, 2026 - **Apply:** https://www.builtincolorado.com/auth/login?destination=/job/data-modeler-erwin-er-studio/11603031 ## About the Role * 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. ## Description Be an Early Applicant Remote Hiring Remotely in USA Senior level Remote Hiring Remotely in USA Senior level Design and maintain conceptual, logical, and physical Medicaid data models using ERwin or ER/Studio. Develop a scalable Medicaid data warehouse structure, support data catalog and lineage creation, map system interactions, and identify data quality, integration, governance, security, and database design improvements. Collaborate with state Medicaid and IT staff, document data movement and metadata, contribute to status reporting, and work onsite in Sioux Falls for the engagement. The summary above was generated by AI, 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., * 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., Lead Medicaid policy analysis for a state program by translating eligibility, benefits, claims, and provider rules into analytic logic. Build production-grade data marts, registries, dashboards, reports, and cohort definitions using SQL and Python. Serve as the senior analytical partner to Medicaid leadership, contractors, vendors, and data teams; resolve data-quality issues, establish methodologies, prioritize work, and mentor analysts. Top Skills: Amazon AthenaAmazon QuicksightAmazon RedshiftAWSClaude CodeConfluenceCpt/HcpcsCursorDbtFoundryGitIcd-10JIRAExcelNppesPower BIPythonSQLTableau What you need to know about the Colorado Tech Scene With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation. Key Facts About Colorado Tech * Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey) * Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3 * Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech * Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook) * Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures * Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute