Business Intelligence Analyst

Wren Kitchens; Barton-upon-Humber; On-site; GBP 35,000 - 50,000; Full time

Job summary

A leading kitchen retailer in the UK is seeking a Business Intelligence Analyst to support the central Business Intelligence Team. The ideal candidate will have strong skills in Power BI, DAX, and SQL, with responsibilities including consolidating reports and developing new Power BI reporting solutions. A collaborative mindset and attention to detail are essential for success in this role, which offers career progression opportunities and various employee benefits.

Benefits

Life Assurance after 2 years' service

Access to health and discount platform after 1 year

Personalised progression plan

Individual training budget

EE discount

Staff discount after 1 year

Eye Care Vouchers

Refer a Friend Scheme

Free onsite gym

Qualifications

• Strong IT skills; advanced Excel (VBA desirable) and Power BI experience.
• Experience with SQL (MySQL/Databricks) is advantageous.
• Professional, consistent, and meticulous in all work.

Responsibilities

• Gather requirements and develop Power BI reporting to replace 300+ Excel Reports.
• Test and refine Datasets for Power BI Reports within the current Datawarehouse project.
• Review and maintain the structure of existing Suite of BI Reports.

Skills

Power BI

DAX

MySQL

Databricks SQL

Advanced Excel

Job description

Overview

About The Role We are currently looking for a dedicated individual to work within the central Business Intelligence Team. A passion for providing an exceptional level of support is essential and you must have a proactive approach to work, remaining professional and confidential always. We are currently consolidating and upgrading our reporting infrastructure. We're building a data warehouse to centralise and standardise data across the organisation, moving away from our legacy reporting tool. This project includes 64 reporting areas and over 500 unique reports, many with multiple versions, that need to be streamlined into concise, filterable Power BI reports. As a Business Intelligence Analyst, you'll be responsible for consolidating these reports in Power BI, leveraging both your DAX skills and knowledge of MySQL and Databricks SQL to build insightful, high-performance reports. Since our new data warehouse will reside in Databricks, experience with Databricks SQL is crucial for defining, querying, and optimising datasets to ensure smooth integration with Power BI. You'll also need to apply Row-Level Security (RLS) in Power BI to control data access and implement scheduling to ensure reports are updated in real-time.

Responsibilities

• Work with the BI Manager and the BI Team to gather requirements and develop Power BI reporting to replace 300+ Excel Reports
• Work with the BI Manager to test and refine Datasets to be used in our Power BI Reports within the current Datawarehouse project
• Work with the Sr BI Analyst to review and maintain the structure of our existing Suite of BI Reports — Workspaces, Apps, Permissions, Formats, etc.
• Assist the BI Manager with DWH requirements and testing of delivered data for YOY reporting which will be delivered by the whole team.

Qualifications

• Strong IT skills; advanced Excel (VBA desirable) and Power BI experience a plus.
• Experience with SQL (MySQL/Databricks) is advantageous
• Ability to analyse trends, produce accurate reports, and maintain data integrity.
• Professional, consistent, and meticulous in all work.
• Confident communicator who can present findings clearly to all audiences.
• Self-reliant, inquisitive, and results-driven, with a collaborative mindset.
• Experience in the Kitchen/Furniture Retail sector is desirable.

Benefits

• Life Assurance after 2 years' service
• Access to Benenden health and discount platform after 1 year of continuous service
• Personalised progression plan with clear career opportunities
• Individual training budget for personal development
• EE discount
• Staff discount on purchasing a kitchen/bedroom after 1 year of continuous service
• Eye Care Vouchers
• Refer a Friend Scheme
• Free onsite gym