Senior Data Migration Engineer (f/m/x)

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

• 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

Job no. JOB-G3A2T

Sii ensures that all hiring decisions are made solely on the basis of qualifications and competence. We are committed to equal and fair treatment of all, regardless of legally protected characteristics. At Sii, we promote a diverse and inclusive work environment, in full compliance with applicable anti-discrimination laws.

Benefits For You

• Great Place to Work
• Solid financial situation
• Contracts with the biggest brands
• Centre of internal trainings
• Many experts you can learn from
• Open and accessible management team
• Profit sharing
• Passion Sponsorship program
• Regular integration events and trips
• Comfortable and well-equipped offices
• MySii app
• Medical care