The organisation is a major public-sector water utility implementing a corporate data strategy to improve governance, reporting and automation across operational and business processes. This role combines senior data consultancy and solution architecture, focusing on data modelling, data architecture, ETL and Power BI reporting to support a multi-year IT transformation and SAP S/4 HANA migration.
The mission
You will join a cross-functional programme governed by the Data Manager and the IT department to scale the organisation's data capabilities. The programme covers data governance, data lineage, integrated reporting and automation for operational teams and business units, with PMO oversight of multiple initiatives and a planning horizon of roughly two years.
On a day-to-day basis you will define business data solutions and the technical architecture that delivers them, work alongside process owners using BPMN to link processes to data lineage, and coordinate reporting automation projects. You will act as the interface between business, IT and external suppliers, prioritise reporting developments for Power BI and SAP-based sources, and ensure solutions comply with GDPR, ISO27001 and NIS2.
Your responsibilities
- Define and deliver business data solutions that turn process models and requirements into scalable data architecture and ETL pipelines, measured by reduction in manual reporting effort and improved data quality.
- Lead data governance and PMO activities for governance initiatives, establishing data ownership, data lineage and acceptance criteria across departments.
- Design and prioritise integrated reporting, coordinating IT and business stakeholders to implement Power BI solutions fed from ETL, SQL stores and data cubes.
- Translate BPMN process descriptions into data models and metadata, ensuring traceability from business process to data element and report.
- Drive change management and training to embed data rules and a data-aware culture in business teams, monitored through adoption metrics and fewer data incidents.
- Oversee test management and quality assurance for reporting and data integration workstreams, including SAP ECC6 and SAP S/4 HANA source validations.
Your profile
Essential skills
- Proven experience as a senior data consultant or solution architect, able to define business data solutions and lead architecture design.
- Strong data modelling and data architecture skills, including data lineage and metadata management.
- Hands-on knowledge of ETL processes, SQL, data storage patterns and data cubes used for integrated reporting.
- Experience with Power BI for enterprise reporting and with SAP ECC6 or SAP S/4 HANA as reporting sources.
- Familiarity with BPMN to map processes to data flows and with IT transformation projects and ITIL practices.
- Solid experience in change management and test management for data and reporting programmes.
Languages
- English, C1
Education
- Degree in computer science, information systems, engineering or equivalent practical experience