Senior Data Migration Engineer (f/m/x)
⚲ Łódź, Lublin, Bydgoszcz, Kraków, Gdańsk, Katowice, Poznań, Rzeszów, Szczecin, Wrocław
Do uzgodnienia
Wymagania
- Snowflake
- T-SQL
- ETL
- Python
- Matillion
- Cloud Computing
Opis stanowiska
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.
Your tasks
• 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
Requirements
• 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
Nice-to-have requirements
• 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
Your tasks
• 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
Requirements
• 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
Nice-to-have requirements
• 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
🔍 Dekoder Ogłoszenia
🔴
AI-assisted code conversion
Może oznaczać, że będziesz spędzać dużo czasu na poprawianiu i weryfikowaniu kodu wygenerowanego przez AI, a nie na tworzeniu go od zera.
🔴
from the outset
Sugeruje, że będziesz zaangażowany od samego początku projektu, co może oznaczać dużą odpowiedzialność i potencjalnie niepełne wytyczne na starcie.
🔴
ensuring functional equivalence
Może oznaczać, że będziesz musiał poświęcić dużo czasu na dokładne porównywanie i testowanie logiki między dwoma różnymi systemami baz danych.
🔴
reviewing and productionizing AI-generated code
Podkreśla, że Twoją rolą będzie nie tylko generowanie kodu przez AI, ale przede wszystkim jego weryfikacja i przygotowanie do wdrożenia, co może być czasochłonne.
🟡
global client operating in the tobacco industry
Praca dla klienta z branży tytoniowej może wiązać się z pewnymi specyficznymi wyzwaniami etycznymi lub regulacyjnymi.