Senior Data Modeler & Snowflake Data Architect

Blue Cross and Blue Shield of North Carolina; Louisville (KY); Hybrid; USD 108,000 - 173,000; Full time

Job summary

Blue Cross NC is seeking a Senior Data Modeler to design complex data architecture across relational, dimensional, and NoSQL stores. You will model data, govern data stores, and support BI, ML, and data science initiatives.

You will lead data modeling for Snowflake, mentor others, and collaborate in enterprise data warehousing within the healthcare domain, including HL7 FHIR mappings and ERStudio tooling. This hybrid role emphasizes collaboration and scalable data practices for enterprise needs.

Qualifications

• 5+ years of experience in related field.
• In lieu of degree, 7+ years of experience in related field.
• Experience leading other data modelers in a full life-cycle enterprise data warehousing effort.
• Healthcare domain experience preferred, especially EHR/Clinical domain.
• Exposure working on Snowflake platform.
• Experience and exposure with HL7 FHIR profiles and resources to map enterprise data or source data to FHIR resources.
• Working experience with ERStudio or similar data modeling tool.
• Extensive experience of ER and Dimensional modeling concepts.

Responsibilities

• Create fully attributed conceptual, logical, and physical models using ER and Dimensional modeling techniques.
• Analyze data to verify business requirements and design the data models.
• Participate in project-specific architectural groups to advise on data management and govern data assets.
• Generate first-cut physical model DDL and SQL for views for DBAs.
• Document data dictionaries in collaboration with data governance and business users.
• Facilitate model review sessions and establish data modeling standards.
• Design Snowflake Silver and Gold analytical layers for analytics across departments.
• Mentor other modelers and drive process improvements in data modeling.

Skills

Data modeling

Data architecture

Snowflake

HL7 FHIR

ERStudio

Healthcare domain

Education

Bachelor's degree or advanced degree

Tools

Snowflake

ERStudio

SQL

Job description

Blue Cross NC is seeking a Senior Data Modeler to design complex data architecture across relational, dimensional, and NoSQL stores. You will model data, govern data stores, and support BI, ML, and data science initiatives.

You will lead data modeling for Snowflake, mentor others, and collaborate in enterprise data warehousing within the healthcare domain, including HL7 FHIR mappings and ERStudio tooling. This hybrid role emphasizes collaboration and scalable data practices for enterprise needs.