Consumption Data Analyst

Circa £34,231 (depending on Skills & Experience) Permanent Full Time / 37 Hours (Flexible working opportunities available) Huntingdon or Peterborough - Hybrid Double Matched Pension Scheme (up to 21% combined) Private Healthcare Make every drop of your potential count! We're looking for a Demand Reporting Data Analyst to join Anglian Water's Strategic Asset Management team and help shape how consumption data is understood, reported and used across the business. Our smart meter estate is expected to grow to 2.3 million meters by 2030, creating a rapid increase in the volume, frequency and strategic value of water consumption data. As part of our central Consumption Data Team, you'll turn this information into compelling reporting and actionable insight that strengthen regulatory reporting, demand management, leakage understanding and long-term water efficiency. This is a hands-on data analyst role with real operational and environmental impact. You'll work with large, high-frequency datasets, combining analytical skills with a strong understanding of the business to create reports, dashboards and insights that improve how we understand household and non-household consumption. You'll work closely with stakeholders to identify opportunities, improve data quality and develop analytics products that support better decisions and our ambition to achieve world-leading water efficiency outcomes.

About Awg (Broadbean External)

At Anglian Water, data is central to how we secure resilient water supplies and support customers to use water more efficiently.

Responsibilities

• Work proactively with stakeholders to understand their reporting and analysis needs, identifying where analytics can add value to consumption reporting and business decisions.
• Keep stakeholders informed, agree clear expectations and manage the delivery of analytics products.
• Source relevant data using your stakeholder network, data catalogues and data architecture models, supporting improvements to data quality where needed.
• Cleanse, combine and analyse datasets using relevant analytical tools such as SQL, Power BI and Excel, applying an understanding of data modelling practices and reverse engineering existing models where required.
• Create compelling reports, dashboards and visuals, applying user experience principles to make complex consumption data understandable and useful.
• Explore and blend different data sources to identify trends, answer business questions and uncover opportunities, remaining impartial and guided by the evidence.
• Translate findings into clear insights and practical recommendations, using visual storytelling to support action and constructively challenge where needed.
• Work collaboratively with subject matter experts, reporting teams and multidisciplinary data colleagues, taking shared accountability for delivering business value.
• Maintain product information in relevant catalogues and regularly review analytics products with stakeholders, enhancing or retiring them as business needs change.
• Build a strong understanding of the business areas your products support, how stakeholders use them and where further improvements could add value.
• Identify opportunities to improve data management and quality assurance practices.
• Work within relevant standards, governance and analytics principles.
• Experience creating and communicating compelling data visuals using Power BI and Excel that align with business goals, inform decisions and drive action.
• An understanding of data modelling patterns and standards.
• Experience troubleshooting issues with datasets, identifying potential solutions and implementing improvements.
• You'll speak up when something isn't right and use a balanced mix of facts, opinions and experience to inform your decisions.
• You'll agree clear expectations about what you can achieve and when, take ownership of your commitments and flag early if delivery is at risk.
• You'll build rapport, seek to understand others and develop effective working relationships.
• You'll communicate clearly and concisely, avoiding unnecessary jargon.
• You'll take responsibility for your learning and career development, ask questions and remain curious.
• You'll try new ways of working and take calculated risks to drive improvements.
• You'll champion digital technology as a way to deliver positive change.

Requirements

• What we're looking for Demonstrable experience applying strong maths and IT skills to create analytics products.
• Experience with Excel formulas and some knowledge of SQL.
• Experience translating business needs into analytics opportunities and promoting and working within standards and governance.
• Excellent written and verbal communication skills, with the ability to adapt your approach to different audiences and turn data into clear insights.
• A logical, analytical approach, with the ability to cleanse and synthesise data into useful solutions.
• The ability to maintain a varied portfolio of analytics products and accept and build on feedback.
• Why join Anglian Water?

Preferred

• Experience working with meter reading, smart meters and time series data, recognising its suitability for different purposes and explaining this clearly to stakeholders.
• Experience contributing to a multidisciplinary data team.
• Strong influencing and business-partnering skills, including the confidence to constructively challenge requirements.
• Intermediate coding skills in relevant toolsets such as SQL, Python or DAX.
• In this role, you'll help unlock the value of one of the UK's fastest-growing smart meter datasets and directly influence how we understand demand, improve reporting and plan for the future.
• You'll gain exposure to complex, high-value data science challenges with clear regulatory, operational and environmental outcomes.
• Working alongside Data Engineers, reporting specialists and subject matter experts, you'll develop your capability across modelling, machine learning, data pipelines and applied water-sector analytics while helping establish sustainable in-house expertise.
• This is an opportunity to create data products that move beyond reporting to diagnostic and prescriptive insight, supporting better decisions across water resources, customer demand and leakage performance.

Benefits

• Benefits 26 days annual leave plus bank holidays (increasing with length of service)
• Flexible working options

Private health care

• Competitive pension scheme - Anglian Water double-matches contributions up to 7% Life assurance at eight times your salary
• Potential funded car allowance depending on evidenced business mileage
• Personal medical assessments

Virtual GP service

• Cancer screening Financial wellbeing support and salary finance benefits
• Lifestyle savings including discounts on retail, travel and utilities

Employee Assistance Programme Volunteer days

• Inclusion at Anglian Water We're committed to creating a workplace where everyone feels they belong.
• We are proud signatories of the Social Mobility Pledge, Race at Work Charter and Armed Forces Covenant, and we're a Disability Confident employer.

Closing Date

23/11/2026 #loveeverydrop #LI-ZP1