Data Engineer

Arthur J. Gallagher & Co. (AJG)
London
1 week ago
Create job alert
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.


Overview

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.


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 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 experience 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 preferable.

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…

We value inclusion and diversity


Inclusion and diversity (I&D) is a core part of our business, and it’s embedded into the fabric of our organisation. For more than 95 years, Gallagher has led with a commitment to sustainability and to support the communities where we live and work.


Gallagher embraces our employees’ diverse identities, experiences and talents, allowing us to better serve our clients and communities. We see inclusion as a conscious commitment and diversity as a vital strength. By embracing diversity in all its forms, we live out The Gallagher Way to its fullest.


Gallagher is Disability Confident Committed. We have pledged to make sure our recruitment process is inclusive and accessible, in addition to supporting our existing employees with any long‑term health conditions or disabilities.


We understand that applicants may have disabilities, if you do, you may find some parts of the recruitment process more challenging than others. Don’t worry, we’re here to help, however, we can only do this if you let us know.


Should you require reasonable adjustments to your application, please get in touch with . If you’d prefer to speak on the phone, please request a call back, leaving details, so we get in touch.


Our employing entity, Arthur J. Gallagher Services (UK) Limited, is proud to be accredited as a Living Wage employer with the Living Wage Foundation. We are committed to diversity and opportunity for all and are opposed to any form of less‑favourable treatment on the grounds of gender or gender identity, marital status, civil partnership status, parental status, race, ethnicity, colour, nationality, disability, sexual orientation, religion/ belief, age and those with caring responsibilities.


Gallagher believes that all persons are entitled to equal employment opportunity and prohibits any form of discrimination by its managers, employees, vendors or customers based on race, colour, religion, creed, gender (including pregnancy status), sexual orientation, gender identity (which includes transgender and other gender non‑conforming individuals), gender expression, hair expression, marital status, parental status, age, national origin, ancestry, disability, medical condition, genetic information, veteran or military status, citizenship status, or any other characteristic protected (herein referred to as “protected characteristics”) by applicable federal, state, or local laws.


Equal employment opportunity will be extended in all aspects of the employer‑employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified person with a disability, unless the accommodation would impose an undue hardship on the operation of our business.


#J-18808-Ljbffr

Related Jobs

View all jobs

Data Engineer

Data Engineer

Data Engineer

Data Engineer

Data Engineer

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 Jobs for Career Switchers in Their 30s, 40s & 50s (UK Reality Check)

Thinking about switching into data science in your 30s, 40s or 50s? You’re far from alone. Across the UK, businesses are investing in data science talent to turn data into insight, support better decisions and unlock competitive advantage. But with all the hype about machine learning, Python, AI and data unicorns, it can be hard to separate real opportunities from noise. This article gives you a practical, UK-focused reality check on data science careers for mid-life career switchers — what roles really exist, what skills employers really hire for, how long retraining typically takes, what UK recruiters actually look for and how to craft a compelling career pivot story. Whether you come from finance, marketing, operations, research, project management or another field entirely, there are meaningful pathways into data science — and age itself is not the barrier many people fear.

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.