Business Intelligence Analyst

Spencer - Richardson
Kilmarnock, UK
about 1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Artificial Intelligence Amazon Web Services Data Analysis Microsoft Azure Business Systems Data Governance Data Infrastructure Data Warehousing Database Queries Power BI Cloud Services
+3 more
Tableau (Software) Snowflake Data Analytics

Job description

We’re looking for a commercially minded Business Intelligence Analyst to play a pivotal role in transforming data into meaningful insights that drive business performance. This is an exciting opportunity to join a growing multi-site business where data is at the heart of strategic and operational decision-making.

As part of a significant investment in data, reporting, and analytics capabilities, you’ll lead the development of a central data warehouse and help establish a single source of truth across the organisation. Working closely with Finance, Operations, IT, and senior stakeholders, you’ll influence how data is captured, managed, and leveraged to support growth.

What You’ll Be Doing

Build Strong Data Foundations

  • Design and develop a central data warehouse integrating multiple business systems.
  • Create scalable data models and structures to support reporting and analytics.
  • Improve data quality, governance, and consistency across the organisation.
  • Work with internal teams and external providers to develop and maintain data pipelines.

Deliver Insight That Drives Performance

  • Build dashboards and reporting solutions covering key operational and financial metrics.
  • Analyse trends, risks, and opportunities to support strategic decision-making.
  • Enable self-service reporting while maintaining robust data governance.
  • Present complex findings in a clear, actionable way for non-technical stakeholders.

Support Commercial Growth

  • Partner with Finance and Operations teams to understand business performance.
  • Support budgeting, forecasting, investment decisions, and expansion projects.
  • Identify opportunities to improve profitability, efficiency, and customer outcomes through data.

Drive Innovation

  • Explore AI-enabled analytics, automation, and predictive modelling opportunities.
  • Support the transition from historical reporting to forward-looking insights.
  • Help prepare data infrastructure for future AI and advanced analytics initiatives.

Requirements

Essential

  • Proven experience in a Business Intelligence, Data Analyst, or similar analytics role.
  • Strong SQL skills and experience working with structured datasets.
  • Experience designing or working with data warehouses and centralised data models.
  • Advanced Excel and analytical skills.
  • Experience with Power BI, Tableau, or similar visualisation tools.
  • Ability to communicate complex data clearly to a wide range of stakeholders.

Desirable

  • Experience within hospitality, retail, or other multi-site environments.
  • Exposure to cloud data platforms such as Azure, AWS, or Snowflake.
  • Experience working with data from systems such as EPOS, CRM, reservations, payroll, or finance platforms.
  • Knowledge of forecasting, predictive analytics, or AI-driven solutions.

About You

You are:

  • Curious and commercially focused.
  • Comfortable working with ambiguity and evolving priorities.
  • Passionate about creating structure and improving processes.
  • Detail-oriented, with the ability to simplify complexity.
  • Enthusiastic about innovation, automation, and continuous improvement.

Benefits & conditions

  • Opportunity to build and shape a modern BI function.
  • Significant influence on business-wide decision-making.
  • Exposure to senior stakeholders and strategic projects.
  • A forward-thinking environment investing in data, technology, and AI.
  • Competitive salary and benefits package.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on find.jobs

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:42 min

Combining technical skills with strong business communication

Lukas Kölbl · LIVE

1:48 min

Automating exploratory data analysis within training pipelines

Dora Petrella · WWC 2023

1:33 min

Integrating internal APIs and maintaining data sovereignty

Mahran Meißner Mahran Meißner · WWC Europe 2026

1:46 min

Traditional data architecture before Microsoft Fabric

Dr. Alexander Wachtel Dr. Alexander Wachtel +1 · WWC 2025

1:36 min

Performing exploratory data analysis to uncover underlying patterns

Julian Joseph · LIVE

2:46 min

Transforming data architecture from on-premise to cloud

Sandhya Menon Sandhya Menon · WWC Europe 2026

Videos

See all

Related articles

See all