Business Data Analyst

Micheldever Group; Southam CP; On-site; GBP 42,000 - 56,000; Full time

Benefits offered by this job

Finder’s fee

Life Insurance

Pension

Retail vouchers

Staff Rates

Eye Care Vouchers

Buy/Sell Holiday option

Flu Jab

Employee Assistant Program

Long Service Recognition

Maternity/Paternity enhancements

Cycle to Work

Charity Match

Job summary

Micheldever Group is seeking a Business Data Analyst in the Southam area. The role focuses on building dashboards and reporting suites with Power BI and Excel to support Business Development and Area Sales Managers, driving data-driven decisions across key accounts.

The ideal candidate will have proven Power BI and advanced Excel skills, experience handling large datasets, and the ability to deliver clear, actionable insights. Hybrid work is available.

Qualifications

• Proven experience using Power BI and advanced Excel functions.
• Hands-on experience managing and analysing large data sets.
• Ability to deliver clear insightful dashboards and reports.

Responsibilities

• Create and develop dashboards and reporting suites using Power BI and Excel.
• Maintain scheduled reporting suites for internal and external recipients.
• Ensure reports are accurate and distributed promptly on a diarised basis.
• Produce ad-hoc reporting for stakeholders across business divisions.
• Investigate improvements to existing reporting processes and liaise with cross-functional teams.
• Monitor business processes and recommend data-driven improvements.
• Support the Analytics and Reporting Manager in transforming data into strategic insights.
• Support new projects to drive growth and adaptation in a evolving market.

Skills

Power BI

Advanced Excel

Data analysis

Dashboard reporting

Excel formulas

Tools

Power Query

VBA

Index Match

XLOOKUP

VLOOKUP

Job description

Micheldever Tyre Services is looking for a Business Data Analyst who has a real passion for data, analytics and insight, and is able to use data to improve the effectiveness of activity with the ability to interpret data quickly and accurately. With strong experience in reporting and creating dashboards, using tools such as Power BI and Excel, you will manage the reporting and analytics of all key accounts for Business Development Managers and Area Sales Managers to support the delivery of the strategic goals and commercial ambitions.

This position requires the Business Data Analyst to provide scheduled reporting and performance analysis which delivers actionable data-driven insight, understanding, conclusions and recommendations that support strategic decision making across the business.

• Working Pattern: 40hours per week, 08:30 – 05:00Monday toFriday
• Hybrid:Monday and Tuesday in the office, Wednesday - Fiday from home
• Location: Southam
• Must have: Proven experience using Power BI and advanced Excel functions, such as VLOOKUP, SUMIF, XLOOKUP, Index Match, Power Query, VBA are a necessity.
• Benefits:Finder’s fee, Life Insurance, Pension, a great variety of Retail vouchers, Staff Rates, Eye Care Vouchers, Buy/Sell Holiday option, Flu Jab, Employee Assistant Program, Long Service Recognition, Enhance Maternity and Paternity payments, Cycle to Work, Charity Match.

About our role:

Create and develop dashboards and reporting suites, using reporting tools such as Power BI and Excel.

Maintain existing agreed scheduled Reporting suites for both internal and external recipients.

Ensuring these are completed with accuracy and distributed promptly on a diarised basis.

Ad-hoc reporting will be requested from all members of the business divisions, along with internal stake holders and external key business contacts and partners.

Investigate improvements and developments to existing reporting suites and reporting processes. To include liaising, coordinating and understanding business requirements with cross functional teams.

Monitor business processes and recommend data‑driven improvements to enhance key performance indicators.

Support the Business Analytics and Reporting Manager in transforming data and market trends to informed strategic business decisions.

Support the Business Analytics and Reporting Manager on new projects that drive the business divisions to grow, innovate, and adapt in a rapidly evolving market.

The ideal candidate. Do you have:

• Experience working in Analytics and Reporting
• Background working in a fast-paced, dynamic environment.
• Hands on experience managing and analysing large data sets
• Experience in Power BI, with a proven ability to deliver clear insightful dashboards and report
• Microsoft Office Skills, including Excel Skills using advanced functions and formulas

Why join Micheldever?

Micheldever Tyre Services (MTS) was founded in 1972 as a part‑time venture providing car servicing and tyres. Today, Micheldever Group is the fastest growing wholesaler, distributor and retailer of tyres in the UK, selling six million tyres nationwide, (20 percent of the total UK market) and employing approximately 2100 employees, companywide.

To support this business, we have built a wholesale distribution network of 14 sites around the UK supplying over 6,000 retailers and our own retail chain Protyre which is consistently growing. This is achieved by skilled, focused and determined teams across 1 central distribution and 13 warehouse operations nationwide.