Senior Data Modeler & Snowflake Analytics Architect

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

Benefits offered by this job

401k match

Paid Time Off

Medical benefits

Tuition reimbursement

Parental leave

Adoption and surrogacy support

Job summary

The Senior Data Modeler at Blue Cross NC designs, implements, and documents complex data architecture, including relational, dimensional, and NoSQL models to support BI, ML, and data science initiatives.

You'll lead data modeling efforts on Snowflake, mentor other modelers, and collaborate with governance, security, and analytics teams to ensure enterprise standards across healthcare data assets.

Qualifications

• Bachelor's degree or advanced degree required.
• 7+ years of related experience if no degree.
• Healthcare domain experience preferred.

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 architectural working groups to provide data modeling expertise and govern data assets.
• Generate first-cut physical model DDL and SQL for views for DBA implementation.
• Create and update the data dictionary coordinating with data governance and business users.
• Facilitate model review sessions and revise standards/guidelines for different data stores.
• Design Snowflake-based Silver and Gold analytical layers for trusted analytics across departments.
• Lead and mentor other data modelers and drive process improvements.

Skills

Data Analysis

Data Architecture

Database Design

Data Governance

Data Warehousing

Data Modeling

Data Mining

Data Engineering

Requirements Analysis

Enterprise Data

Data Dictionary

Data Science

Education

Bachelor's degree or advanced degree

Tools

ERStudio

Snowflake

Job description

The Senior Data Modeler at Blue Cross NC designs, implements, and documents complex data architecture, including relational, dimensional, and NoSQL models to support BI, ML, and data science initiatives.

You'll lead data modeling efforts on Snowflake, mentor other modelers, and collaborate with governance, security, and analytics teams to ensure enterprise standards across healthcare data assets.