Data Modeler – Healthcare Payer (Erwin)

Concord USA•Multiple Cities, MN

5d•Remote

About The Position

Concord is seeking a hands-on Data Modeler to design and maintain data models for a healthcare payer client. The role covers core payer domains including claims, premiums, and membership, and involves turning business requirements into well-structured models on a modern cloud data platform. The Data Modeler will own model design from conceptual development through physical implementation, collaborating with data engineers, analysts, and business stakeholders.

Requirements

At least 7 years of data modeling experience across transactional and dimensional modeling.
Hands-on experience with Erwin Data Modeler.
Exposure to Snowflake and/or Databricks.
Strong understanding of normalization, star and snowflake schemas, slowly changing dimensions, and fact/dimension design.
Strong SQL skills.
Ability to work directly with business stakeholders to define requirements.
Must be authorized to work legally in the US without sponsorship, now or in the future.

Nice To Haves

Experience modeling data for a health insurance payer organization.
Functional knowledge of claims and/or premium data.

Responsibilities

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 for operational and analytical use cases.
Create, manage, and version data models in Erwin Data Modeler, including forward and reverse engineering.
Translate 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.

Benefits

Health insurance
Dental insurance
Vision insurance
Employer contributions to health savings accounts (HSA)
Flexible spending accounts (FSA) for healthcare and dependent care expenses
$200 Lifestyle Spending Account (LSA)
Fully paid short- and long-term disability insurance
Employer-provided life and AD&D insurance, with options for additional voluntary coverage
Employee Assistance Program (EAP)
Career growth opportunities and skill development
Team-building events and company-sponsored activities
Paid time off and company holidays (W2 salary only)