Job Title: Data & Analytics Analyst
Location: Glasgow Head Office
Salary: Competitive Salary
Job Purpose:
To provide the analytical insight that underpins our clients' asset replacement and capital expenditure programmes Combining strong data skills with practical engineering and facilities management knowledge, the Data & Analytics Analyst will investigate maintenance activity across the estate to identify trends, patterns, and areas of high spend; establish root cause for outlying assets, sites, and disciplines; and quantify the associated costs to produce clear, actionable recommendations for the client
The role is investigative by nature: interrogating asset- and estate-level data to surface cost-saving and cost-avoidance opportunities and translating findings into evidence that supports investment decisions The post holder will also manage relationships with senior client stakeholders, presenting analysis and recommendations with credibility and clarity
Principal Accountabilities:
- Drive innovation and continuous improvement within the Data Insights team
- Apply technical facilities management and engineering knowledge to investigate current maintenance provisions from all angles, identifying cost-saving and cost-avoidance opportunities and recommending specification changes or enhancements
- Work with discipline subject matter experts and other internal stakeholders to strengthen the evidence base for capital replacement submissions
- Use business intelligence tools to identify and investigate root causes of spend and performance outliers by asset type, across both City internal resource and contractor delivery
- Advise on and support the client's asset specifications, providing analysis to inform purchasing decisions
- Deliver across a broad range of outputs, from building Power BI dashboards from scratch to maintaining Excel-based tools and producing reports and summaries in PowerPoint and Word for internal and external audiences
- Apply appropriate data visualisation techniques to develop business intelligence tools, such as interactive dashboards, that give colleagues accurate, timely, and actionable insight into repairs and maintenance services and demand
- Work with internal stakeholders to develop and enhance BI and life cycle costing (LCC) analysis and reporting tools
- Use the corporate Life Cycle Costing model to inform investment priorities for asset replacement programmes
- Represent the company professionally at all times and build effective working relationships with key City and client colleagues
- Undertake training as required and keep personal skills current with technical developments
- Comply with the company Health and Safety Policy at all times
- Work with City and client colleagues to ensure agreed standards of quality are maintained at all times
- Undertake any other reasonable duties as requested by the Line Manager
Key Result Areas:
- Deliver data-led cost savings through the interrogation and modelling of client data
- Deliver robust, evidential data to support annual business plan submissions
- Deliver analysis and recommendations that improve asset availability and reduce maintenance costs
Essential Requirements:
- Flexibility in both availability and task management
- Experience of fast-paced retail environments, with an understanding of retailer needs in relation to FM and the importance of data
- SQL analysis skills
- Advanced Excel skills, including in-depth knowledge of complex formulas and data analytics
- High proficiency in Microsoft Power BI, with the ability to build complex reporting modules from new and existing client datasets
- Senior-level relationship management experience
- A track record of presenting to senior client stakeholders
- Excellent report-writing skills
- Experience of monitoring KPIs
- Experience of working collaboratively with internal and external teams and partners
Key Performance Indicators:
- Performance outputs as agreed from time to time
Person Specification: Criteria Essential Desirable General Education Standard Grade level with vocational qualifications in English and Mathematics
Advanced Grade level in a numerate discipline
HND level in engineering, science, or mathematics Degree level in engineering, science, or mathematics
Professional / Academic / Vocational Qualifications Refrigeration, HVAC, electrical, or building services qualification; or
Further education in engineering, science, or mathematics Business insight qualification
Specific Knowledge Building services
Data management and manipulation
Data analysis, report writing, and data querying techniques Retail maintenance
Use of life cycle costing (LCC) models
Specific Skills Highly PC literate
Experience of Power BI or similar applications
Ability to manage time and prioritise workload
Strong organisational skills
Report writing
Demonstrated Behaviours Excellent verbal, written, and presentation skills at all levels
Helpful, approachable manner
Strong analytical ability with sound knowledge of analytical processes
Inquisitive, investigative outlook
Logical approach to problem solving
Ability to provide clear, well-evidenced recommendations
Self-motivated
Specialist Requirements Willingness to undertake business travel
