BI Developer

Farrow & Ball; Wimborne Minster; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

A luxury lifestyle brand in Wimborne, Dorset is seeking a skilled BI Developer to join their IT team. This full-time position allows hybrid work, splitting time between home and the office. Responsibilities include building ETL packages, maintaining SQL Server data warehouse, and developing Power BI reports. The ideal candidate will possess a Computer Science degree or equivalent experience and skills in Power BI, DAX, and SQL. Benefits include generous annual leave, salary reviews, and health plans.

Benefits

25 days annual leave plus bank holidays

Annual salary reviews

Enhanced maternity and paternity pay

Generous staff discount

Employee Assistance Programme

Health Cash Plan

Group pension scheme

Life Assurance

Cycle to Work scheme

Qualifications

• Degree in Computer Science/Information Systems or demonstrable equivalent experience.
• Experience in an IT service/ticketing environment advantageous.
• Familiarity with Microsoft Power BI, DAX, SQL Server, and/or SSIS.

Responsibilities

• Build and maintain small ETL packages under guidance.
• Assist in maintaining the data warehouse and creating basic tables.
• Develop and maintain Power BI datasets and reports.

Skills

Microsoft Power BI

DAX

SQL Server

ETL packages (SSIS)

Data manipulation

Education

Degree in Computer Science/Information Systems or equivalent experience

Tools

SQL

IFS Cloud 23R1+

Job description

Farrow and Ball - BI Developer - Wimborne, Dorset - UK

We are currently looking for a skilled individual to join our IT team as a BI Developer. We are offering this position on a full-time basis, working hybrid between home and 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 over the last 75 years 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.

As a BI Developer, this role will be working cross functionally supporting the business with data analysis and detailed reporting. You will be part of a centralised IT team, with a core purpose to ensure that our reporting systems support the needs of Farrow & Ball, empowering the business to make data‑intelligent decisions.

Key Responsibilities

• Build and maintain small ETL packages (SSIS) under guidance; resolve straightforward load issues and escalate where needed.
• Assist in maintaining the data warehouse (SQL Server): create basic tables, views, and stored procedures following standards.
• Develop and maintain Power BI datasets (semantic models) and reports; follow naming, modelling, and DAX style guides.
• Monitor daily/weekly refresh status for ETL, warehouse objects, and Power BI models; log issues and resolve simple failures.
• Maintain clear documentation (data dictionaries, report runbooks, refresh notes, how‑to guides).
• Build and iterate on straightforward dashboards and paginated reports from signed‑off requirements.
• Present results clearly with consistent visuals, definitions, and refresh notes.
• Service requests: triage and deliver ad‑hoc reporting requests via the ticketing system within agreed SLAs; escalated unclear or complex items.
• Collaboration: meet with departments (with support where required) to capture reporting needs and translate them into simple datasets, measures, and visuals.

Key Attributes

• Degree in Computer Science/Information Systems or demonstrable equivalent experience (e.g., internship, placement year, projects).
• Experience in an IT service/ticketing environment advantageous.
• Familiarity with Microsoft Power BI, DAX, SQL Server, and/or SSIS.
• Experience with IFS Cloud 23R1+ is a distinct advantage but not required.
• Practical experience querying and manipulating data (e.g., basic SQL).
• Experience building simple reports in Power BI or similar.
• Strong attention to detail and quality, with a structured approach to work.
• Clear written and verbal communication for non‑technical audiences.

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.

At Farrow & Ball, diversity, equity and inclusion (DE&I) is an integral part of who we are and how we do business. We believe diversity is the key to creativity. So, we’re committed to creating an environment where differences are valued, people are treated fairly and everyone is free to truly be themselves.

We welcome applications from everyone who wants to work with us, and particularly encourage people from diverse backgrounds to get in touch. We’re more than happy to offer reasonable adjustments or additional support during your application process, so simply let us know how we can help.