Junior Business Analyst [206503]

We are looking for a proactive and detail-oriented Freelance 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 Creative’s 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 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.

This role is open for a limited time. Next steps will be shared with shortlisted candidates by December 18th. Due to the high volume of applicants, we may be unable to reply to each applicant individually. If you have not received a response, please assume that you have not been selected for progression to the next stage of the hiring process.

Client Description

Our Client is a giant media and entertainment company, with over 24 million customers in Europe. They’re keen on keeping people connected, and their upcoming media investments are expected to bring billions of pounds and over 2000 jobs to the UK creative sector. Beyond business, they’re taking big strides in diversity and sustainability with ambitious public goals in both – including 20% BAME representation by 2025, and carbon neutrality by 2030. Aquent is dedicated to improving inclusivity & is proudly an equal opportunities employer. We encourage applications from under-represented groups & are committed to providing support to applicants with disabilities. We aim to provide reasonable accommodation for any part of the employment process, to those with a medical condition, disability or neurodivergence.