Senior Analyst - Workforce Planning

Lloyds Banking Group; City of Edinburgh; On-site; GBP 41,000 - 49,000; Full time

Job summary

Lloyds Banking Group in Edinburgh is seeking a Senior Analyst in Workforce Planning to support forecasting and capacity planning for our Wealth & Investments teams. You will translate complex data into clear insights for senior stakeholders and drive end-to-end analyses with cross-functional partners.

Requirements include 3+ years in forecasting, strong numeracy, advanced Excel, and experience with Power BI/Power Query.

Qualifications

• 3+ years experience in forecasting and capacity planning within a large organisation.
• Ability to simplify and translate complex stories for senior audiences, through written and verbal presentation.
• Advanced Excel skills for report production, model building and data analysis.
• Experience engaging with partner teams to understand change and business ambition.

Responsibilities

• Lead meetings with colleagues up to Head of Function level.
• Identify trends in data and provide recommendations across commercial and operational data.
• Engage with partner teams to understand change and customer/economic landscape.
• Conduct 'what if' assessments on staffing impact and cost.
• Monitor movements in FTE, joiners, movers and leavers and their budget impact.
• Support recruitment decisions and multiskilling initiatives.
• Identify process improvements within the team and department.

Skills

Forecasting

Capacity planning

Excel

Data analysis

Communication

Collaboration

Problem solving

Numeracy

Presentation

Tools

Power BI

Power Query

Job description

JOB TITLE: Senior Analyst - Workforce Planning.

SALARY: £40,824pa to £49,000pa plus an extensive benefits package.

LOCATION: Edinburgh.

HOURS: Full Time.

WORKING PATTERN: Our work style is hybrid, which involves spending at least two days per week, or 40% of our time, at one of our office sites.

About this opportunity

This is your chance to join the Workforce Planning team as Wealth & Investments embark on a huge transformation as we deliver our Customer Service Vision!

We're looking for a Senior Analyst to join our Workforce Planning team in Wealth & Investments (W&I) to support planning our operational, customer facing teams. You should be numerate, possess excellent accuracy and decision-making skills with a curiosity that drives the ability to think holistically and 'join the dots' across multiple channels and business areas.

Workforce Planning play an important role in supporting the delivery of the Group's purpose by ensuring the operational, customer facing teams have the right people, in the right place, at the right time, to deliver the best possible customer experience.

Our purpose is to influence efficient and effective customer experience through trusted judgement, analysis and insight. Building relationships with internal customers and colleagues (operational leadership / platform / finance / data and commercial teams) is key to our success along with the ability to ensure data driven forecasts and insights are accurate, clear and appropriate.

Taking your place in the team as a Senior Analyst, you'll be:

• Leading meetings with various levels and groups of colleagues up to Head of Function level.
• Identifying trends with and analysing data to provide recommendations (including both commercial and operational data).
• Regularly engaging with partner teams to understand change and ambition for the business, alongside an understanding of the customer and economic landscape.
• Completing 'what if' assessments to understand the impact of changing requirements upon the customer facing teams
• Understanding movements in operational FTE, joiner/movers/leavers, and the impact this has on cost, budget and service.
• Supporting decision making for recruitment, multiskilling etc.
• Looking for opportunities to enhance your own skills and knowledge within your team and the department.
• Identifying areas of improvement to processes and service.
• Owning specific tasks and take these through to completion.

What you'll need

• 3+ years' experience of forecasting and capacity planning within a large organisation.
• Ability to simplify and translate complex stories to engage a senior audience, both through written and verbal/face to face presentation.
• Analytical curiosity (interpret data and provide recommendations).
• Strong numeracy and data literacy skills.
• Advanced Excel skills aligned to report production, model building and data analysis.
• A problem-solving approach.
• Great collaboration skills.
• A positive and professional manner.
• Drive, passion, enthusiasm, and a willingness to learn and develop.

And any experience of these would be really useful:

• Experience with Power BI and Power Query
• Knowledge of Wealth and Investment business and products

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.

As an inclusive employer, we offer Workplace Adjustments for colleagues with a disability (which may include long-term health and neurodivergent conditions) where it is reasonable to do so. This could include flexibility with regards to office attendance, location, and working pattern.

If you have a disability, you can also apply via our Disability Confident Scheme (DCS). Through the DCS, we guarantee to interview a fair and proportionate number of applicants with a disability, whose application meets the minimum criteria for the advertised job role.

We also provide adjustments that are reasonable throughout the recruitment process to reduce or remove barriers for applicants with a disability, long-term health condition or neurodivergent condition. If you'd like an adjustment to the recruitment process just let us know.