Senior Snowflake Data Engineer

Luxoft; Polska; On-site; PLN 180,000 - 240,000; Full time

Benefits offered by this job

Tax-deductible costs on a contract of,

Private Medical & Dental care & Life

MyBenefit program

Internal Mobility program

Job summary

Luxoft in Poland is seeking a Senior Snowflake Developer to design, develop and maintain scalable data solutions supporting AI and analytics initiatives. You will design Snowflake databases, build data pipelines, and optimize data models using DBT, SQL and Python.

You will collaborate with data architects, analysts and stakeholders to translate requirements into robust data flows, ensure data quality and governance, and drive CI/CD deployments using Azure DevOps.

Qualifications

• Master’s degree in computer science, Information Technology, or a related field.
• 5+ years of overall experience in data engineering, including Snowflake and DBT.
• Extensive hands-on experience in writing complex SQL queries for large data volumes.
• Strong understanding of data warehousing concepts and data modeling (OLTP, OLAP, Data Vault 2.0).
• Experience building data pipelines using DBT for data transformation.
• Familiarity with Snowflake performance tuning and query optimization.
• Knowledge of CI/CD pipelines, preferably Azure DevOps.
• Excellent problem-solving, analytical, and communication skills.

Responsibilities

• Design Snowflake databases, schemas, views, and data layers (RAW, STG, MART).
• Manage access with RBAC, role hierarchies, and data security policies.
• Work with dynamic tables, Snowpipe, external stages, and batch loading.
• Build and maintain production-grade Snowflake data pipelines.
• Write optimized SQL for ETL/ELT processes.
• Utilise Python for data processing and automation tasks.
• Advise on Snowflake architecture, features, and best practices.
• Develop and maintain complex data pipelines and DBT jobs.
• Collaborate with data architects, analysts and stakeholders for scalable solutions.
• Automate DBT jobs and CI/CD pipelines using Azure DevOps.
• Ensure data quality, integrity and governance throughout the lifecycle.
• Troubleshoot and optimize data processes and queries for performance.
• Document data models, processes and workflows.
• Develop data tests and mock data frameworks.
• Nice-to-have: AWS and Streamlit knowledge.

Skills

Snowflake

DBT

SQL

Python

CI/CD

Azure DevOps

Data warehousing

Data modeling

Team collaboration

Problem solving

Education

Master’s degree in computer science

Tools

Snowflake

DBT

Job description

The project is for one of the world's famous science and technology companies in pharmaceutical industry, supporting initiatives in AWS, AI and data engineering, with plans to launch over 20 additional initiatives in the future. Modernizing the data infrastructure through the transition to Snowflake as a priority, as it will enhance capabilities for implementing advanced AI solutions and unlock numerous opportunities for innovation and growth.

We are seeking a Senior Snowflake Developer who will be responsible for designing, developing, and maintaining scalable data solutions that effectively meet the needs of our organisation.

The role will serve as a primary point of accountability for the technical implementation of the data flows, repositories and data-centric solutions in your area, translating requirements into efficient implementations.

Responsibilities:

• Design and work with Snowflake databases, schemas, views, and RAW, STG, and MART data layers.


• Manage access using RBAC, role hierarchies, row-level security, and column-level access policies.


• Work with dynamic tables, external stages, Snowpipe, and batch data loading.


• Build and support reliable, production-grade Snowflake data pipelines.


• Write optimised SQL queries for data extraction, transformation, and loading.


• Utilise Python for advanced data processing, automation tasks, and system integration.


• Be an advisor with your In-depth knowledge of Snowflake architecture, features, and best practices.


• Develop and maintain complex data pipelines and ETL processes in Snowflake.


• Collaborate with data architects, analysts, and stakeholders to design optimal and scalable data solutions.


• Automate DBT Jobs & build CI/CD pipelines using Azure DevOps for seamless deployment of data solutions.


• Ensure data quality, integrity, and compliance throughout the data lifecycle.


• Troubleshoot, optimize, and enhance existing data processes and queries for performance improvements.


• Document data models, processes, and workflows clearly for future reference and knowledge sharing.


• Build Data tests, Unit tests and mock data frameworks


• Good to have AWS and Streamlit knowledge

Mandatory Skills Description:

• Master’s degree in computer science, Information Technology, or a related field.


• 5+ years of overall experience in data engineering, including relevant and hands‑on expertise in Snowflake and DBT.


• Extensive hands‑on experience in writing complex SQL queries, demonstrating proficiency in data manipulation and analysis for large data volumes.


• Strong understanding of data warehousing concepts, methodologies, and technologies with in‑depth experience in data modelling techniques (OLTP, OLAP, Data Vault 2.0)


• Experience building data pipelines using DBT (Data Build Tool) for data transformation.


• Familiarity with advanced techniques for performance tuning methodologies in Snowflake including query optimization.


• Strong knowledge with CI/CD pipelines, preferably in Azure DevOps.


• Excellent problem‑solving, analytical, and critical thinking skills.


• Strong communication, collaboration, and interpersonal skills.

(Opportunity for Poland‑based candidates)

• Tax‑deductible costs on a contract of employment for all development roles


• Stable employment based on an employment contract


• Private Medical & Dental care & Life Insurance


• MyBenefit program (sports card, well‑being program etc.)


• Internal Mobility program - possibility of rotation between projects, locations, accounts