Senior Data Migration Engineer (f/m/x)
⚲ Białystok, Centrum, Bydgoszcz, Gdańsk, Oliwa, Katowice, Kraków, Podgórze, Lublin, Łódź, Śródmieście, Piła, Poznań, Wilda, Rzeszów, Szczecin, Toruń, Warszawa, Mokotów, Wrocław, Fabryczna
Do uzgodnienia
Wymagania
- Snowflake
- T-SQL
- ETL
- Python
- Matillion
- Cloud Computing
- AWS
- Microsoft Azure
Opis stanowiska
Nasze wymagania:
At least 5 years of hands-on experience developing and maintaining enterprise data warehouse solutions
Strong expertise in Microsoft SQL Server (T-SQL) and Snowflake, including performance optimization, stored procedures, views, functions, and query tuning
Proven experience migrating SQL Server workloads to Snowflake or another cloud data warehouse
Hands-on commercial experience with Snowflake, including knowledge of its architecture and performance optimization techniques
Strong Python skills for data engineering, with practical experience using pandas and pytest for automated testing and data validation
Experience using AI coding assistants in professional software development, with the ability to review and productionize AI-generated code
Advanced level of English
Mile widziane:
Experience with Matillion ETL and building production ELT pipelines
Knowledge of traditional data warehousing concepts and exposure to cloud/data platforms such as AWS or Azure
A genuine willingness to learn, experiment, and troubleshoot, with comfort working through ambiguity and iterating on AI output
Advanced level of Polish
O projekcie:
We are looking for a Senior Data Migration Engineer to join Sii and our delivery team focused on SQL Server to Snowflake migrations for a global client operating in the tobacco industry. You will contribute to the development of Matillion pipelines, AI-assisted code conversion, automated testing, and data reconciliation from the outset.
Zakres obowiązków:
Migrating database objects such as stored procedures, views, functions, and ETL logic from Microsoft SQL Server to Snowflake while ensuring functional equivalence
Designing, developing, and optimizing Matillion ELT pipelines for loading and transforming data into Snowflake
Building automated data validation and reconciliation frameworks in Python to compare source and target datasets during migration
Analyzing and resolving data discrepancies related to data type conversions, SQL dialect differences, and transformation logic
Leveraging AI coding assistants to accelerate code conversion and refactoring, while reviewing and productionizing AI-generated code
Optimizing Snowflake performance by tuning queries, virtual warehouses, clustering strategies, and transformation workloads
Creating automated testing suites to validate migration results and prevent regressions throughout the delivery lifecycle
Implementing CI/CD processes using Git and deployment pipelines to manage database, Snowflake, and Matillion releases across environments
Oferujemy:
Great Place to Work since 2015 - it’s thanks to feedback from our workers that we get this special title and constantly implement new ideas
Employment stability - revenue of PLN 2.1BN, no debts, since 2006 on the market
We share the profit with Workers - over PLN 76M has already been allocated for this aim since 2022
Attractive benefits package - private healthcare, benefits cafeteria platform, car discounts and more
Comfortable workplace – class A offices or remote work
Dozens of fascinating projects for prestigious brands from all over the world – you can change them thanks to Job Changer application
PLN 1 000 000 per year for your ideas - with this amount, we support the passions and voluntary actions of our workers
Investment in your growth – meetups, webinars, training platform and technology blog – you choose
Fantastic atmosphere created by all Sii Power People
At least 5 years of hands-on experience developing and maintaining enterprise data warehouse solutions
Strong expertise in Microsoft SQL Server (T-SQL) and Snowflake, including performance optimization, stored procedures, views, functions, and query tuning
Proven experience migrating SQL Server workloads to Snowflake or another cloud data warehouse
Hands-on commercial experience with Snowflake, including knowledge of its architecture and performance optimization techniques
Strong Python skills for data engineering, with practical experience using pandas and pytest for automated testing and data validation
Experience using AI coding assistants in professional software development, with the ability to review and productionize AI-generated code
Advanced level of English
Mile widziane:
Experience with Matillion ETL and building production ELT pipelines
Knowledge of traditional data warehousing concepts and exposure to cloud/data platforms such as AWS or Azure
A genuine willingness to learn, experiment, and troubleshoot, with comfort working through ambiguity and iterating on AI output
Advanced level of Polish
O projekcie:
We are looking for a Senior Data Migration Engineer to join Sii and our delivery team focused on SQL Server to Snowflake migrations for a global client operating in the tobacco industry. You will contribute to the development of Matillion pipelines, AI-assisted code conversion, automated testing, and data reconciliation from the outset.
Zakres obowiązków:
Migrating database objects such as stored procedures, views, functions, and ETL logic from Microsoft SQL Server to Snowflake while ensuring functional equivalence
Designing, developing, and optimizing Matillion ELT pipelines for loading and transforming data into Snowflake
Building automated data validation and reconciliation frameworks in Python to compare source and target datasets during migration
Analyzing and resolving data discrepancies related to data type conversions, SQL dialect differences, and transformation logic
Leveraging AI coding assistants to accelerate code conversion and refactoring, while reviewing and productionizing AI-generated code
Optimizing Snowflake performance by tuning queries, virtual warehouses, clustering strategies, and transformation workloads
Creating automated testing suites to validate migration results and prevent regressions throughout the delivery lifecycle
Implementing CI/CD processes using Git and deployment pipelines to manage database, Snowflake, and Matillion releases across environments
Oferujemy:
Great Place to Work since 2015 - it’s thanks to feedback from our workers that we get this special title and constantly implement new ideas
Employment stability - revenue of PLN 2.1BN, no debts, since 2006 on the market
We share the profit with Workers - over PLN 76M has already been allocated for this aim since 2022
Attractive benefits package - private healthcare, benefits cafeteria platform, car discounts and more
Comfortable workplace – class A offices or remote work
Dozens of fascinating projects for prestigious brands from all over the world – you can change them thanks to Job Changer application
PLN 1 000 000 per year for your ideas - with this amount, we support the passions and voluntary actions of our workers
Investment in your growth – meetups, webinars, training platform and technology blog – you choose
Fantastic atmosphere created by all Sii Power People
🔍 Dekoder Ogłoszenia
🔴
A genuine willingness to learn, experiment, and troubleshoot, with comfort working through ambiguity and iterating on AI output
Oczekuje się, że kandydat będzie musiał samodzielnie rozwiązywać problemy i radzić sobie z niejasnościami, zwłaszcza w kontekście pracy z kodem generowanym przez AI.
🔴
Experience using AI coding assistants in professional software development, with the ability to review and productionize AI-generated code
Może oznaczać, że część pracy będzie polegać na weryfikacji i dostosowywaniu kodu wygenerowanego przez narzędzia AI, co może być czasochłonne i wymagać dodatkowego wysiłku.
🔴
Senior Data Migration Engineer
Stanowisko 'senior' może oznaczać dużą samodzielność i odpowiedzialność, ale także potencjalnie brak ścisłego wsparcia ze strony bardziej doświadczonych kolegów.
🟡
global client operating in the tobacco industry
Praca dla klienta z branży tytoniowej może wiązać się z pewnymi ograniczeniami etycznymi lub wizerunkowymi dla niektórych kandydatów.
🟡
At least 5 years of hands-on experience developing and maintaining enterprise data warehouse solutions
Wymagane jest solidne i długoletnie doświadczenie, co może zawęzić grono potencjalnych kandydatów do osób z bardzo konkretnym profilem.