Job Title: Senior SQL and SSIS Data Engineer (Data warehouse)Contract Length: 6 Months (possibility for perm)Location: London (5 days in 10 )Working Pattern: Full TimeRate: Highly competitive rate available for suitable candidatesAre you a data wizard ready to take on a challenging role in a dynamic Data Warehouse team? Our client is on the lookout for a talented Senior Data Engineer with a passion for SQL and SSIS development. Join us for a thrilling 6-month journey focused on optimising our existing SQL Server 2019 data warehouse environment, which is poised for transformation!About the Role In this hands-on, technical position, you will take ownership of a significant portfolio of around 90 SSIS batch jobs. You''ll dive deep into performance analysis, tackle existing technical debt, and implement best practises that will elevate our data operations. Your expertise will be crucial as we gear up for an exciting data warehouse migration from New York to London in 2026!Key ResponsibilitiesAnalyse and optimise SSIS ETL pipelines and batch jobs.Improve SQL performance through effective indexing and execution plans.Identify and resolve locking and blocking issues to enhance efficiency.Apply best practises to boost overall warehouse performance.Work independently to drive optimisation initiatives.Collaborate with senior developers for insightful technical reviews.Support and prepare for upcoming migration activities.Required SkillsExpert-level SQL proficiency (SQL Server 2019 ..... full job details .....