Business Intelligence Analyst

In Technology Group; Glasgow; On-site; GBP 35,000 - 40,000; Full time

Job summary

An established industry player is seeking a BI Analyst to enhance their data-driven decision-making processes. In this pivotal role, you will develop and manage Power BI dashboards, providing essential insights that drive strategic initiatives. Collaborating closely with various departments, you will transform complex data into clear narratives for board-level presentations. This is an exciting opportunity to make a significant impact in a well-respected Scottish business, contributing to their growth and innovation journey.

Benefits

Flexible working options

Competitive salary

Impactful role in a well-established business

Qualifications

• Degree in Business, Analytics, Economics, Finance, or related discipline.
• Expertise in Power BI, including DAX and Power Query.

Responsibilities

• Build and maintain Power BI dashboards for sales performance.
• Prepare insightful presentations for senior management.

Skills

Power BI

DAX

Power Query

Advanced Excel

SQL

Commercial Analysis

Education

Degree in Business

Degree in Analytics

Degree in Economics

Degree in Finance

Tools

ERP Systems

CRM Systems

Job description

Job Title: BI Analyst

Location: Glasgow

Reports To: Commercial Director

Salary: £35,000 – 40,000 D.O.E

About:

Our client been producing for Scotland for over 50 years. As a small private business based in Glasgow, they combine generations of tradition with a commitment to continuous improvement and innovation. Supplying a wide range of products to major retailers, foodservice providers, and independent businesses across the country, they take pride in their craft and the people who make it possible.

They’re now looking for a BI Analyst to help take the next step in their growth journey. This role will support the business through data-led decision making, smart reporting, and clear commercial insight — playing a key role in everything from sales performance tracking to board-level reporting.

Role Summary:

This is a highly analytical, data-focused role within our commercial team. You’ll be responsible for building and managing Power BI dashboards, developing commercial reports, and supporting the leadership team with insights that help steer business decisions. You’ll work closely with colleagues across Sales, Finance, and Operations, and have the opportunity to shape how data is used throughout the business — with direct input into board-level presentations and strategic planning.

Key Responsibilities:

Sales & Commercial Analytics:

• Build and maintain Power BI dashboards to report on sales performance, customer trends, product mix, and commercial KPIs.
• Analyse commercial data to identify trends, opportunities, and challenges across different channels and customer types.
• Support forecasting, pricing reviews, and margin analysis with accurate, well-structured data sets.
• Monitor and interpret performance at both high-level and granular detail (e.g. customer-level profitability, SKU performance, regional trends).

Board-Level & Strategic Reporting:

• Prepare professional, insightful presentations and reports for senior management and board meetings.
• Turn complex data into clear commercial storytelling to support strategic initiatives and business reviews.
• Work closely with the Commercial Director and other senior leaders to ensure reports are aligned with business goals.

Business Collaboration & Support:

• Collaborate with Sales, Finance and Production teams to gather and validate key data inputs.
• Help improve internal reporting processes, ensuring data is accurate, timely, and actionable.
• Provide ad hoc analysis to support decision-making across product development, customer engagement, and operations.

What You’ll Bring:

• Degree in Business, Analytics, Economics, Finance, or a related discipline.
• Expertise in Power BI, including DAX, Power Query, and dashboard/report development from scratch.
• Advanced Excel skills; knowledge of SQL or ERP/CRM systems
• Experience in a commercial, sales analysis, or FP&A role — ideally within manufacturing or FMCG.
• Strong attention to detail and a knack for uncovering meaningful insights in complex data.
• Confidence in presenting findings and recommendations to senior stakeholders.

Nice to Have:

• Previous experience in the food and drink or manufacturing sector.
• Understanding of commercial drivers like gross margin, customer profitability, and forecasting.
• Familiarity with reporting needs specific to a family-owned or SME environment.

What We Offer:

• The opportunity to make a real impact in a well-established Scottish business.
• Direct involvement in shaping how data is used across commercial operations.
• Competitive salary (depending on experience), plus benefits (and flexible working options??)