Data Engineer (SQL)

Legal & General; Cardiff; On-site; GBP 45,000 - 65,000; Full time

Job summary

A leading UK financial services group is seeking a Senior Data Engineer to join its dynamic team in Cardiff. The role involves maintaining the Finance data strategy, working with stakeholders to gather data requirements, and creating innovative data solutions while utilizing SQL and Python/C#. The ideal candidate will also support finance teams with data extraction and build strong relationships across the Asset Management functions. This position offers a competitive benefits package including a bonus plan and generous leave options.

Benefits

Annual performance-related bonus

Generous pension contributions

Life assurance

Healthcare Plan

At least 25 days holiday

Electric car scheme

Discounts for products

Qualifications

• Experience in data programming and finance data.
• Proficiency in SQL and Python and/or C#.
• Experience with data visualization tools such as Tableau or Power BI.
• Strong oral and written communication skills.
• Experience with relational databases (i.e. Microsoft SQL Server, Oracle).
• Familiarity with ETL/ELT tools (e.g., Alteryx) and big data platforms (e.g., Snowflake).

Responsibilities

• Develop strong relationships with stakeholders across Asset Management functions.
• Work with Senior Finance Managers to understand data requirements.
• Design, build, and maintain solutions following architectural frameworks.
• Provide technical support to finance teams for data extraction.
• Ensure consistent and optimized data structures across systems.
• Create innovative data solutions.
• Document technical processes and solutions.
• Engage with Group Data to improve data solutions.

Skills

Data programming

SQL

Python

C#

Data visualization tools (Tableau, Power BI)

Relational databases

ETL/ELT tools

Big data platforms (Snowflake)

Job description

Company Description

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 global asset management business provides our clients and partners with complex, responsible investment solutions, working internationally across public and private markets.

Job Description

Join our dynamic team at Legal and General Asset Management as a Senior Data Engineer. You will play a crucial role in maintaining and developing our Finance data strategy, ensuring efficient data sourcing, storage, processing, and maintenance. This is an exciting opportunity to work with cutting‑edge technologies and contribute to the continuous improvement of our data solutions.

What you’ll be doing:

• Developing strong working relationships with stakeholders across Asset Management functions
• Working with Senior Finance Managers and Business Stakeholders to understand data requirements
• Designing, analysing, building, and maintaining solutions following architectural frameworks
• Providing technical support to finance teams for data extraction and reporting
• Ensuring data structures are consistent and optimised across various systems
• Creating innovative data solutions
• Documenting technical processes and solutions
• Engaging with Group Data to improve and utilise data solutions, including Cloud solutions

Qualifications

Who we’re looking for:

• Experience in data programming and finance data
• Proficiency in SQL and Python and/or C#
• Experience with data visualization tools such as Tableau or Power BI
• Strong oral and written communication skills
• Experience with relational databases (e.g., Microsoft SQL Server, Oracle)
• Familiarity with ETL/ELT tools (e.g., Alteryx) and big data platforms (e.g., Snowflake)

Benefits

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
• 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

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.