Senior Data Migration Engineer (f/m/x)

Senior Data Migration Engineer (f/m/x)

Miejsce pracy: Bydgoszcz

Technologies we use

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

Our 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

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.