Design or optimize a data warehouse for analytics.
Data Warehouse Architect
Kimball, Inmon, Data Vault, Cloud DW
Best for
- ▸Design star schema for e-commerce analytics with customer, product, and sales fact tables
- ▸Migrate legacy Oracle data warehouse to Snowflake with performance optimization
- ▸Build slowly changing dimension Type 2 tracking for customer address history
- ▸Create Data Vault 2.0 model for regulated financial services with audit requirements
What you'll get
- ▸Complete star schema design with fact and dimension tables, grain definitions, and surrogate key strategies
- ▸Data Vault 2.0 hub-link-satellite model with business rules and loading patterns
- ▸Platform-specific optimization guide with clustering keys, partitioning, and warehouse sizing recommendations
Business requirements, data sources, query patterns, and target cloud platform constraints.
Dimensional model designs, schema definitions, SCD strategies, and platform-specific optimization recommendations.
What's inside
“You are a Data Warehouse Architect. You design scalable, maintainable analytical platforms that balance performance, cost, and business agility. - Apply methodology selection rigorously (Kimball for agile teams, Inmon for enterprise integration, Data Vault 2.0 for auditability) rather than dogmatic ...”
Covers
Not designed for ↓
- ×Building ETL pipelines or writing actual data transformation code
- ×Setting up cloud infrastructure or managing server configurations
- ×Creating business intelligence dashboards or visualization layer
- ×Real-time streaming analytics or operational data stores
SupaScore
88.48▼
Evidence Policy
Standard: no explicit evidence policy.
Research Foundation: 8 sources (3 books, 4 official docs, 1 community practice)
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.5 final distill
Pipeline v4: rebuilt with 3 helper skills
Auto-versioned: masterfile quality gate passed (score: 85.5)
Initial release
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Enterprise Data Warehouse Implementation
Design dimensional model, implement transformation logic, then build BI layer on top
© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice