Business Intelligence Analyst

TN United Kingdom; United Kingdom; On-site; GBP 35,000 - 55,000; Full time

Job summary

Join a well-established Scottish business as a BI Analyst, where you will play a crucial role in data-driven decision making. This exciting position involves building Power BI dashboards, analyzing commercial data, and preparing insightful reports for senior management. You will collaborate with various teams to enhance internal reporting processes and support strategic initiatives. If you have a strong analytical mindset and a passion for uncovering insights from data, this role offers a unique opportunity to make a significant impact in a dynamic environment.

Benefits

Flexible working options

Competitive salary

Impactful role in a well-established business

Qualifications

• Degree in Business, Analytics, Economics, or Finance.
• Expertise in Power BI, including DAX and dashboard development.
• Experience in commercial analysis or FP&A roles.

Responsibilities

• Build and maintain Power BI dashboards for sales performance.
• Analyze commercial data to identify trends and opportunities.
• Prepare presentations and reports 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

Social network you want to login/join with:

Business Intelligence Analyst, United Kingdom

col-narrow-left

Client:

Location:

Job Category:

Other

-

EU work permit required:

Yes

col-narrow-right

Job Reference:

90a2d182a7ba

Job Views:

3

Posted:

10.05.2025

Expiry Date:

24.06.2025

col-wide

Job Description:

Job Title: BI Analyst
Location: Glasgow

Reports To: Commercial Director

About:

Our client has been producing in Scotland for over 75 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:

• 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 (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??)