Remote Healthcare Payer Data Modeler - Erwin/Snowflake

Concord USA; Minnesota; À distance; USD 83 000 - 138 000; Plein temps

Avantages offerts par ce poste

Health Insurance

HSA Contributions

FSA

Disability Insurance

Life Insurance

EAP

Career Growth

Team Events

PTO & Holidays

Résumé du poste

Concord USA is seeking a Data Modeler to design and maintain data models for a health insurance payer client. You will build transactional and dimensional models across claims, premiums, and membership, and work with data engineers, analysts, and business stakeholders to translate requirements into well-structured models on a modern cloud data platform.

This hands-on role places you in ownership from concept to physical implementation, with responsibilities including model design, documentation,

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.
• Strong SQL skills and ability to work directly with business stakeholders to define requirements.

Responsabilités

• Design conceptual, logical, and physical data models for payer data domains.
• Build OLTP/3NF and dimensional 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.

Connaissances

Data modeling

SQL

Outils

Erwin Data Modeler

Snowflake

Databricks

Description du poste

Concord USA is seeking a Data Modeler to design and maintain data models for a health insurance payer client. You will build transactional and dimensional models across claims, premiums, and membership, and work with data engineers, analysts, and business stakeholders to translate requirements into well-structured models on a modern cloud data platform.

This hands-on role places you in ownership from concept to physical implementation, with responsibilities including model design, documentation,