Data Modeler – Healthcare Payer (Erwin)

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.
 

• 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

• 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