Senior Snowflake Developer

DataArt; United States; Hybrid; USD 120,000 - 210,000; Full time

Benefits offered by this job

Vacation days

Illness days

Health insurance

English language classes

Learning platforms access

Flexible workplace

Mentoring program

Job summary

DataArt is seeking an experienced Senior Snowflake Data Engineer to lead the migration of a large MySQL-based data platform to Snowflake. You will design end-to-end Snowflake architecture, build resilient ingestion pipelines, and drive best practices in CI/CD, testing, and versioned SQL.

You will collaborate with cross-functional teams across architecture and engineering to optimize performance and costs, ensuring scalable data workflows and robust data governance for the client in the US.

Qualifications

• 3+ years of hands-on Snowflake engineering experience.
• Strong ELT/ETL design in cloud data warehouses.
• Experience migrating from MySQL or PostgreSQL to Snowflake.
• Proficiency in SQL and Python.
• CI/CD with GitHub Actions or GitLab CI.

Responsibilities

• Plan migration from MySQL to Snowflake and design end-to-end architecture.
• Develop ETL/ELT workflows for diverse data formats.
• Build resilient ingestion pipelines for complex files.
• Support CI/CD, testing, and version-controlled SQL practices.
• Collaborate with architecture, pipeline development, and engineering teams.

Tools

Snowflake

DBT

Airflow

Airbyte

GitHub Actions

GitLab CI

SQL

Python

MySQL

PostgreSQL

KImball/Data Vault modelling

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