DataAnalyst(AnalyticsEngineer)

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 m