Senior SQL & SSIS Data Engineer — Hybrid Data Warehouse Optimizer

Adecco; City Of London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A recruitment consultancy is seeking a Senior SQL & SSIS Data Engineer in London for a 6-month project with potential for permanent placement. The role involves optimizing a SQL Server 2019 data warehouse, managing SSIS batch jobs, and collaborating on a significant migration project. Ideal candidates will have expert SQL skills, strong SSIS experience, and a track record in performance tuning. This position offers a hybrid working model and opportunities for contract extensions based on performance.

Benefits

Hybrid working arrangement

Opportunities for contract extensions based on performance

Qualifications

• Expert-level SQL proficiency in Data Warehousing and PowerBI is essential.
• Strong SSIS development and optimisation experience is essential.
• Deep understanding of execution plans and performance tuning techniques.

Responsibilities

• Analyse 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.

Skills

Expert-level SQL proficiency

Strong SSIS development and optimisation experience

Solid experience with SSAS and SSRS tools

Deep understanding of execution plans and performance tuning techniques

Strong troubleshooting and problem-solving skills

Proven history of improving complex ETL environments

Tools

SQL Server 2019

PowerBI

Job description

A recruitment consultancy is seeking a Senior SQL & SSIS Data Engineer in London for a 6-month project with potential for permanent placement. The role involves optimizing a SQL Server 2019 data warehouse, managing SSIS batch jobs, and collaborating on a significant migration project. Ideal candidates will have expert SQL skills, strong SSIS experience, and a track record in performance tuning. This position offers a hybrid working model and opportunities for contract extensions based on performance.