> Markdown version of [/jobs/ext/3821810-data-modeler-healthcare-payer-erwin](https://www.wearedevelopers.com/jobs/ext/3821810-data-modeler-healthcare-payer-erwin). 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 - Healthcare Payer (Erwin)

- **Company:** Concord USA
- **Location:** Concord, MN, United States (Remote available)
- **Experience:** Expert
- **Salary:** $208,000.0
- **Contract:** Permanent contract
- **Skills:** Third Normal Form, Information Engineering, Database Queries, Dimensional Modeling, Online Transaction Processing, Reverse Engineering, Snowflake, Physical Data Models, Databricks
- **Published:** October 18, 2026
- **Apply:** https://www.careerjet.com/jobad/us8cb6224c04e08198ce6809e2ee01f23f

## About the Role

Compensation: Up to $80/hr W2 or up to $100/hr C2C. Compensation will be determined based on relevant experience, skills, and overall qualifications.
Requirements: Must be authorized to work legally in the US without sponsorship, now or in the future., * 7+ years of data modeling experience across both transactional and dimensional modeling.

 * Hands-on experience with Erwin Data Modeler is a must.
 * Exposure to Snowflake and/or Databricks.
 * Strong understanding of normalization, star and snowflake schemas, slowly changing dimensions, and fact/dimension design
 * Experience modeling data for a health insurance payer organization.
 * Functional knowledge of claims and/or premium data (strong plus).
 * Strong SQL skills and ability to work directly with business stakeholders to define requirements

## Description

We're looking for a Data Modeler to design and maintain data models for a health insurance (payer) client. You'll build transactional and dimensional models across core payer domains such as claims, premiums, and membership. You'll work with data engineers, analysts, and business stakeholders to turn business requirements into well-structured models on a modern cloud data platform. This is a hands-on role, and you'll own model design from the conceptual stage through to physical implementation.
What You Will Be Doing

 * Design conceptual, logical, and physical data models for payer data domains, including claims, premiums, and membership.
 * Build and maintain transactional (OLTP/3NF) and dimensional (star/snowflake schema) models to support operational and analytical use cases.
 * Create, manage, and version data models in Erwin Data Modeler, including forward and reverse engineering.
 * Translate business requirements from claims, finance, and operations stakeholders into model designs and data definitions.
 * Partner with data engineering teams to implement models in Snowflake and/or Databricks.
 * Maintain data dictionaries, mapping documents, and modeling standards.
 * Review existing models and recommend improvements for performance, consistency, and scalability