Portfolio Revenue & Debt Data Analyst
SKILLS
FULL DESCRIPTION
Tasks: Transform data into insights to improve customer outcomes and reduce bad debt.
Company: Join [Employer hidden — view at passion-project.co.uk], the UK's largest water and wastewater company.
Benefits: Competitive salary, generous annual leave, and a supportive work environment.
Why this job: Make a real impact on revenue strategies while developing your analytical skills.
Qualifications: Proficient in SQL with experience in credit risk analytics and stakeholder management.
Other info: Flexible working arrangements and opportunities for career growth.
Portfolio Revenue & Debt Data Analyst - Swindon, Wiltshire
[Employer hidden] 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
- 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.
Desirable Experience
- 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
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 – from annual health MOTs and access to physiotherapy and counselling, to Cycle to Work schemes, shopping vouchers and life assurance.