Senior Snowflake Data Developer

Job description:

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:

• 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

Skills

Python, SQL, SnowSQL, Snowflake, Snowpark