BI Analyst

About us:

Connect, operating under the Screwfix banner and owned by the Kingfisher Group, is a leading name in the distribution of high-quality appliance spare parts and accessories. We are dedicated to delivering exceptional products and services to our diverse clientele across various sectors.

We have over 50 years’ experience in the appliance spare parts industry. Our most recent opportunity has been becoming part of Screwfix, which has allowed us to continue to expand with the extensive support, knowledge and resources that the Kingfisher group has to offer.

About the role and team:

We are seeking a highly skilled and motivated eCommerce Power BI Analyst to join our team. The successful candidate will be responsible for analysing eCommerce data, building insightful dashboards, and providing actionable insights to drive business decisions. As an expert in Power BI and data analytics, you will support the marketing, product, and sales teams by transforming data into visually compelling reports and performance metrics that enhance our eCommerce strategies.

This role will be working Monday – Friday 37.5 hours per week (3 days per week office based B37 7HG)

The role will involve:

Analysing eCommerce performance metrics (e.g., traffic, conversion rates, sales, customer behaviour) using Power BI and other BI tools

Creating, maintaining, and updating interactive dashboards, reports, and visualizations that provide actionable insights to stakeholders

Developing automated reporting processes to streamline data analysis for the marketing, product, and sales teams

Monitoring and analyse eCommerce KPIs, trends, and forecasts to identify growth opportunities

Providing insights into customer behaviour, product performance, and campaign effectiveness, helping to shape marketing and product strategies

Collaborating with IT, data engineering, and marketing teams to ensure proper integration of eCommerce data from various sources (e.g. Google Analytics, Google ads, Microsoft ads, Google Big query)

Maintaining data accuracy and integrity by performing regular audits and implementing data governance best practices

Working cross-functionally with marketing, product management, operations, and sales teams to provide insights that enhance decision-making

Supporting ad-hoc requests for data analysis and reporting from various stakeholders

To be successful for this role you will have:

Experience in data analysis, preferably in an eCommerce or digital marketing environment

Proven expertise in using Power BI for data visualization and reporting

Proficiency in Power BI, including DAX queries, Power Query, and report creation

Strong understanding of eCommerce platforms (e.g. Google Analytics, Google ads, Microsoft ads, Google Big query

Advanced Excel skills, including pivot tables, charts, and complex formulas

Experience with SQL for querying and manipulating large datasets

Knowledge of data integration tools (e.g., Power Automate, ETL processes)

What we offer:

Retail Trust – a free online support and counselling service

Employee support fund – non-repayable loan to help you in times of need

Enhanced Parent Policy

Enhanced Company Sick Pay

HapiApp – Lots of retail discounts (shops, gyms etc)

Speak Up – a confidential service to report any incidents at work

People Forum committee – a way for our people to have a say in the future of our business

20% discount within our retail stores

Discount on all our stock

Skillshub – a learning management system to boost your knowledge both in and out of the workplace

PepTalk – a hub of hundreds of Pep Talks from industry professionals

A generous Length of Service scheme

Peakon Surveys – for you to have your say

Charity events open for all to get involved in

Company engagement events