Data Engineer

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.

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.

What 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

The brand with the brolly is choosing today to change tomorrow.

Since 1836, we’ve grown to become one of the world's largest asset managers, homebuilders, pension providers and insurance brands. 

We’re all here to improve the lives of our customers, build a better society for the long term, and create value for our shareholders - helping to shape a better future for society and the planet.

We need people who share our ambitions, agility and entrepreneurial spirit to help us do it.

At L&G, you’ll find a balance that helps you be your best. Empowered by hybrid working, we’re supported by technology and workplaces that enable us to work effectively wherever we are. We come together in offices to collaborate and connect, and use time at home for individual, focused activities. And, when we achieve great things, we celebrate our success and reward strong performance.

Today, there’s over 10,000 of us, working towards our mission, with plenty of opportunities to grow your career as we grow L&G. Will you join us?

Great minds don’t have to think alike, so we welcome voices from all backgrounds. Bringing together people with different life experiences helps us build empathy with our customers and drive innovation.

We don’t just talk about it, we actively promote diversity and equitable opportunities for all. That means our employment decisions are made without regard to race, colour, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability or protected veteran status. In fact, we embrace every dimension of diversity to reflect the customers and communities we serve.

We think it’s important to create an inclusive environment where we can all belong, contribute and drive progress, where you can develop and grow, and be empowered. We want you to use your voice to help us build a better tomorrow.

We all work differently, and have different needs, which is why. we’re always open to discussing flexible working arrangements. Likewise, we’re committed to finding reasonable accommodations for candidates with specific needs during our recruiting process.

So whoever you are, wherever you are, whatever your story, we'd love to hear from you.