Business Intelligence (BI) Analyst

Farrow and Ball – Business Intelligence (BI) Analyst, Wimborne (Hybrid)

We are currently looking for an analytical individual to join our IT team in Wimborne as a Business Intelligence (BI) Analyst. We are offering this position on a full-time, hybrid basis.

Farrow & Ball is 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 our passionate craftsmen, showroom teams and support functions who ensure that our customers have a positive, engaging experience at every stage of their journey with us.

As the Business Intelligence (BI) Analyst you will be 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. With the ability to hit the ground running you work to ensure that our central reporting system supports the needs of the business, empowering growth through data driven decisions.

What we expect from you as a Business Intelligence (BI) Analyst.

Key Responsibilities:

• To produce analysis, reports, and dashboards for the business in ERP (IFS / Oracle SQL), BI (Power BI/MySQL), Crystal and Excel as required.
• To create clear reports that tell compelling stories about how customers or clients work with the business
• To optimise and maintain reporting schedules to ensure timely distribution of required MI reports
• To help transform the F&B reporting style from flat tabular reports to drill down reports, visual charts or dashboards as appropriate
• To act as a service centre for companywide ad-hoc reporting needs, keeping a strong service SLA approach within an Agile development delivery model.
• To work closely with the business to identify issues or opportunities and use data to propose solutions for effective decision making
• To merge, manage, interrogate and extract data to supply tailored analysis to colleagues, customers or the wider organisation
• To maintain clear and coherent communication, both verbal and written, to understand data needs and report results
• To use a mix of machine learning tools and statistical techniques to produce solutions to problems
• To look for opportunities to use insights/datasets/code/models across other functions in the business
• To stay curious and enthusiastic about using algorithms to solve problems and enthuse others to see the benefit of your work.

Key Attributes:

• Able to identify with, and demonstrate affinity with F&B’s core values (In touch, Accountable, Collaborative, Caring and Passionate)
• 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

Key Abilities

• Advanced ability with MS Office with expert in MS Excel 2013 or above
• Demonstrable understanding of Data Warehousing and reporting queries (T-SQL and SSIS).
• Experience in database interrogation and analysis tools
• Ability to build queries in MS SQL as a minimum
• 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 2013 or above
• Excellent numerical, interpersonal, and verbal communication skills to explain your work to people who don’t understand the mechanics behind data analysis

Key Experience:

• Honours Degree 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 PowerBI and IFS Apps 8 (or higher) would be a distinct advantage

What you can expect from us

• 24 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 Perkbox, 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 we are committed to encouraging equality, diversity and inclusion among our people, with an aim to be truly representative of all sections of society and our customers. Applicants will be considered for employment based only on skills/experience and never based off of race, age, disability, religion, sexual orientation, gender identity or family status, including pregnancy.