At a Glance
- Tasks: Transform data into actionable insights and develop high-quality dashboards using Power BI and Excel.
- Company: Join Whyte and Mackay, a leading whisky brand with a vibrant community.
- Benefits: Enjoy competitive salary, bonus, 35 days leave, and family-friendly policies.
- Other info: Hybrid working model with opportunities for professional growth.
- Why this job: Be a key player in fostering a data-driven culture and making impactful decisions.
- Qualifications: Experience in data analysis, proficiency in Power BI, and strong communication skills.
The predicted salary is between 28800 - 48000 £ per year.
Location: Head Office, St Vincent Street, Glasgow - Hybrid Working (2 days per week in office)
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.
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:
- 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.
Business Data Analyst in Glasgow employer: Whyte & Mackay
Whyte and Mackay is an exceptional employer, offering a vibrant work culture that champions innovation and collaboration in the heart of Glasgow. With a strong commitment to employee growth, we provide extensive training opportunities and a supportive environment that encourages data fluency and strategic decision-making. Our competitive benefits package, including generous annual leave and family-friendly policies, ensures that our team members feel valued and empowered to thrive both personally and professionally.
StudySmarter Expert Advice🤫
We think this is how you could land Business Data Analyst in Glasgow
✨Tip Number 1
Network like a pro! Reach out to current employees at Whyte and Mackay on LinkedIn. A friendly chat can give you insider info and maybe even a referral, which can really boost your chances.
✨Tip Number 2
Prepare for the interview by brushing up on your Power BI and Excel skills. Be ready to showcase your ability to create dashboards and reports, as this is key for the Business Data Analyst role.
✨Tip Number 3
Show off your data storytelling skills! During interviews, explain how you've turned complex data into actionable insights in the past. This will demonstrate your value to the team.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our community.
We think you need these skills to ace Business Data Analyst in Glasgow
Some tips for your application 🫡
Tailor Your Application:Make sure to customise your CV and cover letter to highlight your experience with data analysis and reporting. We want to see how your skills align with the role of Business Data Analyst, so don’t hold back on showcasing your Power BI and Excel expertise!
Showcase Your Achievements:When detailing your past experiences, focus on specific projects or achievements that demonstrate your ability to transform data into actionable insights. We love seeing quantifiable results, so if you improved a reporting process or created a dashboard that made a difference, let us know!
Keep It Clear and Concise:We appreciate clarity! Make sure your application is easy to read and straight to the point. Use bullet points where possible and avoid jargon unless it’s relevant to the role. Remember, we’re looking for someone who can communicate complex data in a simple way.
Apply Through Our Website:Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it helps us keep track of all applications efficiently. So, what are you waiting for? Get applying!
How to prepare for a job interview at Whyte & Mackay
✨Know Your Data Tools
Make sure you brush up on your Power BI and Excel skills before the interview. Be ready to discuss specific projects where you've used these tools to create dashboards or reports, as this will show your practical experience and expertise.
✨Understand the Business Context
Familiarise yourself with Whyte and Mackay's brands and their market position. Being able to relate your data analysis skills to their business goals will demonstrate your understanding of how data drives decision-making in a whisky company.
✨Prepare for Scenario Questions
Expect questions that ask you to solve hypothetical data challenges. Think about how you would approach translating business requirements into reporting specifications, and be ready to explain your thought process clearly.
✨Show Your Collaborative Spirit
As a Business Data Analyst, you'll need to work closely with various stakeholders. Prepare examples of how you've successfully collaborated in the past, highlighting your communication skills and ability to advocate for data fluency across teams.
