Business Intelligence Analyst

Our client has been producing in 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:

• 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).