Senior Data Modeler | Snowflake Data Architecture Lead

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

Benefits offered by this job

Medical, dental, vision coverage

401k with company match

PTO and wellness programs

Parental leave & adoption support

Tuition reimbursement

Job summary

Blue Cross and Blue Shield of North Carolina is seeking a Senior Data Modeler to design, implement, and document complex data architecture and modeling solutions that support BI, ML, and data science across the payer industry.

The role involves leading data modeling efforts on Snowflake, mentoring junior modelers, and contributing to data governance and standards. Candidates typically have 5+ years in data modeling and healthcare domain experience.

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

• Data Modeling: Creates fully attributed and documented conceptual, logical and physical models using ER and Dimensional modeling techniques.
• Requirement Analysis: Analyzes data to verify business requirements and design the data models.
• Data Architecture: Participates in project specific architectural working groups to provide expertise in modeling. Provides inputs on the data management of data assets in all data stores and governs the storage of data in different layers of the data stores. Provides architectural inputs on the data consumption layers, access and security requirements. Documents data flows from its origination and acquisition points. Oversee and govern the expansion of existing data architecture.
• Standard Query Language: Generates first cut physical model DDL and SQL for views for implementation by the DBA.
• Documentation: Creates, validates, and updates the data dictionary by coordinating with data governance team and business users.
• Standards & Process: Facilitates model review sessions. Creates, follows, and revises the data modeling standards and guidelines for different data stores.
• Data Modeling on Snowflake platform: Play a key role in designing the Silver and Gold analytical layers in Snowflake to build trusted analytical platform serving various business capabilities for different departments within the payer industry.
• Leading and mentoring - Provide the expert knowledge to other data modelers, reviews work of other modelers to verify it meets enterprise standards and guidelines. Provides inputs on process improvements and maturing the data modeling practice.

Skills

Data Modeling

Data Architecture

Data Governance

Data Warehousing

Data Analysis

Requirements Analysis

Data Mining

Data Dictionary

Data Science

Data Modeling

Data Architecture Development

Education

Bachelor's degree

Advanced degree

Tools

Snowflake

ERStudio

Job description

Blue Cross and Blue Shield of North Carolina is seeking a Senior Data Modeler to design, implement, and document complex data architecture and modeling solutions that support BI, ML, and data science across the payer industry.

The role involves leading data modeling efforts on Snowflake, mentoring junior modelers, and contributing to data governance and standards. Candidates typically have 5+ years in data modeling and healthcare domain experience.