Data Analyst in Oxford

Location - Oxford

Working Location Category Onsite

About Us

Macro is a recognised global specialist in facilities management, providing cutting-edge services to some of the most prominent brands offering workplace design, helpdesk services, interim property management, and providing solutions to making buildings healthier, smarter and sustainable by using advanced technological solutions.

We are driven by a commitment to excellence in everything we do. Our values—Drive for Better, Delight Customers, Do What’s Right, and Develop People—shape our culture and guide our decision-making. Our strategic priorities focus on Everyday Excellence, Outstanding Experience, and Everlasting Impact.

Join our team to contribute to an organisation that prioritises innovation and technology. Experience the perfect blend of opportunity and community, where you will benefit from a supportive and people-focused culture.

About the Role

The Technical Data Analyst will be based within the client’s Central Control Centre and will work alongside the Technical Manager, Technical Leads and Technical Coordinators to provide accurate, timely and commercially focused analysis across the contract.

The role will monitor Macro KPIs, supplier performance, planned and reactive maintenance activity, BMS alarms, asset information, CAPEX and OPEX expenditure. The postholder will convert operational and financial data into clear insight, identifying trends, exceptions, recurring issues and opportunities for improved performance, cost efficiency and service delivery.

A key requirement of the role is to continually probe established practices and challenge the norm. Using evidence from work orders, BMS alarms, asset history, supplier performance and expenditure, the Technical Data Analyst will test whether activity is delivering the intended outcome and recommend better, more efficient or more predictive ways of working.

Main Responsibilities

• Monitor, analyse and report directly on Macro contractual KPIs, ensuring performance data is accurate, traceable and issued within agreed reporting deadlines.
• Produce clear KPI dashboards showing current performance, trends, exceptions, risks and required management actions.
• Drive local management teams in monitoring supplier performance through financial, operational and KPI analysis.
• Analyse supplier response, attendance, completion, first-time fix, repeat failure, quotation turnaround, overdue work orders and closure quality.
• Identify underperformance against contractual SLAs and support the Technical Manager and local management team with evidence-based recovery actions.
• Produce monthly client reports and ad hoc analysis covering planned maintenance, reactive activity, BMS work orders, CAPEX and OPEX expenditure.
• Provide concise commentary that explains the operational and financial meaning behind the data, rather than reporting figures in isolation.
• Analyse trends and provide recommendations for continuous improvement for consideration by the Account Manager and Technical Manager.
• Continually probe recurring issues and accepted ways of working to determine whether a safer, faster, more reliable or more cost-effective approach is available.
• Undertake trend analysis of reactive work orders, including asset type, site, failure mode, priority, response time, repair time, cost, repeat visits and root cause.
• Undertake trend analysis of BMS alarms and associated work orders, including alarm frequency, duration, recurrence, escalation, response, closure and avoidable callouts.
• Correlate BMS information with asset data, planned maintenance history and reactive events to identify developing failures, nuisance alarms and predictive maintenance opportunities.
• Trend and assess asset data, including condition, criticality, failure history, maintenance cost, remaining life and replacement risk, to support lifecycle and investment decisions.
• Maintain the integrity of the master service cost and service frequency file that drives the supply chain spend matrix.
• Control changes to service frequencies, asset quantities, rates and supplier costs, preserving an auditable record of assumptions, approvals and revisions.
• Reconcile source data across CAFM, BMS, finance and supplier records, investigating inconsistencies and improving data completeness and accuracy.
• Assist in the production of revenue and capital expenditure budgets, forecasts, accruals and monthly variance commentary as required.
• Monitor actual and committed CAPEX and OPEX expenditure against budget and forecast, highlighting emerging risks, cost pressures and underspend opportunities.
• Develop cost-efficiency initiatives through data insight, including reduction of repeat callouts, optimisation of service frequencies, improved first-time fix and better use of condition or alarm-based maintenance.
• Quantify the potential benefit, cost, risk and payback of improvement opportunities so that recommendations can be prioritised objectively.
• Support business cases for asset replacement, maintenance strategy changes, supplier interventions and technical improvement projects using robust data and clearly stated assumptions.
• Develop and maintain standard reporting packs, dashboards, data definitions and calculation methodologies to ensure consistent reporting across the contract.
• Work closely with the Technical Manager, Technical Leads, Coordinators, helpdesk, finance teams and service partners to validate findings and drive agreed actions.
• Maintain action trackers for agreed data-led improvements and report whether implemented actions have delivered the expected operational or financial benefit.
• Present analytical findings in a clear, practical and client-friendly format for operational reviews, monthly meetings and contract governance forums.
• Handle operational, commercial and client information in accordance with applicable information security, confidentiality and data-governance requirements.

About You

The ideal candidate will have:

Essential

• Demonstrable experience in data analysis, performance reporting, commercial analysis or management information within facilities management, engineering, property, manufacturing or a comparable operational environment.
• Strong analytical skills with the ability to interrogate large datasets, identify trends and exceptions, test assumptions and translate findings into practical recommendations.
• Understanding of the basic fundamentals of HVAC systems.
• Understanding of facilities and building engineering services management.
• Advanced Microsoft Excel capability, including PivotTables, XLOOKUP, SUMIFS, conditional formatting, data validation, charts and structured data models.
• Experience producing dashboards and automated management reports using Microsoft Power BI or a comparable business intelligence platform.
• Experience analysing operational KPIs, supplier SLAs, work-order performance and financial data.
• Understanding of planned and reactive maintenance workflows, including response, attendance, repair, completion and closure stages.
• Ability to analyse CAPEX and OPEX expenditure, support budgeting and forecasting, and explain variances clearly.
• High level of data accuracy, attention to detail and confidence reconciling information from multiple systems.
• Ability to communicate analytical findings clearly to technical, commercial and non-technical stakeholders.
• Curious and improvement-focused approach, with the confidence to challenge established practices using evidence.
• Strong organisational skills and the ability to manage recurring reporting deadlines alongside ad hoc analytical requests.

Desirable

• Qualification in data analytics, business analytics, finance, engineering, building services, facilities management or a related discipline.
• Experience using CAFM, CMMS or enterprise asset-management systems such as SAP EAM, together with BMS alarm or trend data.
• Experience with Microsoft Power Query, Power Pivot, DAX, SQL or comparable data-transformation and query tools.
• Knowledge of asset registers, planned maintenance frequencies, lifecycle planning and maintenance cost modelling.
• Experience maintaining cost models, supply-chain spend matrices or master service cost files.
• Understanding of facilities-management contract structures, performance deductions, open-book reporting or supplier commercial models.
• Experience within automotive, manufacturing, critical environments or a complex multi-site estate.
• Awareness of data protection, information security and recognised data-governance principles.

Diversity Statement

We want to create a workplace where everyone feels safe to bring their whole selves to work. We recognise that every individual has different needs. This is Me is Macro’s EDI campaign, a commitment to understanding and supporting those needs, both professionally and personally.

Our aim is to help identify and acknowledge individual needs that may impact work-life experience. It’s about being proactive, learning from one another, and creating a supportive space that encourages growth and productivity.

Should you need to discuss any reasonable adjustments or require guidance about our recruitment process, please contact careers@macro-group.com to speak to a member of our team.