Senior SQL & SSIS Data Engineer (Data warehouse)

London
3 months ago
Applications closed

Related Jobs

View all jobs

Senior SQL Developer

Senior Data Engineer

Senior Data Engineer

Data Engineer

Senior Data Engineer - (Python & SQL)

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 Data Engineering Tools Do You Need to Know to Get a Data Engineering Job?

If you’re aiming for a career in data engineering, it can feel like you’re staring at a never-ending list of tools and technologies — SQL, Python, Spark, Kafka, Airflow, dbt, Snowflake, Redshift, Terraform, Kubernetes, and the list goes on. Scroll job boards and LinkedIn, and it’s easy to conclude that unless you have experience with every modern tool in the data stack, you won’t even get a callback. Here’s the honest truth most data engineering hiring managers will quietly agree with: 👉 They don’t hire you because you know every tool — they hire you because you can solve real data problems with the tools you know. Tools matter. But only in service of outcomes. Jobs are won by candidates who know why a technology is used, when to use it, and how to explain their decisions. So how many data engineering tools do you actually need to know to get a job? For most job seekers, the answer is far fewer than you think — but you do need them in the right combination and order. This article breaks down what employers really expect, which tools are core, which are role-specific, and how to focus your learning so you look capable and employable rather than overwhelmed.

What Hiring Managers Look for First in Data Engineering Job Applications (UK Guide)

If you’re applying for data engineering jobs in the UK, the first thing to understand is this: Hiring managers don’t read every word of your CV. They scan it. They look for signals of relevance, credibility, delivery and collaboration — and if they don’t see the right signals quickly, your application may never get a second look. In data engineering, hiring managers are especially focused on whether you can build and operate reliable, scalable data systems, handle real-world data challenges and work effectively with analytics, BI, data science and engineering teams. This guide breaks down exactly what they look at first in your application — and how to shape your CV, portfolio and cover letter so you stand out.

The Skills Gap in Data Engineering Jobs: What Universities Aren’t Teaching

Data engineering has quietly become one of the most critical roles in the modern technology stack. While data science and AI often receive the spotlight, data engineers are the professionals who design, build and maintain the systems that make data usable at scale. Across the UK, demand for data engineers continues to rise. Organisations in finance, retail, healthcare, government, media and technology all report difficulty hiring candidates with the right skills. Salaries remain strong, and experienced professionals are in short supply. Yet despite this demand, many graduates with degrees in computer science, data science or related disciplines struggle to secure data engineering roles. The reason is not academic ability. It is a persistent skills gap between university education and real-world data engineering work. This article explores that gap in depth: what universities teach well, what they consistently miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data engineering.