Remote Health Payer Data Modeler (Snowflake/Databricks)

Concord USA; Saint Paul (MN); Remote; USD 100,000 - 150,000; Full time

Benefits offered by this job

Health/Dental/Vision Insurance

HSA contributions

FSA + $200 LSA

Disability Insurance

Life and AD&D Insurance

EAP resources

Career growth opportunities

PTO & holidays

Job summary

Concord USA remote, US‑facing data modeling role focusing on health payer data domains such as claims, premiums, and membership. You design, implement, and maintain transactional and dimensional models on a modern cloud data platform.

You will translate business requirements into robust models, collaborate with data engineers, analysts, and stakeholders, and own the model design from concept through physical implementation.

Qualifications

• 7+ years of data modeling experience in transactional and dimensional domains.
• Hands‑on experience with Erwin Data Modeler is a must.
• Exposure to Snowflake and/or Databricks.
• Experience modeling data for a health insurance payer organization.
• Strong SQL skills and ability to work with business stakeholders to define requirements.

Responsibilities

• Design conceptual, logical, and physical data models for payer domains (claims, premiums, membership).
• Create, manage, and version data models in Erwin Data Modeler, including forward/reverse engineering.
• Translate business requirements into model designs and data definitions.
• Partner with data engineering to implement models in Snowflake and/or Databricks.
• Maintain data dictionaries, mapping documents, and modeling standards.
• Review existing models and recommend improvements for performance and scalability.

Skills

Data modeling

Erwin Data Modeler

SQL

Snowflake

Databricks

Healthcare payer domain

Stakeholder collaboration

Tools

Erwin Data Modeler

Snowflake

Databricks

Job description

Concord USA remote, US‑facing data modeling role focusing on health payer data domains such as claims, premiums, and membership. You design, implement, and maintain transactional and dimensional models on a modern cloud data platform.

You will translate business requirements into robust models, collaborate with data engineers, analysts, and stakeholders, and own the model design from concept through physical implementation.