National AI Awards 2025Discover AI's trailblazers! Join us to celebrate innovation and nominate industry leaders.

Nominate & Attend

Senior Data Engineer-Snowflake/DBT

Gallagher
Greater London
3 weeks ago
Create job alert

Overview

We are seeking a highly skilled Senior Data Engineer to drive the design and delivery of high-quality, reliable data solutions. This role requires a deep understanding of modern data engineering best practices, strong problem-solving skills, and the ability to work collaboratively with cross-functional teams. This is a Senior Data Engineering position and we are therefore looking for someone with extensive experience in this area with hands of experience using Snowflake and DBT. This role will be based from our London City office and we be looking for someone to be on site two days a week with the rest being hybrid working from home. How you'll make an impact SQL Server Proficiency: A strong understanding of Microsoft SQL Server and Structured Query Language (SQL) is crucial. The role requires working with databases, querying data, and optimizing performance. Data Warehouses & Data Modelling: Strong experience with data warehouse and modelling concepts is essential for designing efficient and effective database structures. Understanding relationships, normalization, and denormalization is expected. ETL (Extract, Transform, Load) Pipelines: Experience with ETL (and ELT) processes is vital. The role is responsible for extracting data from various sources, transforming it, and loading it into data warehouses, etc. Problem-Solving Skills: As a data engineer, the role will encounter data discrepancies, performance issues, and user queries. Strong problem-solving abilities are essential. Security Awareness: Understanding data security principles and compliance (such as GDPR) is crucial. This role handles corporate sensitive data and information. Insurance Industry Knowledge: Required to understand the nuances and specific needs of the insurance industry. About You Previous experience gained working as a Senior Data Engineer in the insurance industry. Knowledge of technologies such as Snowflake Data Cloud, with supporting technologies and tools, including DBT, FiveTran, Dataiku and Collibra (Collibra experince is preferable for not essential). Experience with Microsoft Azure technologies, including Synapse and DevOps. Experience with Microsoft SQL Server technologies, including Master Data Services, SSIS, SSAS & SSRS. Knowledge of supporting tools/languages including Python & C# would be preferrable Compensation and benefits On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits. Below are the minimum core benefits you’ll get, depending on your job level these benefits may improve: Minimum of 25 days holiday, plus bank holidays, and the option to ‘buy’ extra days Defined contribution pension scheme, which Gallagher will also contribute to Life insurance, which will pay 4x your basic annual salary, which you can top-up to 10x Income protection, we’ll cover up to 50% of your annual income, with options to top up Health cash plan or Private medical insurance Other benefits include: Three fully paid volunteering days per year Employee Stock Purchase plan, offering company shares at a discount Share incentive plan, HMRC approved, tax effective, stock purchase plan Critical illness cover Discounted gym membership, with over 3,000 gyms nationally Season ticket loan Access to a discounted voucher portal to save money on your weekly shop or next big purchase Emergency back-up family care And many more…

Related Jobs

View all jobs

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

National AI Awards 2025

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 Jobs Skills Radar 2026: Emerging Tools, Languages & Platforms to Learn Now

The UK’s data science job market is evolving fast—from forecasting models and AI assistants to real-time decision systems. In 2026, data scientists aren’t just expected to build models—they’re responsible for shaping insights that fuel everything from patient care to predictive banking. Welcome to the Data Science Jobs Skills Radar 2026—your essential annual guide to the languages, tools, and platforms driving demand across the UK. Whether you’re entering the job market or reskilling mid-career, this roadmap helps you prioritise the skills that matter most right now.

How to Find Hidden Data Science Jobs in the UK Using Professional Bodies like the RSS, BCS & More

The data science job market in the UK is thriving—but also increasingly competitive. As organisations in finance, healthcare, retail, government, and tech accelerate digital transformation, the demand for data talent has soared. Yet many of the best data science jobs are never posted publicly. They’re shared behind closed doors—within professional networks, at invite-only events, or through member-only mailing lists and specialist interest groups. These “hidden” roles are often filled through referrals, collaborations, or direct outreach to trusted experts. In this guide, we’ll show you how to unlock these hidden opportunities by engaging with key UK professional bodies such as the Royal Statistical Society (RSS), BCS (The Chartered Institute for IT), and Turing Society, plus communities like PyData and AI UK. You’ll learn how to use directories, CPD events, and networks to move beyond job boards—and into roles where you’re approached, not just applying.

How to Get a Better Data Science Job After a Lay-Off or Redundancy

Redundancy can be tough to face, especially in a competitive field like data science. But it’s important to know: your experience, analytical thinking, and modelling skills are still in demand. Across sectors like healthcare, finance, e-commerce, government and AI startups, UK employers continue to seek data scientists who can deliver value through insight, prediction, and automation. This guide will walk you through how to bounce back from redundancy with purpose and clarity—whether you're a data analyst looking to step up, a mid-level data scientist, or a machine learning specialist seeking a better-aligned opportunity.