Business Data Analyst

Job Title: Business Data Analyst

Function: CEO - Data & Digital Transformation

Location: Head Office, St Vincent Street, Glasgow - Hybrid Working (2 days per week in office)

Job Level: 4 (Internal Reference Only)

Contract: Full Time / Permanent - 35 Hours - Monday to Thursday – 08:30-17:00, Friday 08:30-13:30.

Role Reports to: Head of Digital & Data Transformation

Date vacancy will close: 5pm, Friday 27th February 2026. Where we receive high numbers of applications we may close vacancies early. If you think this is the right opportunity for you please don't delay in applying!

Who we are

Born in Glasgow, made in Scotland and enjoyed around the world. Whyte and Mackay is home to a collection of multi-award-winning global whisky brands led by The Dalmore, Fettercairn, Jura and Tamnavulin. Our mission is to be a driving force in whisky, renowned for building brands that stand-out. Enabled by our brilliant community of 750 colleagues, reaching across 17 countries and counting. We're led by our values, continuing to grow and invest and looking for great talent to join our brilliant community. Ready to hear more?

What the opportunity looks like

As a Business Data Analyst, you will play a pivotal role in transforming data into reporting and BI solutions, enabling actionable insights that support strategic decision-making across the business.

You will work closely with stakeholders from all functions to understand data needs, develop reporting and analytical solutions that adhere to data quality and governance standards.

You will act as an advocate for data fluency across the organisation, supporting training and capability‑building initiatives. This role is key to enabling a data‑driven culture at Whyte and Mackay.

Responsibilities

• Independently develop and maintain high‑quality dashboards, reports and visualisations in Power BI and Excel to provide consistent, reliable insights to business users.
• Translate business requirements into clear reporting specifications and data models that enable effective decision‑making across all stakeholder levels.
• Proactively improve reporting workflows, dataset structures and visualisation approaches to enhance usability, efficiency and data quality.
• Contribute to enterprise projects by delivering BI outputs and ensuring new solutions integrate seamlessly into existing reporting environments.
• Prepare, structure and model data from multiple sources to ensure clean, well‑organised datasets that support accurate reporting and downstream analysis.
• Support the enhancement of data platforms, semantic models and data pipelines to strengthen the organisation’s BI and reporting infrastructure.
• Monitor and resolve data quality issues in consultation with data owners, ensuring trusted inputs for reports, dashboards and analytical activities.

Skills and experience that will help you be a success

For this role we're looking for:

• Substantial Experience in reporting, business intelligence or data analysis, with a strong focus on preparing, modelling and visualising data for end users.
• Expert proficiency in Power BI and Excel, with solid understanding of reporting best practices, dashboard design and performance optimisation.
• Good working knowledge of SQL and DAX; ideally some familiarity with Python or VBA for data preparation and automation.
• Awareness of data privacy, compliance and governance standards, with the ability to apply them to reporting environments and dataset management.
• Strong business acumen and the ability to translate complex business needs into practical, high‑quality reporting solutions.
• Ability to manage multiple priorities, operate independently, and deliver results in a fast‑paced, changing environment.
• Collaborative team player with strong communication skills and the ability to support data literacy and self‑service reporting across the organisation.
• Must have current full right to work in the UK.

Why join us

We offer a competitive salary, bonus package, life assurance, competitive pension, excellent product allowance, 35 days annual leave, plus enhanced family friendly policies. Our Rewards & Benefits page has further information.

Our application process

If you like what you’ve read and want to explore this opportunity further, please apply before the closing date listed at the top of the advert.

Our team read each and every application, therefore you'll hear back from us in due course.

Candidate guidance on the use of AI in the application and screening process can be found on our career site.

Should you require any adjustments to our recruitment process to help you be at your best then please contact us at HRTeam@whyteandmackay.com and we'll do what we can to support.

#J-18808-Ljbffr