Senior Snowflake Developer with Airflow, Data Warehouse Platform

Technology stack

Snowflake, Snowflake SQL, Snowflake databases, schemas, tables, views, materialized views, Snowflake stored procedures, Snowflake UDFs using Python and SQL, Airflow, Python, Azure SQL Database, MS SQL DB, T SQL, ETL, ELT, layered architecture, Medallion architecture, dimensional modeling

Project overview

This project is centered on developing a data lakehouse with Snowflake and Azure SQL, including design, pipeline development, and query optimization.

Position overview

We are looking for a Senior Snowflake Developer with strong experience in Snowflake platform engineering, Airflow, Python, and data warehouse development. You will contribute to building scalable data pipelines, designing warehouse structures, and improving data processing performance.

Responsibilities

Develop Snowflake data platform solutions

Build and optimize Snowflake databases, schemas, tables, views, and materialized views

Create Snowflake stored procedures and UDFs using Python and SQL

Develop and maintain ETL and ELT pipelines in Snowflake

Work with Airflow to orchestrate data workflows

Design and build data warehouse solutions

Apply layered architecture and Medallion architecture principles

Implement dimensional modeling for analytical data structures

Create tables, views, stored procedures, functions, indexes, and partitions in Azure SQL Database and MS SQL DB

Optimize database performance and tune complex queries

Use analytical and window functions to support data processing

Collaborate in English across data project activities

Requirements

7+ years of overall IT experience

5+ years of experience in data projects

Experience with Snowflake data platform engineering

Experience with Snowflake SQL

Experience with Snowflake databases, schemas, tables, views, and materialized views

Experience with Snowflake stored procedures and UDFs using Python and SQL

Experience with Airflow

Experience with Python

Experience with Azure SQL Database, MS SQL DB, and T SQL

Experience creating tables, views, stored procedures, functions, indexes, and partitions

Experience with performance tuning and complex queries

Experience using analytical and window functions

Experience building data warehouses

Experience with layered architecture and Medallion architecture

Experience with dimensional modeling

Good English

Nice to have

Experience with DBT

Experience with Snowpark

Experience with Snowflake CLI

Experience with Master Data Management design and integration

Experience with data quality testing, validation, and reconciliation

Experience writing technical documentation

Investment banking or asset management domain knowledge

Experience with Claude AI in SDLC