Business Intelligence Analyst

Role Overview

Key Responsibilities

• Design and maintain Power BI reports, semantic models and scalable data models.
• Build DAX measures and Power Query transformations.
• Report on SLA/KPI performance, PPM, reactive maintenance, compliance, assets, costs and client performance.
• Consolidate and analyse CAFM and other operational-system data; maintain data quality, validation, governance and reporting standards.
• Serve as BI point of contact for allocated Hard Services contracts.
• Gather and translate stakeholder requirements, build relationships and explain complex data to non-technical audiences.
• Manage competing reporting priorities and identify trends, risks and improvement opportunities.

Essential Skills and Experience

• Facilities Management experience, ideally in Hard Services, and practical experience with CAFM systems and data.
• Understanding of FM operations and CAFM data for service delivery, performance, compliance and SLA/KPI reporting.
• Strong stakeholder management and communication skills.
• Strong Power BI report development experience; advanced DAX and Power Query (M).
• Experience with large datasets and multiple data sources; strong data modelling, dimensional modelling and semantic model design.
• Strong analytical, problem-solving and data-validation skills; able to manage priorities and work independently.

Desirable Skills

• Microsoft Fabric.
• Databricks or Azure Data Services; SQL; data warehousing and ETL/ELT.
• Row-Level Security; Power Automate or wider Microsoft Power Platform experience.

About OCS