Senior Data Migration Engineer (f/m/x)

Join the delivery team focused on SQL Server-to-Snowflake migrations for a global client in the tobacco industry. Contribute to Matillion pipeline development, AI-assisted code conversion, automated testing, and data reconciliation from the outset.

Responsibilities

• Migrate database objects, including stored procedures, views, functions, and ETL logic, from Microsoft SQL Server to Snowflake while ensuring functional equivalence.
• Design, develop, and optimize Matillion ELT pipelines for loading and transforming data in Snowflake.
• Build automated data-validation and reconciliation frameworks in Python to compare source and target datasets during migration.
• Analyze and resolve data discrepancies related to data-type conversions, SQL dialect differences, and transformation logic.
• Use AI coding assistants to accelerate code conversion and refactoring; review and productionize AI-generated code.
• Optimize Snowflake performance through query tuning, virtual warehouses, clustering strategies, and transformation workloads.
• Create automated testing suites to validate migration results and prevent regressions throughout the delivery lifecycle.
• Implement 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 data-engineering skills, 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 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.
• Willingness to learn, experiment, and troubleshoot while working through ambiguity and iterating on AI output.
• Advanced Polish.