Senior Snowflake Developer with Airflow, Data Warehouse Platform

Justjoin; United States; Hybrid; USD 160,000 - 230,000; Full time

Benefits offered by this job

Vacation days up to 26 days/year

Health and life insurance

Learning platform access

Flexible work: office/home/hybrid

Mentoring and growth programs

Job summary

Justjoin is seeking a Senior Snowflake Developer to advance our data platform engineering efforts. You will design scalable data pipelines, build robust Snowflake structures, and optimize performance across ETL/ELT processes.

You will work with Airflow, Python, and SQL across Snowflake, Azure SQL, and MS SQL environments, contributing to a modern data lakehouse and dimensional models. Strong English communication is essential in a global team.

Qualifications

• 7+ years of overall IT experience
• 5+ years in data projects
• Experience with Snowflake data platform engineering
• Experience with Snowflake SQL and databases
• Experience with Snowflake stored procedures and UDFs using Python and SQL
• Experience with Airflow
• Experience with Python
• Experience with Azure SQL Database and MS SQL DB
• Experience creating tables, views, stored procedures, functions, indexes, partitions
• Experience with performance tuning and complex queries
• Experience building data warehouses
• Experience with layered architecture and Medallion architecture
• Experience with dimensional modeling
• Good English

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

Skills

Snowflake SQL

Airflow

Python

Azure SQL

MS SQL

T-SQL

Data warehousing

Performance tuning

Dimensional modeling

Medallion architecture

Layered architecture

SQL optimization

English communication

Tools

Snowflake CLI

DBT

Snowpark

Airflow CLI

Job description

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

Nice to have

• Experience with multi agent communication security patterns.
• Experience performing trust model assessments and gap analysis for agent ecosystems.
• Experience with Cedar policy testing tools and policy validation frameworks.
• Experience with AWS security testing and cloud security reviews.
• Knowledge of AI security risks, including prompt injection, excessive agency, identity spoofing, and tool parameter exposure.
• Experience with regulatory compliance validation and governance frameworks.
• Understanding of enterprise audit, risk management, and security monitoring practices.
• Experience working with large scale AI, cloud, or distributed platform environments.

What We Offer:

• Vacation days: Up to 26 business days per year.10 illness/special days off per year (fully paid, no medical papers needed) for all contract types
• Health and life insurance (Luxmed)
• MyBenefit platform with Multisport option
• Internal psychological support service
• English language classes from the first working day
• Access to external learning platforms: O’Reilly, LinkedIn Learning, Udemy, and a wide catalog of diverse internal training
• Flexible workplace: work from the office, from home, or choose a hybrid option
• Tech Skills Mentoring Program
• Opportunities to develop as a public speaker, mentor, or technical interviewer
• Fully paid idle (bench) when not involved in a project
• Certification reimbursement (AWS, GCP, Microsoft, etc.)