Lead Business Intelligence Analyst

Farrow & Ball
Wimborne
3 days ago
Create job alert
Overview

Farrow and Ball - Lead Business Intelligence Analyst - Wimborne, Dorset - UK

We are currently looking for a skilled individual to join our IT team as a Lead BI Analyst. This is a full-time, hybrid role working from home with 2 days per week in our Head Office in Wimborne, Dorset.

Farrow & Ball are a luxury British lifestyle brand that prides itself in creating richly pigmented paint and handcrafted wallpaper, using print methods dating back 300 years and the finest quality ingredients.

The unique Farrow & Ball look transforms modern and traditional homes, large and small, inside and out. Established in Dorset in 1946, we have grown and now proudly have 60 showrooms worldwide with a global network of stockists.

The key to our success is the people behind the paint: from the team handcrafting each tin to showroom staff to support functions, our shared passion ensures customers have a positive, engaging experience at every stage of their journey with us.

Role and Scope

This is a senior, hands-on delivery and operations role responsible for the day-to-day running and continuous improvement of the central reporting and analytics estate. You will build, maintain, and support data pipelines and a SQL Server-based reporting warehouse. You will work cross-functionally to deliver trusted management information and KPI definitions, partnering closely with Commercial Finance to provide reliable datasets. This role has no people management responsibilities and forms part of a small BI team sharing operational support and delivery.

Environment and Scope

The reporting estate integrates data from multiple business systems into a central SQL Server warehouse and the Power BI Service. Data sources include ERP (IFS Cloud), enterprise applications, and operational and commercial systems. Data ingestion methods include scheduled extracts, file feeds, APIs, and managed integrations.

What we expect from you as a Lead BI Analyst
  • Operate and Support Reporting Estate
  • Monitor and maintain ETL processes, SQL Server Agent jobs, warehouse loads, and Power BI refreshes.
  • Troubleshoot issues, perform root cause analysis, and implement permanent fixes.
  • Improve monitoring, alerting, incident response, release scheduling, and Power BI refresh reliability and performance.
  • Data Engineering and Warehouse Development
  • Develop and maintain SSIS-based ETL solutions with robust logging, error handling, and performance tuning.
  • Build and maintain dimensional warehouse structures (facts and dimensions) following modelling standards.
  • Implement auditable, repeatable load strategies (incremental and full).
  • Develop and optimise SQL Server objects, including tables, views, stored procedures, indexing, and query tuning.
  • Work with upstream system owners and third parties to deliver reliable integrations.
  • Power BI Semantic Models and Reporting
  • Develop and maintain governed, reusable enterprise semantic models (shared datasets).
  • Build measures using DAX and shape data with Power Query (M) following best practices.
  • Create consistent, performant reports and dashboards.
  • Implement security and access controls, including role-based security.
  • Follow established model-report separation and controlled deployment practices.
  • Intake, Prioritisation, and Delivery
  • Help manage the reporting backlog: capture requests, clarify requirements, estimate effort, prioritise, and deliver predictably.
  • Balance ad-hoc requests with longer-term improvements, reducing repeat queries through reusable datasets.
  • Partner with stakeholders to agree KPI definitions and ensure correct data interpretation.
  • Standards, Governance, and Documentation
  • Contribute to BI governance, workspace organisation, monitoring, performance tuning, and change control.
  • Maintain documentation for pipelines, models, KPI logic, refresh schedules, and support procedures.
Key Attributes

Essential:

  • Hands-on SSIS and traditional ETL experience with scheduling, monitoring, and incident resolution.
  • Strong data warehousing fundamentals, business/surrogate keys, and historical change handling.
  • Strong SQL performance tuning and troubleshooting skills.
  • Enterprise Power BI development experience, including semantic models, DAX, Power Query, and security controls.
  • Experience with model-report separation and controlled release practices.
  • Ability to manage backlog, prioritise, and deliver work; strong communication and documentation skills.

Desirable:

  • Reporting from IFS Cloud or other ERP systems.
  • Familiarity with modern data tooling (Azure Data Factory, Microsoft Fabric, dbt, CI/CD).
  • Service management, incident-driven support, Agile delivery experience.
  • Experience integrating data via APIs, files, middleware, or managed methods.
  • Behaviours
  • Strong ownership of operational reliability and data quality.
  • Pragmatic, methodical, quality-focused.
  • Collaborative and service-oriented in a small team.
  • Comfortable bridging technical detail and business outcomes.
What You Can Expect From Us
  • 25 days’ annual leave (increasing with length of service) plus bank holidays
  • Annual salary reviews, based on individual performance
  • Enhanced Maternity and Paternity pay
  • Generous staff discount on F&B products
  • Access to our retail discounts platform
  • Employee Assistance Programme with 24/7 support
  • Health Cash Plan
  • Company Sick Pay
  • Group Pension Scheme, matched by F&B
  • Life Assurance
  • Refer a Friend scheme
  • Cycle to Work scheme
  • Season Ticket Loans for travel


#J-18808-Ljbffr

Related Jobs

View all jobs

Lead Business Intelligence Analyst

Lead Business Intelligence Analyst

Lead Business Intelligence Analyst

Lead Business Intelligence Analyst

Lead Business Intelligence Analyst

Lead Business Intelligence Analyst

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

What Hiring Managers Look for First in Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.

Data Science Jobs for Career Switchers in Their 30s, 40s & 50s (UK Reality Check)

Thinking about switching into data science in your 30s, 40s or 50s? You’re far from alone. Across the UK, businesses are investing in data science talent to turn data into insight, support better decisions and unlock competitive advantage. But with all the hype about machine learning, Python, AI and data unicorns, it can be hard to separate real opportunities from noise. This article gives you a practical, UK-focused reality check on data science careers for mid-life career switchers — what roles really exist, what skills employers really hire for, how long retraining typically takes, what UK recruiters actually look for and how to craft a compelling career pivot story. Whether you come from finance, marketing, operations, research, project management or another field entirely, there are meaningful pathways into data science — and age itself is not the barrier many people fear.