Business Intelligence Analyst

Lightbody of Hamilton, Scotland, United Kingdom | IT | Full-time


This is a fantastic opportunity to join our Group IT Team based within our Hamilton site.

Job Purpose

The Business Intelligence Analyst will support team initiatives that deliver comprehensive data reporting to all levels of Finsbury Food Group.

Taking into account the quality, integrity and compliance of data across the sites the incumbent will assist in the implementation of MS Power BI tools and strategies that will help the organisation to achieve its longer-term ambitions.


Role Key Accountabilities 

In this strategic position, you will also share responsibility for the processing and management of Master data.

You will be working closely with Operations, Sales, Purchasing, Finance, Technical and other business functions to ensure Master data readiness and compliance.

Your Main Duties include:

  • Support global business analytics strategy by contributing to execution of critical data reporting and analysis activities that align to business needs.
  • Maintain Microsoft Power BI and provide bespoke reporting support for end users
  • Carry out successful and error free database programming and deployment of IT development projects, data and reporting.
  • Provide estimates and agree schedules within a framework for report delivery with business users
  • Maintain database documentation, including standards, procedures and definitions for the data dictionary (metadata).
  • Actively involved in master data setups, validations and periodic maintenance of information in the master data template.
  • Work closely with various business functional teams to resolve master data issues as needed while ensuring compliance and consistency of master data across business systems

Knowledge, Skills & Experience

Previous experience: 

  • Hands-on Power BI development role (1-2 years)
  • Ability to develop collaborative relationships with customers and stakeholders
  • Strong technical background in Business Intelligence, Data Warehouse, or SQL Server development.
  • Experience of the Microsoft SQL Server BI stack, including T-SQL, SSIS, and ETL.
  • Able to summarise and provide clear written communications and materials
  • Demonstrable interpersonal, analytical and problem-solving skills
  • Practical, output driven hands-on approach to programming
  • Ability to analyse options to best determine solutions independently

Hands-on Experience:

  • T-SQL including the use of stored procedures, functions, tables, triggers and views
  • Troubleshooting and optimising databases and queries
  • Maintaining and programming in Power BI, SSIS, SSRS and SSAS
  • Power BI Dashboard solutions – developed, maintained and supported the creation of dashboard panels, their data and filters therein


  • Cloud based implementations - Azure, SSAS Exposure to M3 and/or DBA2