Lead Data Engineer - DBT

Legal And General Group
Cardiff
6 days ago
Create job alert
Company Description

Legal & General (L&G) is a leading UK financial services group and major global investor.


We’ve been safeguarding people’s financial futures since 1836, and strive to build a better society, while improving the lives of our customers and creating value for shareholders.


We are one of the world’s largest asset managers and provide powerful asset origination capabilities. Together, these underpin our retirement and protection solutions: we are an international player in pension risk transfer, in UK and US life insurance, and in UK workplace pensions and retirement income.


L&G Retail supports the savings, protection and retirement needs of around 14 million people, through our portfolio of retail and workplace businesses.


Our Retail division helps people enjoy a more colourful retirement, both directly and through their employers, including Lifetime Mortgages, Retirement Interest Only Mortgages and financial advice on our range of lending products.


We are the UK’s number one individual life insurer, and also provide Group Protection products for employers – all helping people to plan for the unexpected. We support home buying through our Mortgage Club – the UK’s largest – and our award-winning Surveying Services team. And our fintech team finds and supports socially useful start-ups and scale-ups working in the workplace, home, insurance and wealth areas.


Joining us means helping create brighter financial futures for all our customers.


Job Description

Legal and General Retail’s Data Operations team are currently hiring three Lead Data Engineers following the merger of internal divisions resulting in them expanding into a new area. These positions are to focus on the retirements side of the Retail division and will build out new data pipelines utilising tools such as Synapse, DBT, Azure DevOps and Snowflake.


This role will see you responsible for designing, building, and implementing a variety of data solutions using modern ETL techniques and tools and you will be driving projects forward while serving as a mentor and coach to junior members of the team.


What you will be doing

  • Ensuring the solutions developed and deployed are fit for purpose and GDPR compliant, meeting the business requirements, adhering to quality standards, and delivering the intended value
  • Ensuring all developments delivered follow the agreed standards and release management processes
  • Taking responsibility for evolving these standards in an environment of continuous change facilitating team sessions that seek to improve them and keep them current & compliant
  • Identifying issues and risks with the solutions created and leading their resolution while providing support to colleagues in your team as required, while providing input into team and project planning activities and work within an agile delivery framework as part of a Scrum team
  • Facilitating the refinement of the tasks in the Product Backlog and guide and support your team as you break deliveries down into technical data engineering components
  • Converting user stories in to technical, quality, testing and documentation tasks in the chosen work‑flow management tool
  • Liaising with the end customers, Architect & Product Owner to translate business goals into compliant specifications that facilitate the delivery of the technical solution and can be used by any engineer
  • Provide mentorship and support to junior and mid‑level data engineers in your team and acting as a role model to colleagues across the Data Ops function

Qualifications

Who we’re looking for:



  • Proficient in data engineering practices including ELT/ETL, database management systems, data integration, and data quality
  • Experience and practical knowledge of any of the following tools: Snowflake, Azure Synapse/Data Factory, DBTCloud, Azure DevOps
  • Industry recognised badges or certificates on any of the following methodologies: Scrum/Kanban, DevOps/DataOps, Dimensional Data Modelling (Kimball)
  • Expertise in a variety of database technologies and data warehousing paradigms
  • Familiarity with cloud platforms, CDC and streaming technologies, and data architecture principles
  • Strong background in delivering data engineering solutions, adhering to project delivery methodologies (Agile, Waterfall)
  • Experience in stakeholder management, complex data solution documentation, and driving continuous improvement within a regulated environment

Whatever your role, we reward performance and behaviour with a package that looks after all the things that are important to you. Here are some of the benefits we offer:



  • The opportunity to participate in our annual, performance‑related bonus plan and valuable share schemes
  • Generous pension contribution
  • Life assurance
  • Healthcare Plan (permanent employees only)
  • At least 25 days holiday, plus public holidays, 26 days after 2 years’ service. There’s also the option to buy and sell holiday
  • Competitive family leave
  • Participate in our electric car scheme, which offers employees the option to hire a brand‑new electric car through tax‑efficient salary sacrifice (permanent employees only)
  • There are many discounts we offer – both for our own products and at a range of high street stores and online
  • In 2023, some of our workspaces were redesigned. Our offices are great spaces to connect and collaborate and have your wellbeing at the heart

Additional Information

At L&G, we believe it’s possible to generate positive returns today while helping to build a better future for all.


If you join us, you’ll be part of a welcoming, inclusive culture, with opportunities to collaborate with people of diverse backgrounds, views, and experiences. Guided by leaders with integrity who care about your future and wellbeing. Empowered through initiatives which support people to develop their careers and excel.


We care passionately about outcomes rather than attendance and are therefore open to discussing all kinds of flexible working options including part‑time, term‑time and job shares. Although some roles have limited flexibility due to customer demand, we accommodate requests when we can.


It doesn’t matter if you don’t meet every single criterion in this advert. Instead, think about what you excel at and what else you can bring in terms of strengths, potential and connection to our purpose.


#J-18808-Ljbffr

Related Jobs

View all jobs

Lead Data Engineer

Lead Data Engineer / Architect – Databricks Active - SC Cleared

Lead Data Engineer

Lead Data Engineer

Lead Data Engineer

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