Junior Business Analyst

Aquent; Greater London; On-site; GBP 30,000 - 45,000; Full time

Job summary

Aquent is seeking a proactive and detail-oriented Junior Business Analyst for a flexible contract role in London. This position offers the opportunity to work on various projects, analyzing data, improving reporting processes, and supporting decision-making. Ideal candidates will have a degree and experience in analytical roles, with strong Excel skills and the ability to collaborate effectively with diverse teams.

Qualifications

• Proven experience in an analytical, business support or reporting role.
• Advanced Excel skills with confidence in formulas and pivot tables.
• Understanding of Finance concepts is highly beneficial.

Responsibilities

• Develop strong knowledge of internal systems and data sources.
• Work closely with stakeholders to translate analytical needs into requirements.
• Deliver training sessions and provide support for business intelligence tools.

Skills

Analytical skills

Attention to detail

Communication skills

Education

Degree educated (2.1 and above)

Tools

Excel

SQL

Tableau

Power BI

SharePoint

Power Automate

Job description

1 day ago Be among the first 25 applicants

This range is provided by Aquent. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

We are looking for a proactive and detail-oriented Junior Business Analyst to support our team on a flexible, contract basis. This is a great opportunity for someone with a freelance background who is looking to gain deeper, longer-term experience within a structured team environment — particularly those considering a future transition into a permanent role. You’ll work across a variety of projects helping to analyse data, improve reporting processes, support decision-making and deliver valuable insights to the business. You’ll need to be a fast learner, able to navigate systems and tools quickly and be confident collaborating with a wide range of stakeholders across different teams.

What you'll do:

Quickly develop a strong working knowledge of our internal systems and data sources gaining the confidence to navigate them independently.

Work closely with key stakeholders across the business to understand their analytical and reporting needs, and translating these into clear actionable requirements that support effective decision-making.

Deliver training sessions and provide hands-on support to end-users of business intelligence tools and dashboards helping them get the most value from available data and systems.

Offer ongoing support to users resolving issues, answering queries and continuously improving the user experience across reporting tools and platforms.

Assess the quality, consistency and control of data flows across systems; identify gaps or inefficiencies and provide practical well-reasoned suggestions for improvement to enhance data integrity and usability.

Present insights, reports and recommendations in a clear, concise and engaging manner tailored to both technical and non-technical audiences.

Maintain robust advanced Excel models and dashboards to support planning, forecasting and performance reporting.

Perform detailed data analysis using advanced Excel models and dashboards to identify trends, anomalies, risks and opportunities that can inform business strategy.

Proactively identify and implement opportunities to automate, streamline and centralise reporting processes and Management Information (MI) to improve accuracy, consistency and efficiency.

Contribute to wider project and operational initiatives by supporting ad hoc analysis, building business cases and acting as a trusted analytical partner to internal teams.

What you'll bring:

Proven experience in an analytical, business support or reporting role (freelance or in-house).

Degree educated (2.1 and above).

Advanced Excel skills – confidence with formulas, pivot tables, technical problem solving (knowledge of Power Query an advantage).

Understanding of Finance (particularly financial accounting concepts, highly beneficial to have worked in previous finance-based roles).

Strong attention to detail and a structured approach to problem-solving.

Excellent interpersonal and communication skills with the ability to build relationships and collaborate effectively with a wide range of stakeholders across different teams.

Enthusiasm and a positive attitude with the ability to multitask and stay calm under pressure. Appreciation for the vibrant and dynamic nature of a large creative agency.

Confident presenting findings and recommendations in a professional user-friendly format tailored to both technical and non-technical audiences.

Confident amending and recording process change.

A proactive and flexible attitude with the ability to manage your time, prioritise tasks and work independently.

Able to come into the office 3x per week (Monday, Tuesday & Thursday) – mandatory.

Preferred:

Experience with Ariba and SAP is advantageous.

Experience using SharePoint for data management including managing SharePoint lists and using Power Automate (Flows) for automation.

Proficiency in SQL for querying and manipulating data from relational databases.

Familiarity with data visualisation tools such as Tableau and Power BI with the ability to build and maintain insightful user-friendly dashboards and reports.

A degree in Computer Science, Data Science, Statistics, Mathematics, Economics, Accounting, Finance, Business or a related field.

Previous experience working in a creative, media or marketing environment.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Analyst

• Industries

  Technology, Information and Media

Referrals increase your chances of interviewing at Aquent by 2x

Sign in to set job alerts for “Business Analyst” roles.

London, England, United Kingdom 2 weeks ago

Business Operations | Analyst/Associate | London

London, England, United Kingdom 1 week ago

Graduate Business Modelling Analyst - London - Up to £40,000 + amazing bonus/benefits package

Graduate Business Modelling Analyst - London - Up to £40,000 + amazing bonus/benefits package

London, England, United Kingdom 2 months ago

Erith, England, United Kingdom 3 weeks ago

London, England, United Kingdom 2 weeks ago

London, England, United Kingdom 3 weeks ago

Business Operations Analyst – Shared Operations

London, England, United Kingdom 4 days ago

City Of London, England, United Kingdom 1 week ago

Greater London, England, United Kingdom 2 weeks ago

City Of London, England, United Kingdom £550 - £550 1 day ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 week ago

London, England, United Kingdom 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.