Business Intelligence Analyst

Role Overview

We are looking for a Business Intelligence Analyst with strong Facilities Management experience and knowledge of CAFM systems to design, develop and maintain reporting and analytics solutions that support our operational teams.

The role combines Power BI and analytical capability with a strong understanding of FM operations. You will work closely with Account Directors, operational teams and senior stakeholders across multiple contracts, translating business requirements into meaningful reporting and insight.

The role will be responsible for transforming complex data into actionable insights that improve decision-making, service performance and client reporting.

Key Responsibilities

• Design, develop and maintain Power BI reports and semantic models.
• Design and maintain scalable data models, including relationships, dimensional structures and reusable semantic layers.
• Build DAX measures and Power Query transformations to support accurate and efficient reporting.
• Develop reporting across SLA/KPI performance, PPM, reactive maintenance, compliance, assets, costs and client performance.
• Consolidate and analyse data from CAFM and other operational systems.
• Maintain strong data quality, validation, governance and reporting standards.
• Act as the BI point of contact for allocated Hard Services contracts.
• Gather, challenge and translate stakeholder requirements into effective reporting solutions.
• Build strong relationships with Account Directors, operational teams and senior stakeholders.
• Present complex data and issues clearly to non-technical audiences.
• Manage multiple reporting priorities across different contracts.
• Identify trends, performance risks and opportunities for improvement.

Skills and Experience

Essential

• Experience working within Facilities Management, ideally Hard Services.
• Practical experience using CAFM systems and CAFM data.
• Good understanding of FM operational processes and how CAFM data supports service delivery, performance, compliance and SLA/KPI reporting.
• Strong stakeholder management and communication skills.
• Strong experience developing reports using Power BI.
• Advanced knowledge of DAX and Power Query (M).
• Experience working with large datasets and multiple data sources.
• Strong data modelling capability, including relationships, dimensional modelling and semantic model design.
• Strong analytical, problem-solving and data-validation skills.
• Ability to manage competing priorities and work independently.

Desirable

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

OCS UK & Ireland is a leading facilities management company with 50,000+ colleagues and a turnover in excess of £2bn. We deliver innovative, award-winning services within facilities management, hard services, cleaning, security and catering.

Our mission is to make people and places the best they can be for our colleagues, customers and the communities we serve. Our commitment to doing business the right way is rooted in our TRUE values - Trust, Respect, Unity, and Empowerment.

Why Work for OCS?

✅Award-Winning Employer: Ranked 36th on Glassdoor’s Best Companies to Work For 2025 — we value and motivate our people.

🚀Digital Learning: The OCS Academy offers digital courses and resources to help you build skills and grow your career.

🙂 Retail Perks With our Hapi app, you can gain access to exclusive discounts, rewards and wellbeing resources.

📝Professional Growth: 600+ live learners across UK&I — Empowering colleagues with further development and qualifications!

💰Flexible Pay: Access a portion of earned wages before payday with our Wagestream App! (Contract Specific)