Business Intelligence Analyst

Wren Kitchens; Barton-upon-Humber; On-site; GBP 30,000 - 45,000; Full time

Job summary

A leading kitchen retailer in Barton-upon-Humber is seeking a Business Intelligence Analyst to support the central Business Intelligence Team. The role involves consolidating reports in Power BI and requires experience with Databricks SQL and strong analytical skills. You will work closely with managers and the BI team to develop insightful reports and optimize data access. The company offers a supportive environment with growth opportunities and various employee perks.

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 on purchasing a kitchen/bedroom

Eye Care Vouchers

Refer a Friend Scheme

Free onsite gym

Qualifications

• Detail-oriented and proactive with data.
• Experience analyzing trends and producing accurate reports.
• Confident in presenting findings clearly.

Responsibilities

• Develop Power BI reports to replace Excel Reports.
• Test and refine Data Sets for Power BI.
• Maintain existing Suite of BI Reports.

Skills

Advanced Excel

Power BI

MySQL

Databricks SQL

Data analysis

Communication

Job description

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 currently 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.

This role is fully based at our Head Office in Barton-upon-Humber.

Main 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 Data Sets 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.

What Wren Offer

• 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

About You

We’re looking for a detail-oriented and proactive Data Analyst to join our team. You’ll work with data to uncover insights, support decision-making, and drive results.

• 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.

About The Company

Wren Kitchens are not only passionate about kitchens, we are passionate about our people! We have achieved incredible milestones over the years; opening over 100 showrooms, launching in the USA, and winning multiple awards including the UK’s Number 1 place to work! This is thanks to our team, the Wren family, who have inspired us to push limits and make a difference. With our exponential growth, we are looking for incredible individuals to join us and continue our success story!