Junior Business Analyst

Advance Group; Houghton Regis; Hybrid; GBP 25,000 - 38,000; Full time

Job summary

Advance Group in the United Kingdom is seeking a Junior Business Analyst to help understand performance, improve processes and support data-driven decisions across Sales, Service, Projects and Finance.

You will work with the Commercial Manager on reporting, dashboards and pricing tools, turning data into actionable insights and communicating findings clearly to stakeholders.

Qualifications

• Degree or equivalent with 1–2 years in a business analysis role.
• Strong Excel skills, including formulas and pivot tables.
• Experience with Power BI and data analytics tools.
• Analytical mindset with attention to detail and storytelling.

Responsibilities

• Prepare regular performance reports for sales, service, and commercial areas.
• Analyze pricing, costs, and profitability for quotes and agreements.
• Support customer reporting on service levels and equipment reliability.
• Review supplier performance, purchasing volumes, pricing, and rebates.
• Identify sales opportunities from customer purchasing patterns.
• Maintain data across spreadsheets, CRM records and business systems.
• Develop dashboards, templates, and pricing tools.
• Collaborate across departments to improve reporting and processes.
• Provide ad hoc analysis and present findings clearly.

Skills

Excel

Power BI

Data analysis

Communication

Education

Related degree

Tools

AI analytics tools

Job description

Hybrid Working (Minimum 2 days in the Office per week) | Full-Time

We’re looking for a Junior Business Analyst to play an important role in understanding performance, improving processes and driving the right decisions for our business. This is a fantastic opportunity for someone at an early stage of their career who enjoys working with data and making it meaningful and useful to different areas of the business.

Working closely with our Commercial Manager, you’ll support reporting, analysis and business improvement projects across Sales, Service, Projects and Finance. You’ll have plenty of variety in your role – from analysing sales, pricing and profitability to looking at customer performance and supplier contracts, operational productivity, developing dashboards and identifying opportunities to improve performance.

What You'll Do

• Prepare regular sales, service and commercial performance reports, highlighting trends and areas requiring attention.


• Analyse pricing, costs and profitability to support quotations, customer agreements and commercial decisions.


• Support customer reporting on service levels, first-time fix rates, equipment reliability and maintenance.


• Review supplier performance, purchasing volumes, pricing agreements and rebates.


• Identify sales opportunities through analysis of customer purchasing patterns and product ranges.


• Gather, validate and maintain accurate data across spreadsheets, CRM records and business systems.


• Develop and improve dashboards, reporting templates and pricing tools.


• Work with departments to understand reporting needs and identify opportunities to improve processes.


• Support business projects through analysis, action tracking and presentation of findings.


• Respond to ad hoc analysis requests, presenting conclusions clearly and accurately.

About You

• A relevant degree or equivalent qualification, or 1–2 years’ practical experience in a Business Analysis role within a commercial environment.


• Confident using Excel, including formulas, lookups and pivot tables.


• Previous experience using Power BI and AI-powered data analytics tools would be beneficial.


• Strong analytical and numerical ability, with excellent attention to detail.


• Able to turn data into meaningful insights and communicate findings clearly.


• Confident communicator, both verbally and in writing. Able to build relationships with a range of audiences and stakeholders.


• Highly organised, with the ability to manage competing priorities and deadlines.


• A proactive approach to learning, with the ability and enthusiasm to learn new systems, processes and develop a strong understanding of the wider business.

Why Join Us?

This is an excellent opportunity to join a growing business in a vibrant, fast-paced industry, where you'll receive comprehensive on-the-job training, the autonomy to make an impact, the support of a collaborative team, and genuine opportunities for career development and progression.