Asset Modelling Specialist

Affinity Water; Hatfield; On-site; GBP 49,000 - 59,000; Full time

Benefits offered by this job

Annual bonus scheme

Wellbeing Centre

Tap4Perks discounts

Life Assurance

Volunteer days

Job summary

Affinity Water is seeking an Asset Modelling Specialist to join our Strategic Asset Management & Insight team. You will shape long-term investment strategy by developing and maintaining asset investment modelling, translating data and deterioration models into auditable investment plans for PR29 and beyond.

You will collaborate with Asset Health, Cost Intelligence and IT to provide modelling, analysis and insights for regulatory submissions and business decisions, influencing funding priorities

Qualifications

• Degree in Engineering, Mathematics, Statistics, Data Science or a related discipline.
• Experience with Python or R for statistical modelling.
• Experience with modelling or decision-support tools such as Pioneer or Copperleaf.
• Knowledge of deterioration modelling and asset health to inform investment planning.
• Experience integrating asset, cost and performance data from multiple sources.
• Strong analytical and problem-solving skills with the ability to interpret complex datasets.

Responsibilities

• Steer the development and enhancement of the asset investment modelling system for PR29.
• Maintain system configuration, specifications and documentation.
• Integrate and validate asset, cost and performance data for accurate modelling and planning.
• Support deterioration modelling, scenario analysis, forecasting and optimisation.
• Analyse model outputs and translate data into clear insights.
• Develop interfaces between Pioneer and Copperleaf to align outputs with value frameworks.
• Collaborate with IT and vendors to maintain the modelling system and ARM module.
• Support governance, assurance and regulatory submissions; ensure transparency and auditable modelling.
• Contribute to the ongoing development of risk and value processes and investment decision-making.

Skills

Python

R

SQL

Excel

PowerPoint

SharePoint

Deterioration modelling

Data integration

Technical systems

Education

Engineering, Mathematics, Statistics, Data Science or related

Tools

Pioneer

Copperleaf

Job description

We’re looking for an Asset Modelling Specialist to join our Strategic Asset Management & Insight team and play a key role in shaping Affinity Water’s long-term investment strategy. In this role, you’ll help develop and maintain our asset investment modelling capability, ensuring asset data, deterioration models and cost assumptions are translated into robust, auditable investment plans for PR29 and beyond.

Working closely with Asset Health, Cost Intelligence, Investment Optimisation, IT, software vendors and wider stakeholders, you’ll provide modelling, analysis and insight to support investment planning, regulatory submissions and business decision-making.

This is a great opportunity to influence investment decisions over the next 5–25 years, helping us identify where funding should be prioritised to deliver the best outcomes and value for our customers.

What you’ll be doing

• Steer on the development and enhancement of the asset investment modelling system, ensuring it is fully fit-for-purpose as the organisation’s capital maintenance modelling tool for PR29.

• Maintain system configuration, specifications and documentation in line with governance requirements.

• Integrate and validate asset, cost and performance data to support accurate asset deterioration modelling and investment planning.

• Support deterioration modelling, scenario analysis, forecasting, sensitivities and optimisation.

• Analyse model outputs and translate complex data into clear, decision-ready insights.

• Develop the interface between Pioneer and Copperleaf, ensuring outputs align with our value and service frameworks.

• Work with IT and software vendors to maintain and improve the modelling system and support the Asset Risk Management (ARM) module.

• Support governance, assurance and regulatory submissions, ensuring modelling is transparent and auditable.

• Support the ongoing development of our Risk & Value process and value-based investment decision-making.

About you

You’ll have:

• A degree in Engineering, Mathematics, Statistics, Data Science or a related discipline.

• Experience with statistical modelling tools such as Python or R.

• Experience using modelling or decision-support tools such as Pioneer, Copperleaf or similar.

• An understanding of deterioration modelling and asset health and how these inform investment planning.

• Experience working with asset, cost and performance data and integrating multiple data sources.

• Experience developing, improving or implementing technical systems or tools.

• Strong analytical and problem-solving skills, with the ability to interpret complex datasets and model outputs.

• Strong knowledge of SQL, Excel, PowerPoint and SharePoint.

• An understanding of risk and value frameworks or decision analysis.

• Knowledge of asset information, data structures and systems such as GIS, EAM or asset registers.

Desirable experience

• Experience within a regulated industry, particularly utilities.

• Awareness of regulatory frameworks and business planning processes.

• Strong stakeholder engagement, influencing and communication skills.

• A proactive and solution-focused approach to complex challenges.

Advert Closes - Monday 28th September

Benefits:

• Salary from £54,000 dependant on skills and experience

• Learning and development opportunities, including mentoring and a range of formal courses and open learning resources.

• Entry into the company annual bonus scheme.

• Annual leave from 26-30 rising with length of service, and the option to purchase up to 5 extra days.

• A ‘Celebration Day’ in addition to public holidays that people can use to celebrate a religious festival or other occasion that is important to them.

• A generous 'double match pension scheme' that doubles the contributions you make (company contribution capped at 12%)

• We offer a range of family benefits including enhanced Maternity, Adoption, Paternity, Shared Parental Leave, Fertility Support Leave and up to 5 full or 10 half days of paid Carers Leave.

• Menopause policy and Reasonable Adjustment policy to help everyone perform at their best.

• Access to our Wellbeing Centre with support for looking after your physical and mental health.

• Discounts at a Range of Retail Outlets through our Tap4Perks scheme

• Discounts on Dental and Medical Insurance through our Tap4Perks scheme through salary sacrifice

• Up to 4 Affinity days a year to volunteer in the community.

• Life Assurance.

Disability Confident

As a Disability Confident employer, we’re committed to offering interviews to disabled candidates who meet the essential criteria and opt in on the application form. Ask the Talent Acquisition lead for the full job description to see all the criteria. If we have a very high volume of applicants and we’re not able to offer interviews to all, we’ll take a fair and proportionate number of disabled candidates through.

Affinity Water recognises the benefits of greater diversity in our workforce to better reflect the communities we serve. We are committed to building a more inclusive culture where every member of our workforce can thrive.

You can find out what it’s like to work at Affinity Water through our career site https://www.affinitywatercareers.co.uk/ where our colleagues share their career development stories and you can get a feel for our company culture.