Snowflake Data Modeling Expert

Design dimensional models, data vault architectures, and analytics schemas optimized for Snowflake with Kimball methodology, dbt integration, and platform-native performance tuning.

Gold

v1.0.00 activationsData & AnalyticsTechnologyexpert

SupaScore

83.75

Research Quality (15%)

8.4

Prompt Engineering (25%)

8.5

Practical Utility (15%)

8.4

Completeness (10%)

8.3

User Satisfaction (20%)

8.2

Decision Usefulness (15%)

8.4

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
▸Create analytics-ready one big tables (OBTs) from complex star schemas for specific dashboard use cases

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

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

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.

Evidence Policy

Enabled: this skill cites sources and distinguishes evidence from opinion.

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

v1.0.02/16/2026

Initial release

Works well with

Data Warehouse ArchitectGold dbt Analytics EngineerGold Snowflake Analytics EngineerPlatinum SQL Performance Tuning ExpertPlatinum

Need more depth?

Specialist skills that go deeper in areas this skill touches.

Snowflake Cost Optimization AdvisorGold Data Pipeline ArchitectGold 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

Activate this skill in Claude Code

Start Free to Activate This Skill