Senior Snowflake Developer

DataArt; Polska; Hybrid; PLN 180,000 - 270,000; Full time

Benefits offered by this job

Vacation days up to 26 days per year

Illness/special days off per year

Health and life insurance (Luxmed)

MyBenefit with Multisport option

Internal psychological support service

English classes from day one

Access to learning platforms: O’Reilly

Flexible workplace: office, home, orhy

Tech Skills Mentoring Program

Opportunities to develop as a public/s

Job summary

DataArt is seeking an experienced Senior Snowflake Data Engineer to support a large-scale migration from MySQL to Snowflake. You will help shape reliable data workflows and scalable ingestion pipelines.

Work with a cross-functional team across architecture, pipeline development, and engineering practices, implementing CI/CD, testing, and version-controlled SQL. Hybrid work model in Poland.

Qualifications

• 3+ years hands-on Snowflake engineering experience.
• Strong ELT/ETL design in a cloud data warehouse environment.
• Proven experience migrating data workloads from relational databases such as MySQL or PostgreSQL to Snowflake or a similar platform.
• Experience with data transformation frameworks such as DBT, Airflow, Airbyte, or equivalent.
• Proficiency in SQL and at least one scripting language, with Python preferred.
• Experience working with complex, messy, or irregular file formats and building resilient ingestion pipelines.
• Solid understanding of CI and CD for data workflows using GitHub Actions, GitLab CI, or similar tools.
• Familiarity with data modelling best practices such as Kimball, Data Vault, or staging refined gold patterns

Responsibilities

• Plan and contribute to the migration of data workloads from MySQL to Snowflake.
• Design end to end Snowflake architecture for the target data platform.
• Develop and rebuild ETL and ELT workflows for hundreds of complex sales file formats.
• Build resilient ingestion pipelines for complex, messy, or irregular file formats.
• Contribute to CI and CD, testing, and version controlled SQL practices for data workflows.
• Support performance and cost optimisation across Snowflake workloads.
• Collaborate with cross functional teams on migration, architecture, and delivery activities

Skills

Snowflake engineering

SQL

Python

ELT/ETL design

CI/CD practices

Tools

DBT

Airflow

Airbyte

GitHub Actions

GitLab CI

Job description

Technology stack

Snowflake, Snowflake SQL, MySQL, PostgreSQL, SQL, Python, DBT, Airflow, Airbyte, GitHub Actions, AWS, GitLab CI

Client

Our client is a global leader in the music and entertainment industry, known for its extensive portfolio of iconic artists, innovative digital initiatives, and large-scale technology-driven operations.

Project overview

This initiative is centered on a large scale data platform migration from MySQL to Snowflake. The work includes end to end Snowflake architecture, resilient ingestion pipelines, and improved engineering practices such as CI and CD, testing, and version controlled SQL.

Team

You will work with a team involved in data engineering and cross functional collaboration. The collaboration style includes close work across architecture, pipeline development, and engineering practices.

Position overview

We are looking for an experienced Senior Snowflake Data Engineer to support the migration of a high volume database and help shape reliable, maintainable data workflows in Snowflake.

Responsibilities

• Plan and contribute to the migration of data workloads from MySQL to Snowflake
• Design end to end Snowflake architecture for the target data platform
• Develop and rebuild ETL and ELT workflows for hundreds of complex sales file formats
• Build resilient ingestion pipelines for complex, messy, or irregular file formats
• Contribute to CI and CD, testing, and version controlled SQL practices for data workflows
• Support performance and cost optimisation across Snowflake workloads
• Collaborate with cross functional teams on migration, architecture, and delivery activities

Requirements

• 3+ years of hands on Snowflake engineering experience, including tables, stages, file formats, tasks, streams, and Snowflake SQL
• Strong understanding of ELT and ETL pipeline design in a cloud data warehouse environment
• Proven experience migrating data workloads from relational databases such as MySQL or PostgreSQL to Snowflake or a similar platform
• Experience with data transformation frameworks such as DBT, Airflow, Airbyte, or equivalent
• Proficiency in SQL and at least one scripting language, with Python preferred
• Experience working with complex, messy, or irregular file formats and building resilient ingestion pipelines
• Solid understanding of CI and CD for data workflows using GitHub Actions, GitLab CI, or similar tools
• Familiarity with data modelling best practices such as Kimball, Data Vault, or staging refined gold patterns

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