Lead Data Engineer - DBT

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.

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 Dev Ops 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.

• 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 of any of the following tools:
  Snowflake, Azure Synapse/Data Factory, DBTCloud, Azure Dev Ops
• Industry recognised badges or certificates on any of the following methodologies:
  Scrum/Kanban, Dev Ops/Data Ops, 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…