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 SDLCNice 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
• Certification reimbursement (AWS, GCP, Microsoft, etc.)