Data Analyst (Analytics Engineer)

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.  

Our Group Functions provide the services that all areas of the business need. This requires a talented and diverse team behind the scenes, who enable everyone at L&G to do what they do best.  

Joining us means helping to improve the lives of our customers and contributing to the success of the business every day. 

We’re looking for an Analytics Engineer to join our Data & Analytics team, helping to build scalable, reliable and well-governed data products using modern analytics engineering practices. 

This role is centred on data modelling, transformation and pipeline development, with a strong focus on dbt-style workflows and cloud data platforms (e.g. Snowflake). You’ll play a key role in shaping how data is structured and delivered across the organisation, enabling high-quality, self-service analytics. 

While the role includes exposure to Power BI, the focus is on engineering robust datasets and semantic models that underpin reporting, rather than building dashboards. 

What you’ll be doing:

Build scalable data models and transformation layers 

• Design and develop reusable, well-structured data models to support analytics use cases 
• Apply best practices in dimensional modelling and semantic layer design 
• Build data transformation workflows using modern tools (e.g. SQL, dbt or equivalent) 

Develop and operate data pipelines 

• Create and maintain automated ELT pipelines to transform and deliver data from multiple sources
• Ensure pipelines are reliable, efficient and scalable within a cloud data environment (e.g. Snowflake) 
• Promote standardisation, modular design and reusability across data transformations 

Drive data quality and engineering best practice 

• Implement testing frameworks (e.g. data validation, schema tests, lineage) to ensure data accuracy 
• Maintain documentation, version control and structured development practices 
• Contribute to the adoption of modern analytics engineering standards across the team 

Enable downstream analytics (Power BI) 

• Develop and maintain datasets and semantic models for Power BI consumption 
• Validate and test data within Power BI to ensure consistency with underlying models 
• Support programmatic interaction with Power BI (e.g. metadata extraction, automation, integration with data workflows) 
• Ensure strong alignment between upstream models and downstream reporting outputs 

Collaborate with analysts and stakeholders 

• Translate business requirements into scalable, reusable data assets 
• Enable self-service analytics by delivering clean, well-structured datasets 
• Work closely with analysts to improve data usability and consistency 

Optimisation and continuous improvement 

• Improve performance of queries, transformations and data models 
• Identify opportunities to automate processes and enhance efficiency 
• Contribute to tooling, frameworks and shared development patterns 

Who we’re looking for:

• Strong experience with SQL and data modelling (e.g. dimensional modelling, semantic modelling) 
• Experience with modern data transformation tooling (e.g. dbt strongly preferred) 
• Experience working with cloud data platforms (e.g. Snowflake, Azure, AWS) 
• Experience building and maintaining scalable data pipelines and datasets 
• Understanding of data quality, testing and governance practices 
• Experience working with Power BI datasets/semantic models (rather than solely report development) 
• Experience with Python or scripting for automation desirable 
• Exposure to version control (e.g. Git) and collaborative development practices 

Why is this role different?

• Focus on data modelling and transformation — not reporting delivery 
• Built around modern analytics engineering (dbt, ELT, testing, version control) 
• Strong emphasis on cloud data platforms (e.g. Snowflake) 
• Power BI used as a consumer layer, not the primary skill set 
• Opportunity to help shape standards, tooling and engineering practices 

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
• We’re creating net‑zero carbon workplaces by 2030 by investing in our sustainable, modern offices across the UK, all designed to bring people together and elevate the in‑person experience

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.