Trace | Expert Accountancy & Finance Recruitment
Technical Business Analyst
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Technical Business Analyst, Advertising 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.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location