Data Analyst

The Anglian Water Strategic Pipeline Alliance (SPA) project currently involves the planning, design and construction of circa 320km of new strategic, large diameter, clean water interconnector pipelines and associated infrastructure across Anglian Water’s region. The SPA Alliance is also taking on responsibility for the future interconnector pipelines, a further 260km of strategic interconnector pipelines and associated infrastructure.

The Data Analyst is responsible for providing data analysis support to the SPA PMO team. They will collect, review the quality of, and analyse project, programme and performance data on a monthly basis as well as undertake ad‑hoc data analysis projects within the team. A key responsibility is to assist the team in improving the visibility and communication of information by maintaining dashboards and reports in Power BI.

The role is hybrid, with 1‑2 days per week in the Peterborough office and the rest working from home.

At Costain, we believe diverse perspectives drive innovation. If you’re passionate about making a positive impact and think you can bring value to our team, we’d love to hear from you—even if you don’t tick every box. Your unique skills and experiences could be exactly what we need.

• 
  
• Identify sources of information to support improved reporting within the @one Alliance.
  
• Work with members of the @one Digital Team to understand data requirements and advise on opportunities to improve data collection.
  
• Review the quality of current data sources and recommend improvements or alternative sources.
  
• Work closely with the performance team for alignment into the reporting hub.
  
• Act as the data analysis expert within the @one Digital Team, enabling enhanced understanding of data and performance in the business.
  
• Advise on improvement of current data analysis activities within the team, developing existing and new data analysis tools as required.
  
• Ensure that data analysis is carried out consistently across the @one Digital Team, identifying and promoting best practice.
  
• Provide dashboard and report creation, modification and management support to the @one Digital Team.
  
• Advise the @one Digital Team on the layout and functionality of dashboards to maximise the value and clarity of reported data.
  
• Support the migration of existing dashboards and reports to preferred platforms such as Power BI and Excel.
  
• Drive a culture of continuous improvement in Health & Safety (H&S), ensuring consistent H&S standards are maintained.
  
• Ensure completion of a full H&S induction in accordance with company policies, procedures, standards & guidance.
  
• Ensure adherence to safe working practices including completing audits in line with the schedule.
  
• Monitor and maintain compliance with the Working Time Directive.
  
• Ensure compliance with mandatory safety monitoring equipment, near‑miss reporting and other company procedures.
  
• Maintain H&S standards to enable a zero‑accident culture.
  
• Actively work with your team, line manager, and the H&S Team to improve H&S procedures where possible.
  
• Report all near misses through the appropriate channel to prevent future accidents.
  

• 
  
• Experience in data collection, data quality and data analysis.
  
• Experience of creating data reports and dashboards.
  
• Experience building dashboards and reports in Power BI.
  
• Experience building queries within SQL programming language.
  
• Data analysis and interpretation skills.
  
• Data visualisation skills.
  
• Ability to take responsibility and accountability for own tasks.
  
• Keen and willing to learn and develop.
  

• 
  
• Strong IT skills, especially MS Excel at an advanced level.
  
• Full UK Driving Licence.