Senior SQL & SSIS Data Engineer (Data warehouse)

London
3 months ago
Applications closed

Related Jobs

View all jobs

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Data Engineer

Data Engineer

Senior Data Engineer - (Python & SQL)

Job Title: Senior SQL & SSIS Data Engineer (Data warehouse)
Contract Length: 6 Months (possibility for perm)
Location: London (5 days in 10 )
Working Pattern: Full Time
Rate: Highly competitive rate available for suitable candidates

Are 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 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.
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 Skills

Expert-level SQL proficiency (SQL Server 2019 on-prem) Data Warehousing and PowerBI is essential
Strong SSIS development and optimisation experience is essential.
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.Nice to Have

Experience with C# for SSIS scripts.
Proficiency in Python.
Exposure to Power BI for data visualisation.Why Join Us?

Be part of a vibrant team that values innovation and collaboration.
Contribute to a significant migration project that will make a real impact.
Enjoy a hybrid working arrangement that promotes work-life balance.
Opportunities for contract extensions based on performance.If you're ready to unleash your data engineering skills and make a meaningful difference, we want to hear from you! Apply today and embark on an exciting journey with us as we transform our data landscape.

Let's shape the future of our data together!

Pontoon is an employment consultancy. We put expertise, energy, and enthusiasm into improving everyone's chance of being part of the workplace. We respect and appreciate people of all ethnicities, generations, religious beliefs, sexual orientations, gender identities, and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive. If you require reasonable adjustments at any stage, please let us know and we will be happy to support you

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

How Many Machine Learning Tools Do You Need to Know to Get a Machine Learning Job?

Machine learning is one of the most exciting and rapidly growing areas of tech. But for job seekers it can also feel like a maze of tools, frameworks and platforms. One job advert wants TensorFlow and Keras. Another mentions PyTorch, scikit-learn and Spark. A third lists Mlflow, Docker, Kubernetes and more. With so many names out there, it’s easy to fall into the trap of thinking you must learn everything just to be competitive. Here’s the honest truth most machine learning hiring managers won’t say out loud: 👉 They don’t hire you because you know every tool. They hire you because you can solve real problems with the tools you know. Tools are important — no doubt — but context, judgement and outcomes matter far more. So how many machine learning tools do you actually need to know to get a job? For most job seekers, the real number is far smaller than you think — and more logically grouped. This guide breaks down exactly what employers expect, which tools are core, which are role-specific, and how to structure your learning for real career results.

What Hiring Managers Look for First in Machine Learning Job Applications (UK Guide)

Whether you’re applying for machine learning engineer, applied scientist, research scientist, ML Ops or data scientist roles, hiring managers scan applications quickly — often making decisions before they’ve read beyond the top third of your CV. In the competitive UK market, it’s not enough to list skills. You must send clear signals of relevance, delivery, impact, reasoning and readiness for production — and do it within the first few lines of your CV or portfolio. This guide walks you through exactly what hiring managers look for first in machine learning applications, how they evaluate CVs and portfolios, and what you can do to improve your chances of getting shortlisted at every stage — from your CV and LinkedIn profile to your cover letter and project portfolio.

MLOps Jobs in the UK: The Complete Career Guide for Machine Learning Professionals

Machine learning has moved from experimentation to production at scale. As a result, MLOps jobs have become some of the most in-demand and best-paid roles in the UK tech market. For job seekers with experience in machine learning, data science, software engineering or cloud infrastructure, MLOps represents a powerful career pivot or progression. This guide is designed to help you understand what MLOps roles involve, which skills employers are hiring for, how to transition into MLOps, salary expectations in the UK, and how to land your next role using specialist platforms like MachineLearningJobs.co.uk.