Senior Snowflake Developer with ETL and ELT

DataArt·Armenia, Bulgaria, Cyprus, Georgia, Kazakhstan, Latvia, Poland, Romania, Serbia, Ukraine·Удалённо, Офис·1 мес. назад

About the Position

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.

About the Project

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.

About the 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.

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, Azure DevOps, GitLab CI, or similar tools
Familiarity with data modelling best practices such as Kimball, Data Vault, or staging refined gold patterns