Remote Data Modeler: Payer Data on Snowflake/Databricks

Concord USA; Minneota (MN); Remote; USD 110,000 - 160,000; Full time

Benefits offered by this job

Health Insurance

HSA Contributions

FSA

LSA (Lifestyle Spending Account)

Disability Insurance

Life & AD&D Insurance

EAP

Team Engagement Activities

PTO & Holidays

Job summary

Concord is actively seeking a Data Modeler to design and maintain data models for a health insurance payer client. You will build transactional and dimensional models for claims, premiums, and membership on a modern cloud platform, and partner with engineers and business stakeholders to translate requirements into robust models.

The role is hands-on from concept to physical implementation, with emphasis on model design and documentation across diverse payer domains.

Qualifications

• 7+ years of data modeling experience across both transactional and dimensional modeling.

Responsibilities

• Design conceptual, logical, and physical data models for payer data domains, including claims, premiums, and membership.
• 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.

Skills

Data modeling

SQL

Stakeholder collaboration

Cloud data platform

Tools

Erwin Data Modeler

Snowflake

Databricks

Job description

Concord is actively seeking a Data Modeler to design and maintain data models for a health insurance payer client. You will build transactional and dimensional models for claims, premiums, and membership on a modern cloud platform, and partner with engineers and business stakeholders to translate requirements into robust models.

The role is hands-on from concept to physical implementation, with emphasis on model design and documentation across diverse payer domains.