Business Intelligence Analyst

Responsibilities:

• Design, build and maintain accessible Power BI reports, dashboards and reporting outputs for corporate impact KPIs

• Develop robust Power Query transformations, semantic data models, relationships, calculations and DAX measures

• Clean, process and model quantitative and qualitative data from multiple sources, including survey responses and stakeholder feedback

• Develop data-quality checks, validation rules, exception reporting and reconciliations to improve accuracy, completeness and consistency

• Apply agreed KPI definitions, calculation logic, metadata, ownership and governance controls within reporting solutions

• Integrate reporting processes with SharePoint, Teams, Microsoft Forms and Power Automate, supporting automation of repeatable reporting activities

• Work with the Business Analyst and stakeholders to understand reporting questions, translate requirements into useful visualisations and iterate solutions through feedback

• Support testing, deployment, access management, refresh monitoring, issue resolution and transition into business-as-usual support

• Produce clear technical documentation, data dictionaries, report specifications, test evidence, user guidance and handover materials

• Contribute analytical evidence to the stakeholder and organisational engagement data discovery and future investment roadmap

Requirements:

• Minimum 4-5 years of relevant experience developing Power BI solutions, including Power Query, DAX, data modelling and visualisation

• Experience connecting and preparing data from SharePoint and Microsoft 365 sources, and working with Teams, Microsoft Forms and Power Automate

• Experience cleaning, processing and modelling a range of quantitative and qualitative data, including survey responses

• Practical understanding of data governance, data quality assurance, validation, reconciliation and controlled reporting

• Ability to analyse business processes and translate stakeholder needs into clear, usable reporting and insight products

• Strong stakeholder management, communication, problem-solving and technical documentation skills

• Experience developing, testing, deploying and supporting repeatable reporting solutions rather than producing one-off dashboards

• Fluent English

Nice to have:

• Experience supporting global operational functions or working in a large, matrix organisation

• Corporate performance, impact, compliance, assurance or audit reporting experience

• Estates or facilities reporting experience

• Reporting automation design and integration across the Microsoft Power Platform

• Power BI optimisation, performance tuning and refactoring of existing reports and models

Offer:

• Constant support of dedicated consultant

• Employee referral program