Job Description

Job Summary

Design and build Snowflake optimization capabilities within DCO - warehouse sizing,

query performance, clustering, materialized views, storage tiers, and credit consumption.

• Translate Snowflake expertise into product capabilities - detection rules,

recommendation engines, and safe automated actions for production accounts.

• Build POCs to validate optimization ideas, demonstrate customer value, and support

product discovery and pre-sales.

• Partner with backend, AI/ML, and data engineering teams to ship features end-to-end.

Key Responsibilities

Design and build Snowflake optimization capabilities within DCO - warehouse sizing,

query performance, clustering, materialized views, storage tiers, and credit consumption.

• Translate Snowflake expertise into product capabilities - detection rules,

recommendation engines, and safe automated actions for production accounts.

• Build POCs to validate optimization ideas, demonstrate customer value, and support

product discovery and pre-sales.

• Partner with backend, AI/ML, and data engineering teams to ship features end-to-end.

Skill Requirements

engineering experience; hands-on exp in Snowflake in production.

• Snowflake architecture expertise - three-layer, virtual warehouses, micro-partitions,

clustering/pruning, result/metadata/warehouse caching, time travel, fail-safe, and zerocopy cloning.

• Snowflake platform capabilities - Snowpark, Streams, Tasks, Dynamic Tables,

Materialized Views, Search Optimization Service, Query Acceleration Service, Resource

Monitors, Snowflake Optima, Query Insights, external functions, and SQL API.

• Account administration - RBAC, warehouses, Adaptive Compute, Gen2 Warehouses,

multi-cluster policies, auto-suspend/resume, replication, SnowSQL/REST APIs.

• Advanced query tuning - Query Profile analysis, clustering keys, materialized views,

Search Optimization.

• Cost optimization warehouse right-sizing , credit usage analysis, workload-based

optimization, AISQL / Cortex cost governance (tagging, attribution, budget controls).

• Python (Snowpark), JavaScript/Python UDFs and stored procedures.
• Cloud platforms (AWS / Azure / GCP) - IAM, networking, storage integrations

(S3/ADLS/GCS), PrivateLink, cloud-native Snowflake integrations.

• Strong fundamentals in data structures, algorithms, distributed systems, and large-scale

system design

Snowflake Cortex -Cortex AI Functions (AISQL), AI-driven optimization (intelligent

recommendations, anomaly detection), and native Snowflake automation complementing

optimization logic.

• FinOps practices and cost-attribution models for data platforms.
• Observability tools (Prometheus, Grafana, OpenTelemetry, Datadog).
• Experience with Docker, Kubernetes, Terraform, and modern CI/CD pipelines

Other Requirements

BS/MS in Computer Science, Engineering, or related field.

SnowPro Advanced certifications (Architect, Data Engineer, or Administrator).