Lead Data Engineer - DBT

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.