TL;DR

Middle Data Engineer (Data Science/ML): Support migration of legacy on-premises SQL Server data warehouse to cloud-based Snowflake environment with an accent on building and refactoring ETL pipelines, data transformations, and optimizing cloud data processing. Focus on designing efficient data pipelines, refactoring legacy ETL jobs, and ensuring reliable data movement for analytics and reporting.

Location: Flexible working format - remote, office-based or hybrid

Company

%hirify_global% is a product company specializing in SaaS solutions, including HR SaaS for the public sector.

What you will do

Build and modify data pipelines migrating data from SQL Server and other databases to AWS S3 and Snowflake.
Refactor legacy ETL jobs (SSIS, Transact-SQL) for cloud environments.
Implement data transformations and staging using dbt or similar tools.
Optimize performance and costs of cloud data processing and storage.
Collaborate with client and %hirify_global% engineers ensuring smooth handoff and documentation.
Participate in QA, testing, deployment, and post-migration validation.

Requirements

English: B2 level or higher required
Experience with Snowflake, AWS S3, and cloud data warehouse technologies.
Strong SQL skills and experience migrating legacy environments to cloud platforms.
Familiarity with ETL frameworks and tools such as SSIS and dbt.
Proficiency in Python for data pipeline development and automation.
Strong documentation and communication skills for cross-functional teamwork.

Nice to have

Experience in large-scale data migration projects.
Background with various database platforms including SQL Server, Oracle, PostgreSQL, MySQL.
Knowledge of reporting platforms such as Looker.

Culture & Benefits

Flexible working format: remote, office-based, or hybrid.
Competitive salary and compensation package.
Personalized career growth and professional development tools.
Active tech communities and knowledge sharing.
Education reimbursement and memorable anniversary presents.
Corporate events and team building activities.