Job Description

Farrow and Ball - BI Analyst, Wimborne (37.5 hours per week)

We are currently looking for an

experienced individual

to join our

Digital team

in

Wimborne

as a

BI Analyst

. We are offering this position on a

full-time

basis, working

hybrid

between our head office in Wimborne and home


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.


To work cross functionally over all of Farrow & Ball's global departments and stakeholders to transform data into information using business intelligence, statistical analysis techniques and machine learning.


The role will form part of centralised IT reporting function, working to ensure that our central reporting system supports the needs of F&B, empowering the business to grow through data driven decisions.


The role will also assist with the strategic direction of Farrow & Ball's information and business systems to ensure ongoing operational excellence and efficiency.

What we expect from you as a BI Analyst.

Key Responsibilities:


Develop and maintain ETL solutions using SSIS Assist in developing and maintaining the data warehouse (SQL Server). Develop and maintain Power BI datasets (semantic models) and reports. Monitor the operations of the reporting architecture, including ETL processes, data warehousing, and Power BI semantic models, proactively managing any issues on a day-to-day basis. Optimise and maintain reporting schedules to ensure timely distribution of required management information. Perform data analysis to support business decisions. Use machine learning tools and statistical techniques to provide solutions to problems. Merge, manage, interrogate, and extract data to supply tailored analysis to colleagues, customers, or the wider organisation. Produce and maintain clear and coherent documentation of processes, data models, reports, and methodologies. Produce analysis, reports, and dashboards using various tools as required. Develop clear reports that tell compelling stories about customer interactions with the business. Act as a service centre for company-wide ad-hoc reporting queries and needs, maintaining a strong service SLA approach within an Agile development model. Collaborate with departments to understand their data needs.

Key Attributes:


Identify with Farrow & Ball's core values: Pioneering, Extraordinary, True. Analytical, lateral, and inquiring thinking style Firm grasp of presenting information and insight in digital forms To align with and contribute to a small, focussed team quickly To have a deep sense of service and ownership Demonstrable understanding of Data Warehousing concepts and tools Practical experience with databases, querying and manipulating data Experience in database interrogation and analysis tools Ability to take on training and apply new skills immediately Terrific attention to detail, and very high personal standards when it comes to quality, method and rigour Advanced ability with MS Office with expert in MS Excel Excellent numerical, interpersonal, and verbal communication skills to explain your work to people who don't understand the mechanics behind data analysis Honours Degree or similar in computer science or demonstrable equivalent experience of working in reporting functions and/or information analysis To have worked in an IT service environment, meeting and exceeding SLAs desirable Experience with Microsoft Power BI, DAX, M and IFS Cloud 23R1 (or higher) would be a distinct advantage

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.