Description
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. 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.
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
Conditions
No conditions specified in the posting.
