Data & AnalyticsTechnologyPlatinum

Optimizing data models for Snowflake analytics.

Snowflake Data Modeling Expert

Snowflake, Kimball, dbt, Data Vault

expertv5.0

Best for

▸Design star schema fact and dimension tables optimized for Snowflake's micro-partitions and clustering keys
▸Implement Data Vault 2.0 hub-link-satellite models with dbt for regulated industries requiring full audit trails
▸Optimize existing dimensional models by adding proper clustering keys and partition strategies for query performance
▸Build slowly changing dimension Type 2 patterns with effective dating for customer and product analytics

What you'll get

▸Comprehensive star schema design with fact table grain definition, foreign key relationships, clustering key recommendations, and sample DDL optimized for Snowflake's architecture
▸Data Vault 2.0 model with hub, link, and satellite table designs including business keys, hash keys, and load date stamps with dbt implementation patterns
▸Dimension table design with Type 2 SCD implementation showing current flags, effective dates, and surrogate key strategies with Snowflake-specific optimizations

Expects

Business requirements with defined metrics, source system schemas, query patterns, and performance/cost constraints for Snowflake-based analytics.

Returns

Complete dimensional model designs with DDL scripts, clustering strategies, SCD implementations, and dbt model structures optimized for Snowflake.

What's inside

“You are a Snowflake Data Modeling Expert. You design semantically correct, performance-optimized dimensional models for Snowflake's architecture, balancing query speed with cost efficiency and team maintainability. - Trade theoretical purity for practical performance: prefer star schemas over snowfl...”

Covers

What You Do DifferentlyMethodologyWatch For

Not designed for ↓

×General database schema design for transactional OLTP systems
×Data modeling for non-Snowflake platforms like Redshift or BigQuery without platform-specific optimizations
×ETL/ELT pipeline development or data ingestion processes
×Real-time streaming data architecture design

SupaScore

87.83▼

Research Quality (15%)

8.85

Prompt Engineering (25%)

8.7

Practical Utility (15%)

8.9

Completeness (10%)

8.85

User Satisfaction (20%)

8.55

Decision Usefulness (15%)

Evidence Policy

Standard: no explicit evidence policy.

snowflakedata-modelingdimensional-modelingstar-schemadata-vaultkimballdbtclustering-keysslowly-changing-dimensionsdata-warehousemicro-partitionsanalytics-engineering

Research Foundation: 7 sources (4 official docs, 1 books, 1 web, 1 industry frameworks)

This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.

Version History

v5.03/25/2026

v5.5 final distill

v2.03/1/2026

Pipeline v4: rebuilt with 3 helper skills

v1.0.02/16/2026

Initial release

Works well with

Data Warehouse ArchitectPlatinum dbt Analytics EngineerPlatinum Snowflake Analytics EngineerPlatinum SQL Performance Tuning ExpertPlatinum

Need more depth?

Specialist skills that go deeper in areas this skill touches.

Snowflake Cost Optimization AdvisorPlatinum Data Pipeline ArchitectPlatinum SQL Query OptimizerPlatinum

Common Workflows

Snowflake Analytics Platform Build

Complete analytics platform development from dimensional modeling through dbt implementation to cost optimization

snowflake-data-modeling-expert→dbt Analytics Engineer→Snowflake Cost Optimization Advisor