Senior Snowflake Data Engineer

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

Benefits offered by this job

Private medical & dental care

Life insurance

Internal mobility program

Job summary

Luxoft is seeking an experienced Snowflake Data Engineer to modernize data infrastructure and support AI initiatives in the pharmaceutical industry. You will design and optimize Snowflake-based data models, pipelines, and integrations to empower analytics and reporting across multiple projects.

The role requires 5+ years of hands-on experience with Snowflake, SQL, ETL/ELT tools, and DBT, along with a strong focus on governance, security, and scalable data architectures.

Qualifications

• 5+ years of experience in data engineering or related field.
• 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.

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.

Skills

Snowflake

SQL

SQL scripting

Python

ETL/ELT

DBT

Azure DevOps

Data governance

Data quality

Security & compliance

Tools

Snowflake

Snowpipe

AWS Glue

Fivetran

Openflow

DBT

Azure DevOps

SharePoint/Salesforce data ingress

Job description

• Private Medical & Dental care & Life Insurance covered
• Internal Mobility program - possibility of rotation between projects, locations, accounts

…and more!

Project 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.

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