Senior Snowflake Engineer: Airflow, Data Lakehouse & DW

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

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.