Business Intelligence Lead

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

• Excellent PowerPoint skills
• 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.