> Markdown version of [/jobs/ext/4076383-business-intelligence-analyst](https://www.wearedevelopers.com/jobs/ext/4076383-business-intelligence-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Business Intelligence Analyst - **Company:** OCS Group Limited - **Location:** Ipswich, UK - **Contract:** Permanent contract - **Skills:** Adaptable Database Systems, Business Analytics Applications, Big Data, Computer-Aided Facility Management, Extract Transform Load (ETL), Data Warehousing, Power BI, SQL Databases, Microsoft Power Automate, Azure Data Factory, Powerquery, Microsoft Fabric, Operational Systems, Databricks - **Published:** October 27, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=38224a104d9bc9a7 ## About the Role 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. ## Description 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., * 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.