Lead Data Engineer - Snowflake

Location:

6 Months with possibility of extension Duration:
Portland, OR (Hybrid 3 days) Role Summary

The Senior Snowflake Optimization Engineer will lead the assessment, re‑architecture, and optimization of Snowflake data platform.

This role will act as the technical lead and primary onsite interface for Snowflake optimization initiatives, working closely with stakeholders, data engineering teams, and Matillion pipelines.

• Assess current Snowflake warehouse usage, sizing, auto‑scaling, and auto‑suspend configurations.
• Identify cost drivers across Matillion jobs, ad‑hoc analytics, and background workloads.
• Optimize warehouse strategies (multi‑cluster usage, workload isolation, resource monitors).
• Analyze query history and execution plans to reduce compute inefficiencies.
• Review existing Snowflake schemas, tables, tasks, and pipelines for architectural improvements.
• Recommend and implement Snowflake‑native optimizations (dynamic tables, tasks, result caching where appropriate).
• Evaluate opportunities for hybrid compute (external tables, Iceberg, Spark/EMR) where cost‑effective.
• Advise on data lifecycle, retention, and archival strategies to reduce storage footprint.

• Improve pipeline execution efficiency and runtime SLAs.
• Define reusable optimization patterns and templates.

• Help establish cost governance, monitoring, and guardrails.
• Provide recommendations to ensure savings are sustainable post‑engagement.

• Act as the onsite technical lead, coordinating with architects, developers, and business users.
• Lead technical workshops, optimization reviews, and recommendations walkthroughs.
  
  Provide documentation, implementation guidelines, and knowledge transfer to teams.
• Support stabilization and post‑implementation tuning.

• Strong hands‑on experience with Snowflake architecture, performance tuning, and cost optimization
• Deep understanding of:
• Snowflake warehouses, clustering, caching, tasks, dynamic tables
• Query profiling and execution plans
• Experience with Matillion ELT on Snowflake
• Solid knowledge of AWS (S3, security, cost considerations)
• SQL performance tuning and data modeling experience

• Experience with Iceberg / external tables / Spark or EMR
• Exposure to Snowflake Cortex or advanced Snowflake features
• CI/CD for data platforms (Git Hub/Git Lab/Jenkins)
• Data governance and cost management frameworks

• 8–12+ years in data engineering / cloud data platforms
• 3–5+ years of focused Snowflake optimization experience
• Prior experience in onsite consulting or lead roles preferred