Senior Snowflake Data Developer

Position Overview

We are seeking an
experienced Snowflake Developer with strong hands-on expertise to
design, implement, and optimize data solutions on the Snowflake Data Cloud
platform. The ideal candidate will demonstrate deep proficiency in SnowSQL,
performance optimization, and advanced data engineering using SQL and Python.

**Core Technical
Requirements**

SnowSQL & Advance
SQL Expertise

•
Expert-level knowledge of SQL and SnowSQL for complex query development and
optimization

•
Proficiency in DDL and DML operations, advanced SQL constructs (window
functions, CTEs, subqueries, joins)

•
Expertise handling semi-structured data (JSON, AVRO, Parquet, XML) using
VARIANT column type and LATERAL FLATTEN

•
Experience with stored procedures, transaction management, and data
transformations

Performance
Optimization & Query Tuning

•
Deep understanding of Snowflake query optimization strategies and best
practices

•
Expertise in warehouse sizing, clustering keys, and micro-partition
optimization

•
Proficiency with Snowflake's caching mechanisms and partition pruning
techniques

•
Experience with filter pushdown optimization and predicate optimization
techniques

•
Ability to analyze query execution plans using EXPLAIN and Query Profile
features

•
Experience with Query Acceleration Service (QAS), Search Optimization Service,
materialized views, and dynamic tables

•
Proven track record identifying and resolving query bottlenecks, spilling
issues, and warehouse queuing problems

Python Development
& Integration

•
Strong Python programming for data engineering, automation, and ETL/ELT
workflows

•
Proficiency in Snowpark for Python to build scalable data processing
applications

•
Experience with Snowflake Python APIs, Snowflake Connector for Python, and
pandas on Snowflake

•
Ability to develop Python UDFs and stored procedures

**Key
Responsibilities **

•
Design, develop, and maintain robust data solutions using Snowflake platform

•
Write and optimize complex SQL queries for high performance and cost efficiency

•
Implement performance tuning strategies for optimal query execution and
warehouse utilization

•
Develop Python-based automation scripts and data processing workflows

•
Create and maintain data models supporting business intelligence and analytics

•
Monitor and troubleshoot data pipeline issues and performance bottlenecks

•
Collaborate with cross-functional teams to translate business requirements into
technical solutions

•
Document technical processes, data flows, and architectural decisions

•
Stay current with Snowflake features and implement industry best practices

•
Participate in code reviews and mentor junior developers