Support Engineer (SQL)

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.

Who we are

Our Retail business supports customers throughout their lives, to help them save, plan, protect and enjoy retirement.

We’re a leading provider of retirement and protection solutions. We aim to support our c.12.8 million policyholders and workplace members throughout their lifelong financial journeys.

We focus on helping the customers of today and tomorrow achieve better long-term outcomes. We either talk with them directly or work with intermediaries and employers to meet their needs. We use the latest technology to connect with them quickly, efficiently and wherever possible in highly personalised ways.

We’re looking for a Support Engineer to help keep our data services running smoothly. You’ll join a collaborative support team responsible for our Snowflake data warehouse, investigating pipeline issues, responding to internal queries and helping colleagues access the accurate data they need.

This is an opportunity to work with Snowflake, DBT, SQL and Azure technology in a varied environment where your troubleshooting and communication skills will be equally valued. We welcome candidates from different backgrounds who can demonstrate the relevant skills, even if they do not meet every desirable requirement.

What you'll be doing:

• Monitoring scheduled ETL jobs and data ingestion pipelines
• Confirming that data has loaded successfully into Snowflake
• Investigating pipeline failures and coordinating timely resolutions
• Responding to incidents and service requests from internal colleagues
• Troubleshooting missing, incomplete or inconsistent data
• Supporting technical and non-technical users with Snowflake queries
• Communicating progress and solutions in clear, accessible language
• Prioritising issues effectively within a fast-paced support environment

Who we're looking for:

• Practical experience of working with Snowflake would be ideal
• Good working knowledge of DBT
• Strong SQL skills
• Previous experience within a support or service desk environment
• Effective troubleshooting and analytical problem-solving skills
• An approachable communication style and the ability to explain technical subjects clearly
• The ability to remain organised and make sound decisions under pressure
• Experience of Azure Data Factory or the wider Azure ecosystem 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
• 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
• We’re creating net-zero carbon workplaces by 2030 by investing in our sustainable, modern offices across the UK, all designed to bring people together and elevate the in-person experience

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