Engineer the Quantum RevolutionYour expertise can help us shape the future of quantum computing at Oxford Ionics.

View Open Roles

Senior Data Engineer-Snowflake/DBT

Gallagher
London
2 weeks ago
Create job alert

Join to apply for the Senior Data Engineer role at Gallagher

Join to apply for the Senior Data Engineer role at Gallagher

Introduction

Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a legacy of trust and triumph in the dynamic world of risk management.

Introduction

Indulge your passion for problem-solving and embrace the thrill of addressing risk head-on at Gallagher's global brokerage team. Join a family of diverse minds, united by a relentless pursuit of excellence. As part of our team, you'll be the architect of protection, safeguarding businesses and empowering their ambitions. Together, we'll build a legacy of trust and triumph in the dynamic world of risk management.

We believe that every candidate brings something special to the table, including you! So, even if you feel that you’re close but not an exact match, we encourage you to apply.

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 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 FiveTran, DBT, Dataiku, Collibra (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…

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, color, 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.Seniority level

  • Seniority levelNot Applicable

Employment type

  • Employment typeFull-time

Job function

  • Job functionInformation Technology
  • IndustriesInsurance

Referrals increase your chances of interviewing at Gallagher by 2x

Sign in to set job alerts for “Senior Data Engineer” roles.

London, England, United Kingdom 1 month ago

Senior Software Engineer - Card Integrations - Visa / Mastercard

London, England, United Kingdom 3 weeks ago

Team Lead - Senior Analytics Engineer - Utilities

London, England, United Kingdom 1 week ago

London Area, United Kingdom £70.00-£80.00 2 hours ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 4 weeks ago

Senior Data Governance Analyst | Up to £80k + Bonus & Benefits | 1 / 2 days in office

London, England, United Kingdom 17 hours ago

Data Architect - Data Modelling - Dimensional - Relational - Data Vault

London, England, United Kingdom 2 weeks ago

Senior Data Analyst | Greenfield Trading House | Up to £110k + Bonus | London Hybrid 3x/week

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 week ago

Senior Data Analyst - London Market, Insurance

City Of London, England, United Kingdom 1 week ago

Senior AI/ML Engineer (Data Science & Software Focus)

London, England, United Kingdom 5 days ago

Senior Data Analyst - London Market, Insurance, Contract

City Of London, England, United Kingdom 1 week ago

London, England, United Kingdom 2 months ago

London, England, United Kingdom 6 days ago

London, England, United Kingdom 2 hours ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 1 month ago

London, England, United Kingdom 2 months ago

Isleworth, England, United Kingdom 1 week ago

London, England, United Kingdom 1 day ago

London, England, United Kingdom 1 month ago

Redhill, England, United Kingdom 21 hours ago

Principal Solution Engineer – AI and Data Use Governance

London, England, United Kingdom 13 hours ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.


#J-18808-Ljbffr

Related Jobs

View all jobs

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

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

Jobs

Pre-Employment Checks for Machine Learning Jobs: DBS, References & Right-to-Work and more Explained

Pre-employment screening in machine learning reflects the discipline's unique position at the intersection of artificial intelligence research, algorithmic decision-making, and transformative business automation. Machine learning professionals often have privileged access to proprietary datasets, cutting-edge algorithms, and strategic AI systems that form the foundation of organizational competitive advantage and automated decision-making capabilities. The machine learning industry operates within complex regulatory frameworks spanning AI governance directives, algorithmic accountability requirements, and emerging ML ethics regulations. Machine learning specialists must demonstrate not only technical competence in model development and deployment but also deep understanding of algorithmic fairness, AI safety principles, and the societal implications of automated decision-making at scale. Modern machine learning roles frequently involve developing systems that impact hiring decisions, financial services, healthcare diagnostics, and autonomous operations across multiple regulatory jurisdictions and ethical frameworks simultaneously. The combination of algorithmic influence, predictive capabilities, and automated decision-making authority makes thorough candidate verification essential for maintaining compliance, fairness, and public trust in AI-powered systems.

Careers

Why Now Is the Perfect Time to Launch Your Career in Machine Learning: The UK's Intelligence Revolution

The United Kingdom stands at the epicentre of a machine learning revolution that's fundamentally transforming how we solve problems, deliver services, and unlock insights from data at unprecedented scale. From the AI-powered diagnostic systems revolutionising healthcare in Manchester to the algorithmic trading platforms driving London's financial markets, Britain's embrace of intelligent systems has created an extraordinary demand for skilled machine learning professionals that dramatically exceeds the current talent supply. If you've been seeking a career at the forefront of technological innovation or looking to position yourself in one of the most impactful sectors of the digital economy, machine learning represents an exceptional opportunity. The convergence of abundant data availability, computational power accessibility, advanced algorithmic development, and enterprise AI adoption has created perfect conditions for machine learning career success.

Jobs

Automate Your Machine Learning Jobs Search: Using ChatGPT, RSS & Alerts to Save Hours Each Week

ML jobs are everywhere—product companies, labs, consultancies, fintech, healthtech, robotics—often hidden in ATS portals or duplicated across boards. The fastest way to stay on top of them isn’t more scrolling; it’s automation. With keyword-rich alerts, RSS feeds, and a reusable ChatGPT workflow, you can bring relevant roles to you, triage them in minutes, and tailor strong applications without burning your evenings. This is a copy-paste playbook for www.machinelearningjobs.co.uk readers. It’s UK-centric, practical, and designed to save you hours each week. What You’ll Have Working In 30 Minutes A role & keyword map spanning LLM/NLP, Vision, Core ML, Recommenders, MLOps/Platform, Research/Applied Science, and Edge/Inference optimisation. Shareable Boolean searches you can paste into Google & job boards to cut noise. Always-on alerts & RSS feeds delivering fresh roles to your inbox/reader. A ChatGPT “ML Job Scout” prompt that deduplicates, scores fit, and outputs tailored actions. A lightweight pipeline tracker so deadlines and follow-ups never slip.

🍪 We use cookies to enhance your browsing experience on our website. By continuing to use this site, you consent to the use of cookies as described in our Cookie Policy. You can review our Cookie Policy for more information.