Senior Data Migration Engineer (f/m/x)

Expected, Snowflake, T-SQL, ETL, Python, Matillion

Optional, Cloud Computing, AWS, Microsoft Azure

About the project, 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 responsibilities, 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

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

Optional, 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

What we offer, 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

Recruitment stages, Send your CV, Talk to us about your expectations, Learn more about our projects and choose the best, Start your adventure with Sii!

Sii Sp. z o.o., Sii is the leading technology consulting, digital transformation, engineering, and business services vendor in Poland. We already employ more than 7 300 professionals and implement projects in a variety of industries for clients from many countries around the world. The Great Place to Work title, won 10 times in a row, proves that at Sii, we create a friendly work environment., , Sii ensures that all employment-related decisions are made solely on the basis of qualifications and competencies. We are committed to equal treatment of all individuals, regardless of any protected characteristics, and promoting a diverse and inclusive work environment.

This is how we work,