Data & Analytics Manager (SQL)

at  Lloyds Banking Group

End Date
Tuesday 19 March 2024
Salary Range
£62,874 - £69,860
Agile Working Options
Hybrid Working, Job Share
Job Description Summary
.
Job Description
Data & Analytics Manager (SQL)
Cardiff or Bristol – Two days per week and & rest from home. Can go into the office full time if desired.
Salary & Benefits: £62,874 to £76,846 per annum (experience dependent), plus annual personal bonus, 15% employer pension contribution, flexible benefits package, private medical insurance, 30 days holiday plus bank holidays.
About us;
An exciting opportunity to join the Business & Commercial Banking (BCB) Channels team, which is a key growth area. Our role is integral to the build out of origination and servicing digital journeys for customers and a transformational change for the division!
The Channel Insight team act as a centre of excellence for digital insight within BCB, and we utilise our analytical knowledge, numeric reasoning and experience to convert data into actionable executive decisions to develop and commercialise the business.
What exactly will I focus on?
You’ll be extracting, segmenting, and analysing data. Building out the insight recommendations through numeric reasoning that helps deliver the digital strategy. Using several different tools predominantly SQL to access data within our data warehouses.
You’ll provide the insight to improve our channel journeys, giving our customers a better choice of channel to best meet their need.
Within Channel Insights we play a pivotal role in providing action orientated insight, which is critical in driving the strategy of channel migration to digital and marketing led channels.
Your ability to collaborate with others, generate insight, convert into recommendations and present to a senior audience, will really set you up to succeed!

Examples of specific activities you could be responsible for;

• Utilise data visualisation skills to tell the story of performance, highlighting areas of focus
• Regular performance tracking to enable effective management of the digital channel, extracting data to measure performance, with ad hoc analysis produced when required to diagnose causes of performance instability
• Utilise insight to identify further opportunities to optimise client experience
• Work with the wider Channels team to understand change agenda, and produce analysis to measure the impact of optimisation activity – including forecasting impacts on overall performance
• Support delivery of key Group strategic objective to grow BCB digital channels

What we’re looking for;

We’d welcome applicants from diverse cultural, and technological backgrounds and believe this is critical to success. This is a role in a niche area, so as a minimum to be considered for shortlisting we need to see evidence of the following in your CV;

• Must have - Prior history as a data warehouse specialist or data analyst, data engineer, marketing specialists or related analysis role, at mid to senior level. You’ll need to hit the ground running!
• You’ll have some analysis experience using a complex and large relational database (e.g. Teradata or Hadoop or something of similar scale etc.).
• Intermediate scripting or programming skill for data extraction using a tool such as SQL OR SAS OR Python (any of these three, not all of them!)
• We’d also love to see your track record in using data and insight to influence analytics to develop practical insight and confidence in telling stories through data. Good presentation skills are a must.
• Any background in digital marketing would be helpful, but not essential.

About working for us
Our focus is to ensure we’re inclusive every day, building an organisation that reflects modern society and celebrates diversity in all its forms.
We want our people to feel that they belong and can be their best, regardless of background, identity or culture.
We were one of the first major organisations to set goals on diversity in senior roles, create a menopause health package, and a dedicated Working with Cancer initiative.
And it’s why we especially welcome applications from under-represented groups.
We’re disability confident.
So if you’d like reasonable adjustments to be made to our recruitment processes, just let us know.
Ready for a career where you can have a positive impact as you learn, grow and thrive?
Apply today and find out more
At Lloyds Banking Group, we’re driven by a clear purpose; to help Britain prosper. Across the Group, our colleagues are focused on making a difference to customers, businesses and communities. With us you’ll have a key role to play in shaping the financial services of the future, whilst the scale and reach of our Group means you’ll have many opportunities to learn, grow and develop.
We keep your data safe. So, we’ll only ever ask you to provide confidential or sensitive information once you have formally been invited along to an interview or accepted a verbal offer to join us which is when we run our background checks. We’ll always explain what we need and why, with any request coming from a trusted Lloyds Banking Group person.
We’re focused on creating a values-led culture and are committed to building a workforce which reflects the diversity of the customers and communities we serve. Together we’re building a truly inclusive workplace where all of our colleagues have the opportunity to make a real difference

Examples of specific activities you could be responsible for;

• Utilise data visualisation skills to tell the story of performance, highlighting areas of focus
• Regular performance tracking to enable effective management of the digital channel, extracting data to measure performance, with ad hoc analysis produced when required to diagnose causes of performance instability
• Utilise insight to identify further opportunities to optimise client experience
• Work with the wider Channels team to understand change agenda, and produce analysis to measure the impact of optimisation activity – including forecasting impacts on overall performance
• Support delivery of key Group strategic objective to grow BCB digital channel

We’d welcome applicants from diverse cultural, and technological backgrounds and believe this is critical to success. This is a role in a niche area, so as a minimum to be considered for shortlisting we need to see evidence of the following in your CV;

• Must have - Prior history as a data warehouse specialist or data analyst, data engineer, marketing specialists or related analysis role, at mid to senior level. You’ll need to hit the ground running!
• You’ll have some analysis experience using a complex and large relational database (e.g. Teradata or Hadoop or something of similar scale etc.).
• Intermediate scripting or programming skill for data extraction using a tool such as SQL OR SAS OR Python (any of these three, not all of them!)
• We’d also love to see your track record in using data and insight to influence analytics to develop practical insight and confidence in telling stories through data. Good presentation skills are a must.
• Any background in digital marketing would be helpful, but not essential