At a Glance
- Tasks: Transform data into insights to shape smarter collections strategies and improve customer outcomes.
- Company: Join Thames Water, the UK's largest water and wastewater company, making a real difference.
- Benefits: Competitive salary, generous annual leave, pension scheme, and health benefits.
- Why this job: Be at the forefront of revenue analytics and influence operational improvements.
- Qualifications: Proficient in SQL, with experience in credit risk analytics and stakeholder management.
- Other info: Flexible working arrangements and meaningful career opportunities await you.
The predicted salary is between 50000 - 55000 £ per year.
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:
- Lead deep-dive analysis into customer portfolio trends, deliver actionable insights, and support the transition to our enterprise data lake.
- 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:
- Proficiency in writing SQL queries to extract, join, and transform large datasets for MI/reporting and predictive modelling.
- Experience contributing to bad debt reduction, collections strategy, credit risk decisioning, or profit & loss impact through data-driven insight.
- Experience leading analytical projects and managing stakeholders.
- 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 & Hours:
- 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 and the results delivered.
What’s in it for you?
- Competitive starting salary of £52,480 per annum.
- Annual leave: 26 days holiday per year, increasing to 30 with the length of service (plus bank holidays).
- Performance-related pay plan directly linked to both company and individual performance measures and targets.
- Generous Pension Scheme through AON.
- Access to lots of benefits to help you take care of you and your family’s health and wellbeing, and your finances.
Thames Water is a unique, rewarding, and diverse place to work, where every day you can make a difference. 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.
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.
Portfolio Revenue & Debt Data Analyst employer: Thames Water Utilities Limited
Contact Detail:
Thames Water Utilities Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Portfolio Revenue & Debt Data Analyst
✨Tip Number 1
Network like a pro! Reach out to current or former employees at Thames Water on LinkedIn. A friendly chat can give you insider info and maybe even a referral, which can really boost your chances.
✨Tip Number 2
Prepare for the interview by diving deep into the company’s values and recent projects. Show us that you’re not just another candidate; you’re genuinely interested in how you can contribute to their mission of improving customer outcomes.
✨Tip Number 3
Practice your SQL skills! Be ready to discuss specific examples of how you’ve used SQL to drive insights in past roles. We want to see that you can turn data into actionable strategies, especially in credit risk analytics.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about joining the Thames Water family.
We think you need these skills to ace Portfolio Revenue & Debt Data Analyst
Some tips for your application 🫡
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Make sure to highlight a specific project where your analysis made a real impact. Use metrics to back up your claims and show us how you can add value to our team.
Show Off Your SQL Skills: Since this role heavily relies on SQL, don’t shy away from showcasing your expertise. Mention specific SQL projects or queries you've worked on that demonstrate your ability to extract and transform data effectively.
Tailor Your CV to the Role: Make sure your CV reflects the skills and experiences that are most relevant to the Portfolio Revenue & Debt Data Analyst position. Highlight your experience in credit risk analytics and any familiarity with cloud platforms like Azure or AWS.
Apply Through Our Website: We encourage you to apply directly through our website for the best chance of success. It’s the easiest way for us to keep track of your application and ensure it gets the attention it deserves!
How to prepare for a job interview at Thames Water Utilities Limited
✨Know Your SQL Inside Out
As a Portfolio Revenue & Debt Data Analyst, you'll need to showcase your SQL skills. Brush up on writing complex queries and be ready to discuss how you've used SQL to extract and transform data in previous roles. Prepare examples that highlight your ability to create efficient reporting solutions.
✨Demonstrate Your Analytical Impact
Be prepared to share specific instances where your analysis led to tangible results, especially in bad debt reduction or collections strategy. Use metrics to illustrate the impact of your work, as this will resonate with the interviewers looking for someone who can drive actionable insights.
✨Engage with Stakeholders
Since stakeholder engagement is key in this role, think of examples where you've successfully managed relationships with non-technical stakeholders. Practice explaining complex data insights in simple terms, as this will show your ability to communicate effectively across teams.
✨Familiarise Yourself with Data Lakes
Given the focus on migrating to a data lake environment, it’s crucial to understand the basics of cloud platforms like Azure Data Lake or AWS. Be ready to discuss any experience you have with data governance and how you can contribute to ensuring data integrity and accessibility in this new setup.