BI Analyst

Connect Distribution Services Ltd; Birmingham; Hybrid; GBP 40,000 - 60,000; Full time

Benefits offered by this job

Retail Trust - online support

Employee support fund - non-repayable

Enhanced Parent Policy

Enhanced Company Sick Pay

HapiApp discounts

Speak Up confidential service

People Forum committee

20% discount within retail stores

Discount on stock

Skillshub LMS

PepTalk hub

Length of Service scheme

Peakon Surveys

Charity events

Company engagement events

Job summary

Connect Distribution Services Ltd in Birmingham (Hybrid) is seeking a BI Analyst to analyse data across the business, build dashboards and deliver insights that drive commercial and operational strategies.

You will work with marketing, product, sales and operations, turning data into actionable reports using Power BI, GA, Ads, and BigQuery, while maintaining data accuracy and governance.

Qualifications

• Experience in data analysis in retail, distribution, ecommerce or commercial environments.
• Proven expertise in Power BI with DAX, Power Query and report creation.
• Strong understanding of data platforms and sources (GA, Ads, BigQuery).
• Advanced Excel skills with pivots, charts and complex formulas.
• Experience with SQL for querying and handling large datasets.
• Knowledge of data integration tools (Power Automate, ETL).
• Excellent communication to present data to non-technical stakeholders.
• Proactive, curious problem-solver able to manage multiple priorities.

Responsibilities

• Analyse business performance metrics (sales, customer behavior, website traffic, operations) using Power BI and BI tools.
• Create, maintain, and update dashboards and reports providing actionable insights.
• Develop automated reporting processes to streamline data analysis.
• Monitor KPIs, trends and forecasts to identify growth opportunities.
• Deliver insights into customer behaviour, product performance and campaign effectiveness.
• Collaborate with stakeholders to integrate data from sources (GA, Ads, BigQuery).
• Ensure data accuracy and governance through regular audits.
• Work cross-functionally with marketing, product, operations and sales.
• Support ad-hoc data analysis requests as needed.

Skills

Power BI

DAX

Power Query

Data modelling

Excel

SQL

Google Analytics

Google Ads

Microsoft Ads

BigQuery

ETL

Power Automate

Data analysis

Communication

Problem solving

Tools

Google Analytics

Google Ads

Microsoft Ads

Google BigQuery

Job description

BI Analyst

Birmingham (B9 4UA), Hybrid

37.5 Hours per week Monday - Friday

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 BI Analyst to join our team. The successful candidate will be responsible for analysing data from across the business, building insightful dashboards, and providing actionable insights to drive business decisions. As an expert in Power BI and data analytics, you will support teams across the business, including marketing, product, sales and operations, by transforming data into visually compelling reports and performance metrics that drive our commercial and operational strategies.

The role will involve:

• Analysing business performance metrics (e.g., sales, customer behaviour, website traffic and conversion, operational performance) using Power BI and other BI tools
• Creating, maintaining, and updating interactive dashboards, reports, and visualisations that provide actionable insights to stakeholders
• Developing automated reporting processes to streamline data analysis for teams across the business
• Monitoring and analysing business KPIs, trends, and forecasts to identify growth opportunities
• Providing insights into customer behaviour, product performance, operational efficiency and campaign effectiveness, helping to shape commercial, marketing and product strategies
• Partnering with stakeholders across the business to ensure proper integration of 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 within a retail, distribution, eCommerce or commercial environment
• Proven expertise in Power BI, including DAX, Power Query, data modelling and report creation
• Strong understanding of data platforms and sources (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)
• Strong communication skills, with the ability to present complex data clearly to non-technical audiences
• A proactive, curious approach to problem-solving and the ability to manage multiple priorities

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