Business Analyst

Business Analyst, Adverting Agency, Central London, £55-60,000

Ready to turn questions into clarity and data into action? Join a global creative powerhouse where curiosity is celebrated, convention is challenged, and brilliant ideas shape the future.

We're looking for a Technical Business Analyst who thrives on solving problems, translating complexity into insight, and empowering teams with information they can trust. You'll sit at the heart of our Operations function, partnering with Finance, Client Services and senior leadership to make sure the business runs on sharp, accurate and meaningful data.

This is a role for someone who loves diving into detail but never loses sight of the bigger picture. Someone who's as comfortable in SQL and Power BI as they are in a workshop with stakeholders. Someone who gets a buzz from improving systems, streamlining processes and helping a fast-moving creative organisation work smarter every day.

What you'll do

Work with teams across the business to understand challenges, opportunities and data needs

Build and maintain dashboards using Power BI (Fabric, Direct Lake, DAX)

Analyse commercial, operational and resourcing data to uncover trends and drive decisions

Validate and query data models, troubleshoot issues and improve data quality

Support process improvements, system upgrades and new platform implementations

Communicate insights clearly to non-technical audiences and build strong cross-functional relationships

Champion data governance, privacy and quality standards

What you'll bring

Strong analytical mindset and a structured approach to problem-solving

Advanced Excel, Power BI, DAX and SQL skills

Experience gathering requirements and supporting system/process change

Ability to explain technical concepts simply and confidently

Excellent stakeholder management and communication skills

Highly organised, curious and commercially aware

Experience in business analysis or data analysis within project-based or creative environments