Senior Snowflake Developer

DataArt Poland sp. z o.o.; Województwo mazowieckie; Hybrid; PLN 180,000 - 280,000; Full time

Benefits offered by this job

Vacation days

Illness days off

Health and life insurance

English language classes

Learning platforms access

Flexible work arrangement

Mentoring program

Certification reimbursement

Job summary

DataArt Poland sp. z o.o. seeks a Snowflake engineer to lead end-to-end data platform migration from MySQL to Snowflake. You will design scalable Snowflake architecture, create resilient ingestion pipelines, and implement robust CI/CD, testing, and version-controlled SQL practices.

The role covers extraction and transformation of hundreds of sales file formats, collaboration with cross-functional teams, and ongoing performance and cost optimisation. Hybrid work options available.

Qualifications

• 3+ years of hands on Snowflake engineering experience: tables, stages, file formats, tasks, streams, and Snowflake SQL.
• Strong understanding of ELT/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 handling complex, messy 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/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

ETL/ELT design

Data migration (MySQL/PostgreSQL to SN

DBT

Airflow

Airbyte

SQL

Python

CI/CD for data workflows

Data modelling (Kimball/Data Vault)

Tools

GitHub Actions

GitLab CI

Job description

Nasze wymagania:

• 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

Mile widziane:

• Experience with AWS Bedrock AgentCore Identity as an early adopter or equivalent
• Experience with AWS AgentCore Gateway outbound authorization integration
• Exposure to MCP or A2A tool invocation authentication patterns
• Exposure to AgentCore Policy using Cedar or AWS Verified Permissions

O projekcie:

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.

Zakres obowiązków:

• 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

Oferujemy:

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