Data Engineer

Introduction

At Gallagher, we help clients face risk with confidence because we believe that when businesses are protected, they’re free to grow, lead, and innovate.

You’ll be backed by our digital ecosystem: a client‑centric suite of consulting tools making it easier for you to meet your clients where they want to be met. Advanced data and analytics providing a comprehensive overview of the risk landscape is at your fingertips.

Here, you’re not just improving clients' risk profiles, you’re building trust. You’ll find a culture grounded in teamwork, guided by integrity, and fueled by a shared commitment to do the right thing. We value curiosity, celebrate new ideas, and empower you to take ownership of your career while making a meaningful impact for the businesses we serve.

If you’re ready to bring your unique perspective to a place where your work truly matters; think of Gallagher.

We are seeking a highly skilled 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.

We are looking for 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.

• 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.

• Previous experience gained working as a Data Engineer in the insurance industry.
• Knowledge of technologies such as Snowflake Data Cloud, with supporting technologies and tools, including DBT, Five Tran, Dataiku and Collibra (Collibra experience is preferable for not essential).
• Experience with Microsoft Azure technologies, including Synapse and Dev Ops.
• Experience with Microsoft SQL Server technologies, including Master Data Services, SSIS, SSAS & SSRS.
• Knowledge of supporting tools/languages including Python & C# would be preferable.

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…