Lead Data Engineer - DBT
- Cardiff
- Full-time
- IT & Change
- Onsite
__jobinformationwidget.freetext.ExternalReference__
3826_17928
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.
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
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 any of the following tools: Snowflake, Azure Synapse/Data Factory, DBT Cloud, Azure DevOps
- Industry recognised badges/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 the 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
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.
Great news! We will let you know when a new job like this has been added!
VideoUrl
https://www.youtube.com/watch?v=djTs2V4JUFs
Our businesses
There’s so much more to us than meets the eye. We’re insurers, investors, builders, city-regenerators and green technology champions. And whatever the future holds, our people’s knowledge, skill and passion will mean we’re placed to make a real difference to society.
Read MoreWorking for us
Here, your actions and ideas come to life in exciting and meaningful ways. Ours is a story of evolution, a journey we can go on together. Ours is a culture of trust and collaboration, genuinely caring about society and one another. At Legal & General, your story will be anything but familiar.
Read MoreSimilar roles
Salary
Location
London
Work Location Type
Hybrid
Business Unit
Legal & General Investment Management
Job Family
Marketing LGIM
Location
London
Full Time/Part Time
Full-time
Permanent/Fixed Term Contract
Fixed Term Contract
Description
Are you looking for an exciting opportunity to earn while you learn?The L&G Marketing internship is an 8-week programme, running from June to August. During this time, you’ll have the chance to develo
Reference
fb648a90-5042-4a92-9e9a-5829bfbb4c28
Expiry Date
01/01/0001
Salary
Location
Cardiff
Work Location Type
Hybrid
Business Unit
Legal & General Retail
Job Family
Marketing
Location
Cardiff
Full Time/Part Time
Full-time
Permanent/Fixed Term Contract
Fixed Term Contract
Description
Join our Customer Journey Optimisation Team, where we focus on enhancing digital experiences across our Life Insurance and Annuity journeys.As part of this 8-week internship, you’ll work closely with
Reference
dbbcf14f-e457-472c-b326-51eba2cb9f2a
Expiry Date
01/01/0001
Salary
Location
London
Work Location Type
Hybrid
Business Unit
Legal & General Investment Management
Job Family
Risk
Location
London
Full Time/Part Time
Full-time
Permanent/Fixed Term Contract
Fixed Term Contract
Description
Are you looking for an exciting opportunity to earn while you learn?The L&G Risk internship is an 8-week programme, running from June to August. During this time, you’ll have the chance to develop you
Reference
37a1a0bd-a73b-4ea4-b9ea-4c2d00b8965d
Expiry Date
01/01/0001
Our latest posts
Teaser
Future TalentContent Type
BlogPublish date
02/04/2026
Summary
Every apprentice arrives at L&G with different expectations and ambitions, but many describe a similar experience once they join. From day one, they’re putting theory into practice, building confi
by
Karen Maynard
Teaser
Finance & ActuaryContent Type
BlogPublish date
02/02/2026
Summary
Data Analysts are in high demand, but not all roles are created equal. If you want your work to have real impact, influencing business strategy, shaping financial decisions, and helping people
Teaser
GeneralContent Type
BlogPublish date
02/02/2026
Summary
At Legal & General (L&G), our Edinburgh office is where talented teams come together to combine data, insight, and purpose. Edinburgh is more than a workplace; it’s a city of ideas, history, a
Teaser
GeneralContent Type
BlogPublish date
02/02/2026
Summary
Looking for a career that offers more than just a commute? Brighton and Hove brings together coastal living, a vibrant community, and exciting professional opportunities, and it’s where many peop
Teaser
InvestmentsContent Type
BlogPublish date
12/17/2025
Summary
At L&G, risk management jobs put you at the centre of decision-making, giving you the chance to work on real-world challenges in operational risk, compliance, financial crime, and governance. Wh
Teaser
Technology, Digital & DataContent Type
BlogPublish date
12/17/2025
Summary
Technology is at the heart of innovation, and at L&G, our IT teams are shaping the future of financial services. From creating scalable systems to turning complex data into strategic insights, I
Teaser
GeneralContent Type
BlogPublish date
12/17/2025
Summary
Client relationship management jobs at L&G go far beyond maintaining contact lists or checking in on accounts. These roles put you at the centre of complex client portfolios, fast-moving markets, a
Teaser
InvestmentsContent Type
BlogPublish date
11/25/2025
Summary
In the world of private markets careers, every day offers the chance to make a tangible difference. At Legal & General (L&G), purpose sits at the heart of everything we do, from managing investm
Teaser
GeneralContent Type
BlogPublish date
11/05/2025
Summary
Dublin is a city that blends innovation, energy, and opportunity, a place where ambitious professionals thrive. At Legal & General (L&G), our Dublin office is at the heart of a dynamic financia
Teaser
GeneralContent Type
BlogPublish date
11/05/2025
Summary
At Legal & General (L&G), our Glasgow office is home to talented teams who combine analytical thinking with a shared sense of purpose. Here, roles like Data Analyst, Calculations Consultant, Act