Snowflake Analytics Engineer

Expert in Snowflake data platform — data warehousing, Snowpark, data sharing, cost optimization, performance tuning, and modern ELT patterns with dbt.

Platinum

v1.0.00 activationsData & AnalyticsTechnologyadvanced

SupaScore

85.35

Research Quality (15%)

8.4

Prompt Engineering (25%)

8.6

Practical Utility (15%)

8.7

Completeness (10%)

8.3

User Satisfaction (20%)

8.5

Decision Usefulness (15%)

8.6

Best for

▸Design and implement dimensional data models optimized for Snowflake's micro-partitioning architecture
▸Build dbt transformation pipelines with incremental models and SCD Type 2 snapshots
▸Optimize Snowflake warehouse costs through auto-suspend, clustering keys, and credit monitoring
▸Implement Secure Data Sharing between Snowflake accounts for external data products
▸Debug query performance issues using Query Profile and eliminate data spillage

What you'll get

●Complete dbt project structure with staging, intermediate, and mart models following analytics engineering best practices
●Detailed warehouse sizing recommendations with auto-suspend settings and resource monitor configurations
●Query optimization analysis identifying specific performance bottlenecks with clustering key and partition pruning solutions

Not designed for ↓

×Building real-time streaming pipelines (Snowflake is batch-oriented with near real-time capabilities)
×Machine learning model training (use Snowpark ML or external platforms instead)
×Traditional ETL tool configuration like Informatica or Talend
×NoSQL or graph database design patterns

Expects

Clear requirements for data sources, transformation logic, performance targets, and cost constraints within Snowflake's cloud data platform.

Returns

Optimized Snowflake data architecture with dbt models, performance tuning recommendations, and cost management strategies specific to your use case.

Evidence Policy

Standard: no explicit evidence policy.

snowflakedata-warehousedbtsnowparkanalytics-engineeringsqldata-sharing

Research Foundation: 6 sources (3 official docs, 1 paper, 1 books, 1 web)

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/15/2026

Initial version

Prerequisites

Use these skills first for best results.

SQL Query OptimizerPlatinum

Works well with

Data Warehouse ArchitectGold dbt Analytics EngineerGold ETL Pipeline DesignerGold SQL Performance Tuning ExpertPlatinum

Need more depth?

Specialist skills that go deeper in areas this skill touches.

Snowflake Cost Optimization AdvisorGold Snowflake Data Modeling ExpertGold

Common Workflows

Modern Data Stack Implementation

End-to-end analytics platform build from architecture through visualization

Data Warehouse Architect→snowflake-analytics-engineer→dbt Analytics Engineer→dashboard-design-strategist

Activate this skill in Claude Code

Start Free to Activate This Skill