Senior Data Modeler: Snowflake DW & Data Architecture

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

Benefits offered by this job

401k match

Tuition reimbursement

Parental leave

Health benefits

Paid time off

Job summary

Blue Cross NC is seeking a Senior Data Modeler to design and implement complex data models across relational, dimensional, and NoSQL architectures. You will drive data modeling standards, mentor colleagues, and collaborate with governance teams to ensure trusted analytics across Snowflake environments.

The role emphasizes leading enterprise data warehousing initiatives in the healthcare space, with a Hybrid-Flex work model and a strong focus on data quality, security, and scalable architectures.

Qualifications

• 5+ years of experience in data modeling/architecture.
• Experience leading other data modelers in a full life-cycle enterprise data warehousing effort.
• Healthcare domain experience preferred (EHR/Clinical).
• Exposure to HL7 FHIR mappings to data assets.
• Experience with Snowflake platform.

Responsibilities

• Create conceptual, logical, and physical data models using ER and dimensional modeling.
• Analyze data to verify business requirements and design data models.
• Contribute to data architecture and governance, document data flows and controls.
• Generate DDL and SQL for views for DBA implementation.
• Maintain data dictionary with data governance coordination.
• Establish modeling standards and facilitate reviews.
• Design Snowflake Silver and Gold analytical layers for trusted analytics.
• Mentor and review other modelers to ensure enterprise standards.

Skills

Data Modeling

Data Architecture

Data Governance

Requirements Analysis

Dimensional Modeling

Snowflake

ER Studio

SQL & DDL

Data Dictionary

Data Warehousing

Education

Bachelor's degree or advanced degree

Tools

Snowflake

ERStudio

Job description

Blue Cross NC is seeking a Senior Data Modeler to design and implement complex data models across relational, dimensional, and NoSQL architectures. You will drive data modeling standards, mentor colleagues, and collaborate with governance teams to ensure trusted analytics across Snowflake environments.

The role emphasizes leading enterprise data warehousing initiatives in the healthcare space, with a Hybrid-Flex work model and a strong focus on data quality, security, and scalable architectures.