Power Platform Data and Insights Developer

We are seeking a Power Platform Data and Insights Developer to join the Asset and Information Management team within the Infrastructure division. This role will help our projects move beyond fragmented spreadsheets, disconnected reporting and static document stores by creating practical, user-focused solutions that improve visibility, control and decision-making across delivery teams.

The successful candidate will bring strong technical capability across Microsoft Power Platform and Power BI, with the ability to shape solution design from early-stage requirements through to deployment and adoption. They will work with project teams, information managers, digital leads, internal IT teams and wider stakeholders to influence data architecture and systems design decisions, ensuring that solutions are scalable, governed and aligned to project and business needs.

This role is intended to act as the lead for Power Platform, data and insights development within the team. It will provide direction across this capability area, act as the focal point for related solution development, and support the future growth of specialist resource as the function develops.

Your role

• Develop and maintain project-level digital solutions using Microsoft Power Platform, including Power Apps, Power Automate, Power Pages and Dataverse.
• Work with project and functional stakeholders to understand business problems and translate them into well-structured digital and data solutions.
• Contribute to data architecture and solution architecture decisions, helping projects design approaches that support reliable reporting, governance, usability and future scalability.
• Support the design of project system architectures where data, workflow, user interface and reporting requirements need to be brought together into a coherent solution.
• Design and build bespoke project interfaces and portals, including solutions that provide centralised access to signposting, news, files, reference information and control tables.
• Develop Dataverse-backed solutions that support structured data capture, workflow, permissions and integration across project processes.
• Create and maintain Power BI reporting suites, dashboards and analytical products that communicate meaningful trends, risks, status and performance.
• Work with users and stakeholders to develop reporting that is not only technically accurate but also tells a clear story from the data and supports decision-making.
• Help define data models, data preparation approaches and data quality requirements needed to support effective reporting and operational control.
• Promote good practice in solution design, governance, usability, supportability and documentation across the project environment.
• Provide advice and support to project teams on the use of Microsoft technologies for digital delivery, reporting and workflow automation.
• Work closely with internal IT and platform administration teams to identify, enable, maintain and improve the enterprise toolsets available to projects, contributing to governance, configuration, service development and the practical adoption of these technologies across the business.
• Act as the focal point for this capability area within the team, providing technical leadership, shaping delivery approaches and supporting the development of additional specialist resource where required.
• Contribute to continuous improvement by identifying repeatable patterns, reusable components and opportunities to standardise successful approaches across projects.

About You

• Strong practical experience of Microsoft Power Platform, including Power Apps, Power Automate, Power Pages and Dataverse.
• Strong practical experience in Power BI, including report development, dashboard design, data modelling and the communication of insights through effective visual storytelling.
• A clear understanding of how to structure solutions around user needs, business process, data design and governance rather than treating reporting as a standalone output.
• Confidence engaging with project teams and stakeholders to shape requirements, challenge assumptions and influence better data and system design decisions.
• Experience of developing bespoke digital solutions in complex project or operational environments, ideally within infrastructure, engineering, construction or other delivery-focused sectors.
• The ability to work across both front-end and back-end elements of solution development, including user interface design, workflow logic, data structures and reporting outputs.
• Confidence working with internal IT, digital and platform teams within an enterprise environment, and the ability to contribute constructively to administration, governance, service improvement and the long-term development of corporate toolsets.
• The credibility and leadership capability to act as the senior specialist in this area, with the potential to help build and develop a broader team over time.
• The ability to handle ambiguity and turn loosely defined project needs into practical, usable and well-governed solutions.
• Good awareness of information management, data governance and controlled project environments.
• Experience working alongside Information Management, BIM, document control, engineering data or project controls functions would be beneficial.
• Experience with SharePoint, Microsoft 365, structured control tables, project portals and integration of reporting with operational workflows would be beneficial.
• Experience of infrastructure project delivery environments and the practical realities of project data, assurance and stakeholder reporting would be beneficial.