Data Engineer

Company Description

Life can sometimes be unpredictable, and it pays to plan ahead. Our aim at Legal & General Retail is to help our customers plan for the unexpected, achieve financial security for their tomorrow, and protect everything that’s important to them. To better understand our customers and meet their needs, we’ve brought our protection, retirement income, savings, lending, and advice, fintech and mortgage businesses under one umbrella. Created at the start of 2022 through the merging of our long-standing and trusted retail retirement and insurance businesses, we’re a fast-growing division with big, customer-centred ambitions.  

Job Description

Legal and General Retail’s Group Protection Data team are currently hiring for a Data Engineer as they begin the journey of delivering a new, modernised data platform with the aim of increasing accessibility and quality to improve insight required by the wider business for decision making.

This position will see you responsible for liaising with the business to gather requirements, working with the team to identify potential tools and through the migration on to a centralised platform consolidate data sources.

What you’ll be doing:

• Contributing towards improvements to database systems and linking the understanding of source data to value-adding data engineering solutions (across storage, transformation, and data quality)
• Continuously developing processes so that deliverables are created in the most efficient way to improve performance, ensuring code is scalable, portable, and reusable, ensuring timely and accurate delivery of data solutions to the business
• Developing and maintaining productive relationships with all stakeholders; providing advice and guidance on data solutions to improve their knowledge and understanding
• Effectively maintaining Planning and Design documentation and utilising a variety of tools and techniques to manage Stakeholders
• Taking accountability for the delivery of ad hoc data requirement for internal customers; understanding the business need and deliver the outcome in a flexible manner in line with business requirements
• Owning the timely delivery of data platform pipelines to the business while aiming for automation and standardisation to support business requirements
• Engaging stakeholders and undertaking appropriate testing prior to the implementation of any system or business changes to ensure the impact on internal stakeholders and customers is understood

Qualifications

Who we’re looking for:

• Proficient across many domains of data engineering, including ELT/ETL, metadata management, data integration, data management in transit and at rest and data streaming
• Experience of Kimball modelling techniques to design databases & data warehousing solutions that conform to the standards adopted by Data Ops
• Competent in the cloud data warehousing paradigms specific to our platform, with a good awareness of alternatives
• Use of modern project delivery methodologies to plan and deliver solutions (Agile, Waterfall etc)
• Highly proficient in SQL, DAX, DDL & DML & Powershell.
• A detailed working knowledge of many of the tools and platforms used by the Engineering Team, for example; Wherescape RED & 3D, Snowflake, Postgres, SQL Server, PowerBI, DBT, Alteryx, Qlik Replicate, Salesforce 
• Industry recognised badges and certificates on any of the following tools: Snowflake, Azure Synapse/Data Factory, DBT Cloud, Azure DevOps, PowerBI would be beneficial

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   
• Private medical insurance (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 
• 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

Additional Information

Legal & General is a leading financial services organisation, named Britain’s Most Admired Company in 2023, for the second year running. Rated top in our sector and top for inspirational leadership, we have a strong heritage and an exciting future.  

We’re one of the world’s largest asset managers, homebuilders, pension providers and insurers. Connecting to form a unique business model which drives value for our customers and society. And enabling our people to create impact through work that is meaningful and valued.  

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 strive to be open, mindful, and inclusive, so are always willing to discussing flexible working arrangements and reasonable accommodations for candidates with specific needs. 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. 

If you’re open to find out more, we’d love to hear from you.