Consumption Data Analyst

Anglian Water Group; Huntingdon, Peterborough; Hybrid; GBP 34,000 - 36,000; Full time

Benefits offered by this job

Private healthcare

Hybrid working options

Pension scheme (double-match up to 7%)

26 days annual leave

Job summary

Anglian Water Group is seeking a Demand Reporting Data Analyst to join the Strategic Asset Management team in the UK. You will shape consumption data reporting, build dashboards and insights from high-frequency datasets, and work with stakeholders to improve data quality and analytics products that support water efficiency and regulatory reporting.

The role emphasizes hands-on data analysis with large datasets, visual storytelling, and collaboration across data colleagues to deliver actionable

Qualifications

• Demonstrable experience applying strong maths and IT skills to create analytics products.
• Experience with Excel formulas and some knowledge of SQL.
• Experience creating and communicating compelling data visuals using Power BI and Excel.
• An understanding of data modelling patterns and standards.
• Experience translating business needs into analytics opportunities and governance.

Responsibilities

• Work proactively with stakeholders to understand reporting and analysis needs and deliver analytics products.
• Source data using data catalogues and data architecture models; support data quality improvements.
• Cleanse, combine and analyse datasets using SQL, Power BI and Excel; apply data modelling concepts.
• Create reports, dashboards and visuals with user-centric design to make data actionable.
• Collaborate with subject matter experts and other data teams to maximise business value.

Skills

Data analysis

Reporting

Data storytelling

Stakeholder engagement

Tools

SQL

Power BI

Excel

Job description

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

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.

What you’ll be doing:

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.

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 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. 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. 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.

Desirable:

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.

Why join Anglian Water?

At Anglian Water, data is central to how we secure resilient water supplies and support customers to use water more efficiently. 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

• 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
• Annual bonus
• 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.

We are committed to reflect the diversity of the communities we serve in both our workforce and our supply chain partners to help us to understand and meet the needs of our customers.

We are passionate and dedicated to the learning and development of our people, making sure they have the right skills and knowledge to be successful and to help achieve their potential.

We want to give everyone equal access to our recruitment process.

If you have a disability or long-term condition, including neurodiversity and mental health conditions, we’ll support you throughout your application, and make any adjustments to make sure your disability or long-term condition is not a barrier to recruitment.

If you need any support, please get reach out to our team [e-mail]’

Closing Date: 23/11/2026 #loveeverydrop #LI-ZP1

More information about how we look after and use your information can be found in our Privacy Notice.

Become a part of Anglian Water’s future and join us on our journey as we live through our values to build trust, do the right thing, and are always exploring, to bring environmental and social prosperity to the region.