Senior SQL & SSIS Data Engineer (Data warehouse)

London
1 month ago
Applications closed

Related Jobs

View all jobs

Senior Data Warehouse Engineer

Senior Database & Cloud Data Engineer

Senior Data Engineering Consultant

Senior Data Engineering Consultant

Senior Data Engineering Consultant

Senior Data Architect

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 to Write a Data Science Job Ad That Attracts the Right People

Data science plays a critical role in how organisations across the UK make decisions, build products and gain competitive advantage. From forecasting and personalisation to risk modelling and experimentation, data scientists help translate data into insight and action. Yet many employers struggle to attract the right data science candidates. Job adverts often generate high volumes of applications, but few applicants have the mix of analytical skill, business understanding and communication ability the role actually requires. At the same time, experienced data scientists skip over adverts that feel vague, inflated or misaligned with real data science work. In most cases, the issue is not a lack of talent — it is the quality and clarity of the job advert. Data scientists are analytical, sceptical of hype and highly selective. A poorly written job ad signals unclear expectations and immature data practices. A well-written one signals credibility, focus and serious intent. This guide explains how to write a data science job ad that attracts the right people, improves applicant quality and positions your organisation as a strong data employer.

Maths for Data Science Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data science jobs in the UK, the maths can feel like a moving target. Job descriptions say “strong statistical knowledge” or “solid ML fundamentals” but they rarely tell you which topics you will actually use day to day. Here’s the truth: most UK data science roles do not require advanced pure maths. What they do require is confidence with a tight set of practical topics that come up repeatedly in modelling, experimentation, forecasting, evaluation, stakeholder comms & decision-making. This guide focuses on the only maths most data scientists keep using: Statistics for decision making (confidence intervals, hypothesis tests, power, uncertainty) Probability for real-world data (base rates, noise, sampling, Bayesian intuition) Linear algebra essentials (vectors, matrices, projections, PCA intuition) Calculus & gradients (enough to understand optimisation & backprop) Optimisation & model evaluation (loss functions, cross-validation, metrics, thresholds) You’ll also get a 6-week plan, portfolio projects & a resources section you can follow without getting pulled into unnecessary theory.

Neurodiversity in Data Science Careers: Turning Different Thinking into a Superpower

Data science is all about turning messy, real-world information into decisions, products & insights. It sits at the crossroads of maths, coding, business & communication – which means it needs people who see patterns, ask unusual questions & challenge assumptions. That makes data science a natural fit for many neurodivergent people, including those with ADHD, autism & dyslexia. If you’re neurodivergent & thinking about a data science career, you might have heard comments like “you’re too distracted for complex analysis”, “too literal for stakeholder work” or “too disorganised for large projects”. In reality, the same traits that can make traditional environments difficult often line up beautifully with data science work. This guide is written for data science job seekers in the UK. We’ll explore: What neurodiversity means in a data science context How ADHD, autism & dyslexia strengths map to common data science roles Practical workplace adjustments you can request under UK law How to talk about your neurodivergence in applications & interviews By the end, you’ll have a clearer sense of where you might thrive in data science – & how to turn “different thinking” into a real career advantage.