Senior Snowflake Data Engineer

Luxoft Poland; Poland; On-site; PLN 180,000 - 260,000; Full time

Job summary

Luxoft Poland is seeking a highly skilled Snowflake Data Engineer to design, build, and optimize scalable data pipelines across AWS, Azure and GCP. The role focuses on Snowflake mastery, RBAC, and secure data governance to support AI and analytics initiatives.

The candidate will work with DBT, Python, and ETL/ELT tools, delivering robust data models and efficient SQL transformations. Collaboration with data analysts and architects is essential.

Qualifications

• 5+ years of experience in data engineering and Snowflake development.
• Strong proficiency with Snowflake, Snowpipe, RBAC and performance tuning.
• Ability to write complex SQL queries, stored procedures and UDFs.
• Experience with ETL/ELT tools including Snowpipe, AWS Glue, Fivetran or similar.
• Proficiency in transforming data with SQL; Python is a plus.
• Knowledge of data modeling (OLTP/OLAP/Data Vault 2.0) and governance.

Responsibilities

• Design, build and optimize scalable data pipelines on AWS, Azure and GCP.
• Develop and optimize Snowflake data models, schemas and transformations.
• Implement data governance, RBAC, security and compliance standards.
• Collaborate with analysts, architects and business teams on requirements.
• Ensure data quality and monitor/ troubleshoot pipelines.
• Contribute to CI/CD practices and code reviews for data solutions.

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 highly skilled Snowflake Data Engineer to design, build, and optimize scalable data pipelines and cloud-based solutions across AWS, Azure, and GCP. The ideal candidate will have strong expertise in Snowflake, ETL Tools like DBT, Python, visualization tools like Tableau and modern CI/CD practices, with a deep understanding of data governance, security, and role-based access control (RBAC). Knowledge of data modeling methodologies (OLTP, OLAP, Data Vault 2.0), data quality frameworks, Stream lit application development and SAP integration and infrastructure-as-code with Terraform is essential. Experience working with different file formats such as JSON, Parquet, CSV, and XML is highly valued.

Responsibilities

• In-depth knowledge of Snowflake's data warehousing capabilities.
• Understanding of Snowflake's virtual warehouse architecture and how to optimize performance
• and cost.
• Proficiency in using Snowflake's data sharing and integration features for seamless collaboration.
• Develop and optimize complex SQL scripts, stored procedures, and data transformations.
• Work closely with data analysts, architects, and business teams to understand requirements and
• Implement and maintain data models, dimensional modeling for data warehousing, data marts, and star/snowflake schemas to support reporting and analytics.
• Integrate data from various sources including APIs, flat files, relational databases, and cloud services.
• Ensure data quality, data governance, and compliance standards are met.
• Monitor and troubleshoot performance issues, errors, and pipeline failures in Snowflake and associated tools.
• Participate in code reviews, testing, and deployment of data solutions in development and production environments.

Mandatory Skills Description

• 5+ years of experience
• Strong proficiency in Snowflake (Snowpipe, RBAC, performance tuning).
• Ability to write complex SQL queries, stored procedures, and user-defined functions.
• Skills in optimizing SQL queries for performance and efficiency.
• Experience with ETL/ELT tools and techniques, including Snowpipe, AWS Glue, openflow, fivetran or similar tools for real-time and periodic data processing.
• Proficiency in transforming data within Snowflake using SQL, with Python being a plus.
• Strong understanding of data security, compliance and governance.
• Experience with DBT for database object modeling and provisioning.
• Experience in version control tools, particularly Azure DevOps.
• Good documentation and coaching practice.

Nice-to-Have Skills Description

• experience with AWS Lambda, particularly in utilising Python to develop data extraction functionalities.
• ability to retrieve data from platforms like SharePoint or Salesforce and transfer it to an S3 bucket