Senior Snowflake Data Engineer - Migration & Architecture

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

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.