Be at the heart of actionFly remote-controlled drones into enemy territory to gather vital information.

Apply Now

Senior SQL & SSIS Data Engineer (Data warehouse)

London
1 day ago
Create job alert

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

Related Jobs

View all jobs

Data Engineer, On-Prem, SSIS, SQL etc, Home Based, to £ 60000

Senior Data Engineer

Senior BI Data Engineer

Senior Data Engineer

Senior Data Engineer

Lead Data Engineer

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.

Data Science Recruitment Trends 2025 (UK): What Job Seekers Need To Know About Today’s Hiring Process

Summary: UK data science hiring has shifted from title‑led CV screens to capability‑driven assessments that emphasise rigorous problem framing, high‑quality analytics & modelling, experiment/causality, production awareness (MLOps), governance/ethics, and measurable product or commercial impact. This guide explains what’s changed, what to expect in interviews & how to prepare—especially for product/data scientists, applied ML scientists, decision scientists, econometricians, growth/marketing analysts, and ML‑adjacent data scientists supporting LLM/AI products. Who this is for: Product/decision/data scientists, applied ML scientists, econometrics & causal inference specialists, experimentation leads, analytics engineers crossing into DS, ML generalists with strong statistics, and data scientists collaborating with platform/MLOps teams in the UK.

Why Data Science Careers in the UK Are Becoming More Multidisciplinary

Data science once meant advanced statistics, machine learning models and coding in Python or R. In the UK today, it has become one of the most in-demand professions across sectors — from healthcare to finance, retail to government. But as the field matures, employers now expect more than technical modelling skills. Modern data science is multidisciplinary. It requires not just coding and algorithms, but also legal knowledge, ethical reasoning, psychological insight, linguistic clarity and human-centred design. Data scientists are expected to interpret, communicate and apply data responsibly, with awareness of law, human behaviour and accessibility. In this article, we’ll explore why data science careers in the UK are becoming more multidisciplinary, how these five disciplines intersect with data science, and what job-seekers & employers need to know to succeed in this transformed field.

Data Science Team Structures Explained: Who Does What in a Modern Data Science Department

Data science is one of the most in-demand, dynamic, and multidisciplinary areas in the UK tech and business landscape. Organisations from finance, retail, health, government, and beyond are using data to drive decisions, automate processes, personalise services, predict trends, detect fraud, and more. To do that well, companies don’t just need good data scientists; they need teams with clearly defined roles, responsibilities, workflows, collaboration, and governance. If you're aiming for a role in data science or recruiting for one, understanding the structure of a data science department—and who does what—can make all the difference. This article breaks down the key roles, how they interact across the lifecycle of a data science project, what skills and qualifications are typical in the UK, expected salary ranges, challenges, trends, and how to build or grow an effective team.