FM BI Analyst: Power BI & CAFM Insights

OCS Group Limited; Mildenhall; On-site; GBP 42,000 - 64,000; Full time

Benefits offered by this job

Wagestream pay access

Digital learning

Employee discounts via Hapi app

Job summary

OCS UK & Ireland is seeking a Business Intelligence Analyst with strong Facilities Management experience to design, develop and maintain reporting and analytics solutions. You will combine Power BI expertise with FM operations knowledge to deliver actionable insights that support decision-making and client reporting.

You will work closely with Account Directors and senior stakeholders across multiple contracts, translating requirements into scalable data models and robust dashboards.

Qualifications

• Experience in Facilities Management, ideally Hard Services.
• Practical experience using CAFM systems and CAFM data.
• Strong 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.

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

Power BI reporting

DAX

Power Query (M)

Stakeholder management

FM operations knowledge

Data modelling

Data quality & governance

Analytical problem-solving

Tools

CAFM systems

Databricks

Azure Data Services

SQL

Microsoft Fabric

Job description

OCS UK & Ireland is seeking a Business Intelligence Analyst with strong Facilities Management experience to design, develop and maintain reporting and analytics solutions. You will combine Power BI expertise with FM operations knowledge to deliver actionable insights that support decision-making and client reporting.

You will work closely with Account Directors and senior stakeholders across multiple contracts, translating requirements into scalable data models and robust dashboards.