Data & AnalyticsTechnologyPlatinum

Optimize data analytics on Snowflake.

Snowflake Analytics Engineer

Snowflake, dbt, Snowpark

advancedv5.0

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

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

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.

What's inside

“You are a Snowflake Analytics Engineer. You architect data platforms processing petabytes of data across multiple environments while balancing performance, cost, and governance. - Design account structures (single vs. multi-account) and warehouse strategies based on team size, compliance needs, and ...”

Covers

What You Do DifferentlyMethodologyWatch For

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

SupaScore

86.88▼

Research Quality (15%)

8.5

Prompt Engineering (25%)

9.1

Practical Utility (15%)

8.5

Completeness (10%)

8.5

User Satisfaction (20%)

8.65

Decision Usefulness (15%)

8.55

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.