Business Intelligence Developer

Description

As a Bi Developer, this role will be working cross functionally supporting the business with data analysis and detailed reporting. As a Bi Developer 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.

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

Requirements

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.

The ideal candidates should have a strong data analysis background and experience using data analysis tools such as SQL and Power BI.

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

Benefits

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.

• Group Pension Scheme, matched by F&B
• Access to our retail discounts platform
• Season Ticket Loans for travel
• 25 days’ annual leave (increasing with length of service) plus bank holidays
• Company Sick Pay
• Annual salary reviews, based on individual performance
• Life Assurance
• Generous staff discount on F&B products
• Health Cash Plan
• Cycle to Work scheme
• Enhanced Maternity and Paternity pay
• Employee Assistance Programme with 24/7 support

Training + Development

Interview process

Visa Sponsorship

Security clearance