Data Modeler – Healthcare Payer (Erwin)

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

Benefits offered by this job

Health Insurance

HSA Contributions

FSA

Disability Insurance

Life Insurance

EAP

Career Growth

Team Events

PTO & Holidays

Job summary

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.

Responsibilities

• 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.

Skills

Data modeling

SQL

Tools

Erwin Data Modeler

Snowflake

Databricks

Job description

Job Information

Location: Remote, open to the US
Compensation: Up to $80/hr W2 or up to $100/hr C2C. Compensation will be determined based on relevant experience, skills, and overall qualifications.
Requirements: Must be authorized to work legally in the US without sponsorship, now or in the future.

AboutUs

Concord isn't your typical consulting firm; we're an execution company. We help organizations move technology and AI initiatives from concept to measurable capability, working alongside our clients from the initial definition of success through full implementation and adoption.
Our team brings expertise across artificial intelligence and data, digital experience, and platform engineering, enabling the organizations we serve to build lasting internal capability. We operate as a global team, with a presence across the United States, Latin America, Europe, and India, giving our clients access to specialized talent and continuous coverage across time zones.

AboutTheRole

We're looking for a Data Modeler to design and maintain data models for a health insurance (payer) client. You'll build transactional and dimensional models across core payer domains such as claims, premiums, and membership. You'll work with data engineers, analysts, and business stakeholders to turn business requirements into well-structured models on a modern cloud data platform. This is a hands-on role, and you'll own model design from the conceptual stage through to physical implementation.

WhatYouWillBeDoing

• 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 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

WhatWeAreLookingFor

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

WhatWeOffer (W2 Benefits)

• Health, Dental, and Vision Insurance: Comprehensive coverage to support your well-being.
• Employer Contributions to Health Savings Accounts (HSA): Helping you save for medical expenses.
• Flexible Spending Accounts (FSA): Options for healthcare and dependent care expenses, plus a $200 Lifestyle Spending Account (LSA).
• Disability Insurance: Short- and long-term coverage, fully paid by the employer.
• Life and AD&D Insurance: Employer-provided coverage, with options for additional voluntary coverage.
• Employee Assistance Program (EAP): Access to personal and professional support resources.
• Career Growth Opportunities: Pathways for advancement and skill development.
• Team Engagement Activities: Regular team-building events and company-sponsored activities to foster collaboration and connection.
• Paid Time Off and Holidays (Only W2 Salary*): PTO policy and paid company holidays.

Concord is an execution partner helping organizations drive digital transformation, modernization, and scalable technology solutions. We deliver results that solve real business challenges. We operate globally and are growing fast, shaping the future of technology. Join a team trusted by top companies to drive strategic growth and operational excellence!