Business Intelligence Lead

Capco; City Of London; Hybrid; GBP 60,000 - 90,000; Full time

Job summary

A leading consultancy firm based in London is seeking a Business Intelligence Lead to enhance operational excellence through data and AI. The ideal candidate will design executive dashboards and leverage AI tools for effective data analysis and reporting. Strong experience in business intelligence and proficiency in Power BI are essential for success in this hybrid role.

Benefits

Discretionary bonus

Health insurance

Continuous learning opportunities

Family-friendly policies

Flexible holiday options

Gympass access

Qualifications

• Proven experience in business intelligence or data analysis.
• Strong proficiency in Power BI and SQL.
• Hands-on experience with data integration and reporting.

Responsibilities

• Design and deliver executive dashboards for business reviews.
• Utilize AI tools to enhance data analysis and reporting.
• Collaborate with senior stakeholders for strategic insights.

Skills

Business intelligence

Data analysis

Stakeholder engagement

Power BI

SQL

AI productivity tools

Proactive mindset

Tools

Power BI

SQL

Microsoft Copilot

ChatGPT

Job description

Overview

Business Intelligence Lead
Location: London (Hybrid – 3 days p/w on site) | Practice Area: COO Office | Type: Permanent

Empower smarter decisions through intelligent insight and AI-driven efficiency.

The Role
We’re looking for a Business Intelligence Lead to harness data and AI to drive operational excellence, efficiency, and innovation across our consulting business. Sitting at the heart of the COO Office, this role provides the analytical backbone for how we run and grow the firm - delivering real-time visibility, actionable insight, and intelligent automation. You’ll go beyond traditional reporting: shaping how we use data to manage performance, identify opportunities, and support strategic decisions at leadership level. You’ll also play a key role in embedding AI tools like Copilot and ChatGPT into everyday workflows, improving productivity and storytelling across the business.

This is a hands-on role, ideal for someone who combines strong technical and analytical capability with excellent stakeholder engagement and a keen eye for business context.

What You’ll Do

• Design and deliver executive dashboards, KPI reporting, and insight packs for UK and global business reviews, town halls, and other leadership forums.
• Leverage AI tools (e.g. Microsoft Copilot, ChatGPT, Power BI Copilot) to streamline data analysis, automate reporting, and enhance narrative development.
• Partner with senior stakeholders to define requirements, translate business needs into analytical outputs, and provide proactive insight.
• Monitor business performance in real time to identify emerging trends, risks, and opportunities.
• Collaborate with delivery, workforce planning, and commercial teams to ensure consistent, data-driven decision-making.
• Lead the evolution of our BI capability - from data sourcing and architecture through to dashboard design and AI integration.

What We’re Looking For

• Proven experience in business intelligence, data analysis, or operational insight - ideally within consulting but not essential
• Strong proficiency in Power BI and SQL; ability to design and automate data models and dashboards.
• Hands-on experience with Power Query for shaping and combining complex data from multiple operational systems, ensuring data accuracy and consistency.
• Excellent business acumen and communication skills - able to translate complex datasets into clear, compelling narratives for senior, non-technical audiences.
• Hands-on experience with AI productivity tools (Microsoft Copilot, ChatGPT, etc.) and an enthusiasm for driving digital ways of working.
• A proactive, self-starting mindset - comfortable leading projects, gathering requirements, and managing expectations across senior stakeholders.

Bonus Points For

• Familiarity with workforce management systems, CRM or financial planning data.
• A track record of using data and insight to improve process, policy, or performance.
• Prior experience supporting COO, CFO, or operational leadership functions in a matrixed organisation

Why Join Capco

• Deliver high-impact business solutions within a Management Consultancy who work with a number of Tier 1 financial institutions.
• Work in a collaborative, flat, and entrepreneurial consulting culture
• Access continuous learning, training, and industry certifications

We offer a competitive, people-first benefits package designed to support every aspect of your life:

Core Benefits

• Discretionary bonus, competitive pension, health insurance, life insurance and critical illness cover.
• Mental Health: Easy access to CareFirst, Unmind, Aviva consultations, and in-house first aiders.
• Family-Friendly: Maternity, adoption, shared parental leave, plus paid leave for sickness, pregnancy loss, fertility treatment, menopause, and bereavement.
• Family Care: 8 complimentary backup care sessions for emergency childcare or elder care.
• Holiday Flexibility: 5 weeks of annual leave with the option to buy or sell holiday days based on your needs.
• Continuous Learning: Minimum 40 Hours of Training Annually: Take your pick - workshops, certifications, e-learning - your growth, your way. Also, Business Coach assigned from Day One: Get one-on-one guidance to fast-track your goals and accelerate your development.
• Healthcare Access: Convenient online GP services.
• Extra Perks: Gympass (Wellhub), travel insurance, Tastecard, season ticket loans, Cycle to Work, and dental insurance.

Inclusion at Capco
We’re committed to making our recruitment process accessible and straightforward for everyone. If you need any adjustments at any stage, just let us know – we’ll be happy to help. We value each person’s unique perspective and contribution. At Capco, we believe that being yourself is your greatest strength. Our #BeYourselfAtWork culture encourages individuality and collaboration - a mindset that shapes how we work with clients and each other every day.

Apply for this job

*

indicates a required field

First Name *

Last Name *

Email *

Phone

Country *

Phone *

Location (City) *

Resume/CV *

Enter manually

Accepted file types: pdf, doc, docx, txt, rtf

LinkedIn Profile

Website

Are you authorized to work in the country in which you’re applying? * Select...

Do you require Right to Work sponsorship now, or at any point in the future? * Select...

Do you know anyone or are you related to anyone who works at Capco? *

Were you referred to this role by a current Capco Employee? If yes, please confirm the employee’s Capco email address. * Select...

If you answered yes on the previous question, please provide details below.

How did you hear about this role? * Select...

Reasonable Adjustments * Select...

Do you require reasonable accommodations or adjustments?

If you answered yes to the Reasonable Adjustments question, please provide additional details. If not, enter N/A. *

If you answered yes to the previous question, please provide additional details.

Capco Job Candidate Privacy Notice Acknowledgement * Select...

Capco Job Candidate Privacy Notice Acknowledgement

Capco does not and shall notdiscriminate on the basis of race, color, religion (creed), gender, gender expression, age, national origin (ancestry), disability, marital status, sexual orientation, or military status, in any of its activities or operations. In order to track the effectiveness of our recruiting efforts, please consider participating in the optional questionnaire.

Select...

I identify my ethnicity group as * Select...

I identify my ethnicity sub group as * Select...

By checking this box, I consent to Capco collecting, storing, and processing my responses to the demographic data surveys above. *