Portfolio Revenue & Debt Data Analyst

Thames Water Utilities Limited; United Kingdom; Hybrid; GBP 53,000; Full time

Job summary

A leading UK water and wastewater company is seeking a skilled Portfolio Revenue & Debt Data Analyst to join their dynamic Credit Risk team. This role involves leading in-depth analyses of customer portfolio trends, developing SQL-based reporting solutions, and delivering insights that support debt reduction strategies. The ideal candidate will have strong SQL skills, experience in credit risk analytics, and the ability to influence strategic decisions. A degree in Data Analytics or a related field is required. Competitive salary and hybrid work model offered.

Benefits

Competitive salary

Flexible working arrangements

Career opportunities

Qualifications

• Proficiency in writing SQL queries for large datasets for reporting.
• Experience contributing to debt reduction and collections strategies.
• Demonstrated ability in leading analytical projects.

Responsibilities

• Lead deep-dive analysis into customer portfolio trends.
• Develop and maintain SQL-based reporting solutions.
• Conduct root cause analysis of debt accumulation trends.

Skills

SQL proficiency

Credit risk analytics

Data-driven insights

Stakeholder management

Financial modelling

Cloud platforms (Azure, AWS, Google Cloud)

Education

Degree in Data Analytics, Mathematics, or Statistics

Tools

SQL

Azure Data Lake

SAP

Job description

Job title Portfolio Revenue & Debt Data Analyst Ref 41957 Division Retail Location Hybrid - Walnut Court - SN2 8BN Contract type Permanent Full/Part-time Full-time Salary Competitive starting salary of £52,480 per annum Job grade B Closing date 06/01/2026

Are you ready to turn data into actionable insights and make a real impact? Thames Water is looking for a skilled and driven Portfolio Revenue & Debt Data Analyst to join our dynamic Credit Risk team.

This is a unique opportunity to work at the forefront of revenue and debt analytics, helping to shape smarter collections strategies, reduce bad debt, and improve customer outcomes. As part of a priority investment area, you’ll play a key role in transforming how we use data—working closely with senior stakeholders, digital teams, and data owners to deliver best-in-class portfolio management.

What you'll be doing as a Portfolio Revenue & Debt Data Analyst

In this pivotal role, you’ll lead deep-dive analysis into customer portfolio trends, deliver actionable insights, and support the transition to our enterprise data lake. Your work will directly influence operational improvements, policy decisions, and long-term financial resilience. You will also:

• Develop and maintain SQL-based reporting solutions to drive actionable insights.
• Collaborate with the Credit Reporting & Insight team to ensure analytics meet business needs.
• Partner with the Digital Team to align data governance and infrastructure.
• Work with the Income Leadership Team to shape strategy and support decision-making.
• Champion a culture of data-driven thinking across the Income function.

Key Responsibilities

• Conduct root cause analysis of debt accumulation trends.
• Deliver insights that support bad debt reduction and collections strategy.
• Lead analytical projects and manage stakeholder engagement.
• Support the migration to a data lake environment, ensuring data integrity and accessibility.
• Create scalable, efficient SQL code and reporting frameworks.
• Embed analytics into strategic decision-making across the business.

What you should bring to the role

To thrive in this role, you must be able to confidently answer YES to the following:

• Are you proficient in writing SQL queries to extract, join, and transform large datasets for MI/reporting and predictive modelling?
• Have you previously contributed to bad debt reduction, collections strategy, credit risk decisioning, or profit & loss impact through data-driven insight?
• Have you led analytical projects and managed stakeholders?

In addition, you will bring:

• Proven experience in credit risk analytics, debt management, or financial modelling. Strong SQL skills for querying, reporting, and optimisation.
• Ability to translate complex analysis into clear recommendations for non-technical stakeholders.
• Familiarity with cloud platforms like Azure Data Lake, AWS, or Google Cloud.
• A degree (or equivalent experience) in Data Analytics, Mathematics, Statistics, or similar.
• A passion for continuous improvement and data-led transformation.
• Experience migrating from traditional databases to data lake architecture.
• Background in Utilities or Financial Services.
• Exposure to SAP or DM9 environments.
• Knowledge of predictive modelling techniques relevant to credit risk.

Location

Hybrid – Walnut Court – SN2 8BN
Hours: 36 hours per week, Monday to Friday

Application Requirement

All applicants must include a covering letter describing a time when you added specific value to a project through your analysis, inclusive of:

• The metrics impacted
• The results delivered

Find out more about our benefits and perks

Who are we?

We’re the UK’s largest water and wastewater company, with more than 16 million customers relying on us every day to supply water for their taps and toilets. We want to build a better future for all, helping our customers, communities, people, and the planet to thrive. It’s a big job and we’ve got a long way to go, so we need help from passionate and skilled people, committed to making a difference and getting us to where we want to be in the years and decades to come.

Learn more about our purpose and values

Working at Thames Water

Thames Water is a unique, rewarding, and diverse place to work, where every day you can make a difference, yet no day is the same. As part of our family, you’ll enjoy meaningful career opportunities, flexible working arrangements and excellent benefits.

If you’re looking for a sustainable and successful career where you can make a daily difference to millions of people’s lives while helping to protect the world of water for future generations, we’ll be here to support you every step of the way. Together, we can build a better future for our customers, our region, and our planet.

Real purpose, real support, real opportunities. Come and join the Thames Water family. Why choose us? Learn more.

We’re committed to being a great, diverse, and inclusive place to work. We welcome applications from everyone and want to ensure you feel supported throughout the recruitment process. If you need any adjustments, whether that’s extra time, accessible formats, or anything else just let us know, we’re here to help and support.

When a crisis happens, we all rally around to support our customers. As part of Team Thames, you’ll have the opportunity to sign up to support our customers on the frontline as an ambassador. Full training will be given for what is undoubtedly an incredibly rewarding experience. It’s also a great opportunity to learn more about our business and meet colleagues.

Disclaimer

Due to the high volume of applications we receive, we may close the advert earlier than the advertised date, so we encourage you to apply as soon as possible to avoid disappointment.