Remote Data Modeler — Healthcare Payer (Erwin/Snowflake)

Concord USA; United States; Remote; USD 83,000 - 138,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Employer contributions to HSA

FSA

Disability insurance

Life and AD&D

EAP

Career growth opportunities

Team engagement activities

PTO and holidays

Job summary

Concord is seeking a seasoned Data Modeler to design and maintain scalable data models for a health insurance payer client on a modern cloud data platform. You will deliver conceptual, logical, and physical models, including OLTP and star schemas, while coordinating with data engineers and business stakeholders to ensure alignment with requirements.

You will own modeling standards, create data dictionaries, and drive improvements for performance and scalability across claims, premiums, and

Qualifications

• 7+ years of data modeling experience across 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 is a plus.
• Strong SQL skills and ability to work directly with business stakeholders to define requirements.

Responsibilities

• Design conceptual, logical, and physical data models for payer data domains.
• Build transactional (OLTP/3NF) and dimensional (star/snowflake) models for operational and analytical use cases.
• Create, manage, and version data models in Erwin Data Modeler, including forward and reverse engineering.
• Translate business requirements 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.]
• CoT_job_summary_short":"COMPANY NAME: Concord\nKEY POINTS: Data modeling, Erwin DMR, Snowflake/Databricks, payer domain"
• job_summary_short":"<p>Concord is seeking a seasoned Data Modeler to design and maintain scalable data models for a health insurance payer client on a modern cloud data platform. You will deliver conceptual, logical, and physical models, including OLTP and star schemas, while coordinating with data engineers and business stakeholders to ensure alignment with requirements.</p><p>You will own modeling standards, create data dictionaries, and drive improvements for performance and scalability across claims, premiums, and membership domains. This hands-on role requires Deep knowledge of Erwin Data Modeler and strong SQL.</p>
• contract_type reliably_pic_translator
• location_type
• remote_scope
• perks

Skills

Data modeling

SQL

Stakeholder collaboration

Normalization

Dimensional modeling

Payer domain knowledge

Model governance

Tools

Erwin Data Modeler

Snowflake

Databricks

Job description

Concord is seeking a seasoned Data Modeler to design and maintain scalable data models for a health insurance payer client on a modern cloud data platform. You will deliver conceptual, logical, and physical models, including OLTP and star schemas, while coordinating with data engineers and business stakeholders to ensure alignment with requirements.

You will own modeling standards, create data dictionaries, and drive improvements for performance and scalability across claims, premiums, and