Senior Data Modeler - Snowflake & Healthcare DW Lead

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

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

Parental leave

Tuition reimbursement

401k match

Paid time off

Job summary

Blue Cross NC is seeking a Senior Data Modeler to design and implement complex data architecture including relational, dimensional, and NoSQL stores. You will document data models and collaborate across BI, ML, and data science teams.

You will lead modeling efforts on Snowflake, develop Silver and Gold layers, mentor junior modelers, and ensure enterprise standards. This role supports a hybrid-flex work approach.

Qualifications

• Bachelor's degree or advanced degree (where required)
• 5+ years of experience in related field
• In lieu of degree, 7+ years of experience in related field

Responsibilities

• Design conceptual, logical and physical data models using ER and Dimensional modeling techniques.
• Analyze data to verify business requirements and design the data models.
• Participate in architectural working groups to govern data assets and storage across stores, and document data flows.
• Generate first cut physical model DDL and SQL for views for DBA implementation.
• Create, validate and update the data dictionary with governance teams and business users.

Skills

Data modeling

Data architecture

SQL

NoSQL

Data governance

Mentoring

Snowflake

HL7 FHIR

Education

Bachelor's degree

Advanced degree

Tools

Snowflake

ERStudio

SQL

HL7 FHIR

Job description

Blue Cross NC is seeking a Senior Data Modeler to design and implement complex data architecture including relational, dimensional, and NoSQL stores. You will document data models and collaborate across BI, ML, and data science teams.

You will lead modeling efforts on Snowflake, develop Silver and Gold layers, mentor junior modelers, and ensure enterprise standards. This role supports a hybrid-flex work approach.