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 Mortgage Services are hiring for a Data Engineer to work within the performance reporting function which provides invaluable insight to internal and external stakeholders around lending performance.

This role would see you join an already established team to work on the reporting dashboard suite which is shared with third party lenders to provide information around post valuation queries, complaints, compensation rates and many other areas which would impact overall lending.

You will be working internally with the business to support workflow, change and business processes aimed to increase efficiency as well as upholding and ensuring data quality and maintenance of data structures, while using tools such as power BI to build dashboards and power automate to maintain and create data pipelines.

What you’ll be doing

• Building large, complex data systems and pipelines to enable the production of accurate and timely management information in accordance with business and individual stakeholder requirements.
• Identifying, designing, and implementing internal process improvements, automating manual processes, optimizing data delivery, and redesigning data infrastructure for greater scalability
• Performing route cause analysis on internal data and processes to answer specific business questions and identifying opportunities for improvement.
• Exploring ways to enhance data quality and reliability and building accessible data platforms for analysis.
• Producing ad hoc analysis including observing recent trends to identify opportunities and making recommendations to improve business profitability.
• Providing data analysis for ad hoc projects ensuring that outcomes are delivered on time and in compliance with project requirements.
• Offering advice and guidance to colleagues including where required, providing coaching and development of others such that understanding of business data is developed and deployed throughout the organisation.

Qualifications

What we’re looking for

• Database management related qualification (MCSA,MCSE etc) is desirable. Any other IT qualifications are also beneficial.
• SQL Server or relational database concept understanding
• Microsoft Excel
• Microsoft Power BI
• Data warehouse knowledge desirable
• Ability to convert customer requirements into desired outcomes.
• Hands-on experience of SQL Server or equivalent databases, stored procedures, views and SQL queries.

Additional Information

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.