Rectification Data Analyst

Lloyds Banking Group; Halifax; Hybrid; GBP 35,000 - 50,000; Full time

Job summary

A leading financial services provider in the UK is looking for a SAS or SQL Data Analyst to join their Customer Resolutions Data team. This role involves sourcing, analyzing, and developing data to identify customer issues and calculate refunds as needed. The ideal candidate will possess strong SQL or SAS coding skills, critical thinking abilities, and excellent communication skills. We offer generous benefits and an inclusive workplace culture where diverse backgrounds are welcomed.

Benefits

Generous pension contribution up to 15%

Annual bonus award

Share schemes including free shares

Discounted shopping

28 days' holiday plus bank holidays

Wellbeing initiatives and generous parental leave policies

Qualifications

• Experience of coding using SQL or SAS to manipulate data robustly and accurately.
• Good written and verbal communication skills to present complex data issues to non-technical audiences.
• Ability to think critically, solving problems with great attention to detail.

Responsibilities

• Source, analyse and develop data using SQL or SAS to identify customers affected by problems.
• Provide insights and advice to guide business decisions.
• Collaborate with colleagues to resolve issues and contribute to continuous improvement.

Skills

SQL

SAS

Data analysis

Critical thinking

Communication skills

Tools

Python

BigQuery

Job description

About the Role

SAS or SQL Data Analyst / Developer / Coder, there are many names for what we do in the Customer Resolutions Data team. We play a vital role in sourcing, analysing and developing data using SQL/SAS to accurately and efficiently identify customers affected by problems and calculating any refunds required in line with procedures and controls. We're always learning and sharing our knowledge through each project and look for ways to standardise re‑usable activities. You'll be using advanced data techniques to identify and calculate the customer impact of problems. Providing insightful information and advice to guide business decisions. Collaborating with colleagues in the wider team to help understand and resolve issues for our customers, whilst contributing to continuous improvement of processes, tools and techniques. We aim to make processes straight forward and are empowered to challenge thinking and behaviours to enable the business to adapt and evolve, addressing real customer problems when it matters.

Responsibilities

You will source, analyse and develop data using SQL or SAS to identify customers affected by problems and calculate refunds. You will provide insights and advice to guide business decisions, collaborate with colleagues to resolve issues, and contribute to continuous improvement of processes, tools and techniques. You will use advanced data techniques to identify and calculate the customer impact of problems.

Qualifications

• Experience of coding using SQL or SAS to manipulate data robustly and accurately
• Practical application of your coding skills within the workplace, in a similar data analysis / manipulation role
• Good written and verbal communication skills to present complex data issues to non‑technical audiences
• The ability to think critically, solving problems with great attention to detail
• And any experience of these would be useful
• Previous experience of integrating data across multiple sources
• Knowledge of Python or BigQuery in Google Cloud
• Experience using AI to accelerate development

Benefits

• A generous pension contribution of up to 15%
• An annual bonus award, subject to Group performance
• Share schemes including free shares
• Benefits you can adapt to your lifestyle, such as discounted shopping
• 28 days' holiday, with bank holidays on top
• A range of wellbeing initiatives and generous parental leave policies

Inclusive Workplace

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.

Why Join Us

Join us and, as well as making a difference to customers, you’ll enjoy a fulfilling career where you’re free to be yourself. Great colleagues, transforming workspaces, hybrid working and a wide variety of career opportunities – you’ll find them all here. Our focus is to ensure we’re inclusive every day, building an organisation that reflects modern society and celebrates diversity in all its forms.

About Lloyds Banking Group

If you’re excited by the thought of becoming part of our team, get in touch. We’d love to hear from you. 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 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.