Senior Data Analyst

Costain have won extensive work across the water sector this year to support the AMP 8 investment cycle.

We have been appointed by United Utilities as one of 7 partners to the Enterprise, delivering £5.5bn of projects in the Asset Management Period 8 (AMP8) between 2025 - 2030, and AMP 9 (2030 - 2035). Our scope is to provide project management, design, construction and commissioning services on design and build schemes throughout the North West and Cumbria region covered by United Utilities. Projects vary in value covering both infrastructure and non-infrastructure assets on water and wastewater sites with wider Enterprise partners

Responsibilities

• Oversee the creation and maintenance of comprehensive reports and dashboards for the UU AMP8 Framework, ensuring they align with strategic business and client goals
• This role is a mixture of data analyst and data engineer and requires the ability to bring data in from source, working with APIs, SQL databases etc., to create data pipelines, manipulate data sets and develop Power BI reporting and visualisation
• Incorporate advanced analytical/data techniques, including basic statistical modelling, into key reports as required to generate deeper insights
• Ensure all reporting and analytics adhere to data governance and security standards
• Collaborate closely with the Performance Team, wider Framework teams and senior leadership in the development of reporting requirements and to translate complex data insights into actionable business/client strategies
• Manage multiple deliverables/activities simultaneously, ensuring independent and timely delivery of high-quality results across different areas
• Engage with the broader Costain and Water Sector data and reporting functions to share knowledge, best practice, and utilise key skill sets as required to deliver required UU AMP8 Framework reporting
• Attendance in the Framework office (Costain Office Aviator Way) on a regular basis (minimum two days per week) and as required for key collaborative sessions with the team

Essential

• Ability to visualise data in an engaging and intuitive manner
• Expertise with Microsoft Power BI, DAX functional language and PowerQuery M language
• Expertise in data visualisation tools and advanced Excel techniques
• Advance expertise in programming languages such as DAX and Python
• Advance experience obtaining data from a variety of sources e.g. APIs, SQL servers
• Strategic thinking with the ability to align data insights with the boarder business objectives
• Strong problem-solving skills with the capability to address and resolve challenges outside their typical areas of expertise
• Strong knowledge of GDPR and its implications for data reporting, analysis and governance
• Excellent, and proven, communication and presentation skills, particularly with senior stakeholders

Desirable

• Leadership and team management skills, with the ability to inspire and guide a data team
• Experience with basic and advanced statistical methods
• Relevant qualification for example: Microsoft Certified: Power BI Data Analyst Associate (PL-300), Microsoft Certified: Fabric Data Engineer Associate (DP-700) or similar