37 Business Analysis jobs in London

Business Intelligence Analyst

Location: London

Department: Business Development

Reports To: VP Business Development

Type: Full-time | Permanent | Hybrid

Company Overview

Oriflame is a global beauty and wellness company founded in Sweden, with over 55 years of heritage and generating sales of over €604 million in 2024. Operating in over 60 countries worldwide, we offer high-quality, accessible products while empowering individuals to build their own businesses through a trusted and sustainable direct-selling model.

We are now embarking on an exciting transformation journey, modernising how we work, embracing digital and social commerce channels and rolling out strategic change initiatives across the business. At Oriflame, you’ll find the scale and stability of a global company combined with agility and an entrepreneurial spirit. Our people thrive on innovation, collaboration, and continuous development.

The Role

We are looking for an analytical and commercially minded Business Intelligence Analyst to join our global Business Development team. You will bring in fresh thinking, new ideas, and a proactive mindset to shape commercial decisions and strategy. You will report to the VP Business Development and work closely with colleagues across Finance and commercial teams, at a global level.

The role offers strong exposure to senior stakeholders and diverse markets, with plenty of opportunity to grow through collaboration on global projects and strategic business initiatives.

Key Responsibilities

• Research and track market, consumer, and competitor trends in the industry to support commercial decision-making.
• Deliver deep business analysis on internal performance, to identify opportunities for improved growth, efficiency, and profitability.
• Connect external market insights with internal data to create a holistic, 360° view that drives smarter strategic decisions.
• Translate complex data into clear insights , building reports and presentations to support senior decision-making.
• Work closely with Business Development, Marketing, Sales, Digital and Finance to provide actionable intelligence that informs strategic initiatives.
• Prepare and present market reports, competitor benchmarking, and business reviews to senior stakeholders.
• Support evaluation of new market opportunities as part of business planning and innovation processes.
• Act as a trusted voice of intelligence across the organisation, helping teams stay ahead of market trends, emerging risks, and strategic opportunities.
• Contribute to the development and improvement of BI processes, tools, and reporting structures to enhance business insight capabilities.

Candidate Experience & Skills

• 5 years’ experience in Business Intelligence, Market Research or Strategic Analysis.
• Proven ability to translate complex data into clear, actionable insights and influence business outcomes.
• Strong data analysis skills using tools such as Excel, Power BI/Tableau , or similar.
• Confident communicator with excellent storytelling skills and ability to engage senior stakeholders with clarity and impact.

Personal Attributes

• Self-starter who takes ownership and is proactive in identifying opportunities for analysis and improvement.
• Commercially curious with strong critical and creative thinking skills.
• Detail-oriented with the ability to connect the dots across datasets and business questions.
• Comfortable working independently while collaborating across functions in a dynamic, fast-paced environment.

Business Intelligence Reporting Lead £44k Salary

Job Details

Directorate: Corporate Services

Department/Team: Strategy and Business Intelligence

Location: London-based office with flexibility to work remotely

Hours: Contracted hours to be agreed locally with line manager

Job Purpose

The Business Intelligence (BI) Reporting Lead will be the organisation’s leading expert in Power BI and other reporting tools, playing a key role in enhancing data maturity and enabling data-driven decision-making.

They will oversee the full lifecycle of BI reports and dashboards, from requirements gathering through to design, deployment, maintenance, and optimisation, while providing best practice guidance on reporting across business systems such as Dynamics and Assemble.

The role involves complex data troubleshooting, process improvement, and collaboration across departments to resolve data quality issues and enhance reporting capabilities. The BI Reporting Lead will also contribute to the broader data and digital strategy, particularly within Microsoft Azure data architecture, shaping the strategic use of BI tools and defining the future direction of reporting across the organisation.

Key Responsibilities and Accountabilities

1. Strategic Leadership: Lead the development and implementation of robust organisation-wide BI best practices and standards, embedding a “hub and spoke” model that ensures alignment with governance, security, and data usage policies.
2. BI Expertise: Act as the organisation’s BI reporting expert, collaborating with IT to develop, procure, and optimise BI tools, including the extraction, transformation, and loading (ETL) of complex datasets in line with technical standards.
3. Lifecycle Management: Oversee the complete lifecycle of Power BI reports and dashboards—from gathering requirements to deployment, maintenance, and archiving.
4. Reports and Dashboard Development: Lead the execution of the Power BI roadmap, delivering user-focused reporting solutions aligned with strategic goals. Ensure technical consistency, high-quality documentation, and effective stakeholder engagement.
5. BI Tool Optimisation: Optimise Power BI performance through advanced data modelling, efficient queries, and continuous monitoring. Proactively identify and resolve performance issues in collaboration with IT.
6. Data Maturity and Culture: Support organisational data maturity initiatives and foster a culture of data-driven decision-making. Provide training and technical support to BI users, building strong stakeholder relationships.
7. Innovation and Best Practice: Stay up to date with emerging BI technologies and methodologies, advocating for innovative approaches to improve access to and use of data.
8. Performance Monitoring: Analyse and evaluate performance metrics, reporting against objectives and KPIs, and ensuring timely corrective action when required.

Requirements – Essential / Desirable

• Proven experience as a BI Lead overseeing development and rollout of BI tools (Essential)
• Strong SQL proficiency with experience in data modelling, integration, and ETL processes (Essential)
• Understanding of Microsoft Azure data storage and analytics (Essential)
• Extensive Power BI experience including reports, dashboards, DAX, and Power Query (Essential)
• Knowledge of data governance and quality principles (Essential)
• Advanced analytical and problem-solving skills (Essential)
• Demonstrated ability to resolve complex technical problems (Essential)
• Experience managing third-party vendors (Essential)
• Strong interpersonal and influencing skills (Essential)
• Excellent organisational and workload management abilities (Essential)

Dimensions of the Role

Resources: Accountable for the strategic positioning and maintenance of BI tools across the organisation.

Key Relationships

• Internal: Collaborates with all business units and user groups to ensure BI tools meet organisational needs. Works closely with data and technology teams.
• External: Manages supplier relationships, collaborates with external peers and sector groups to share knowledge and track developments.

Information Security and Governance: Responsible for upholding data governance and security protocols relevant to the role.

Key Deliverables

1. High system availability and strong user satisfaction with BI tools
2. Strategic and operational Power BI reports that meet user and organisational needs
3. Engaged BI user groups fostering collaboration and trust
4. System optimisation reducing support and procurement costs
5. Development and management of a Power BI product roadmap
6. Strong working relationships across IT and Data functions

Level Descriptions

• 5 Strategic: Deep understanding of organisational systems and strategy; represents the organisation externally; makes high-impact decisions.
• 4 Expert: Recognised authority; leads and influences others; manages significant resources.
• 3 Complex: Uses experience and judgment to solve complex problems and collaborate across teams.
• 2 Enhanced: Manages internal and external processes, relationships, and problem-solving.
• 1 Foundation: Contributes to organisational goals without managerial responsibility.

Qualifications and Training

• Essential: Advanced Power BI experience or equivalent.
• Desirable: Microsoft Azure and Fabric expertise.

Additional Information

1. Confidentiality: Handle sensitive data responsibly and in compliance with GDPR and relevant legislation.
2. Equality, Diversity & Inclusion: Support the organisation’s commitment to diversity and inclusion, ensuring accessibility and fairness in all activities.
3. Health & Safety: Contribute to a safe working environment and complete any required training.
4. Safeguarding: Promote responsible working practices and contribute to safeguarding initiatives.
5. Digital & Data Proficiency: Use digital tools confidently, including Microsoft Office, Power BI, intranet systems, and relevant reporting software.

Other Requirements:

• Occasional travel for team meetings or events
• Some out-of-hours work may be required
• Ability to respond promptly to urgent technical issues

BI Analyst - London (Hybrid)

3 days/week in-office for the first 5–6 months, then typically 1–2 days/week

Our ecommerce clients is looking for a BI Analyst who can bring data to life and build trusted relationships across the business. You’ll design clear, impactful dashboards, write advanced SQL to power them, and work directly with teams in marketing, e-commerce, operations and supply to make data central to decision-making.

What you’ll do

• Create and maintain dashboards and data visualisations that drive action (Looker Studio preferred; Power BI/Tableau experience also valued).
• Write complex SQL queries (joins, subqueries, nested logic) to deliver robust reporting.
• Partner with stakeholders across functions — understanding their processes, shaping requirements, and iterating dashboards that really get used.
• Run deep-dive analysis projects and support ad-hoc data needs while helping reduce them through better self-serve tools.
• Contribute to a culture of consistent KPI definitions, strong governance and clear documentation.

What you’ll bring

• 2+ years’ experience in an analytical or BI role.
• Strong portfolio of dashboarding/data visualisation work.
• Advanced SQL capability (beyond simple selects).
• Confidence working directly with non-technical teams and building trust.
• Bonus: travel/e-commerce sector background

Salary: up to £48k.

Senior BI Analyst – Analytics Engineering Team

We’re looking for a Senior BI Analyst to join our Analytics Engineering team. In this role, you’ll partner with BI platform users and engineering teams to enable self-serve decision-making through reporting and actionable insights, while making our data models more performant.

Sitting at the intersection of Analytics Engineering and Insights, you’ll support data scientists and business users to become more self-sufficient, helping to further data literacy across the organization.

What we’re looking for

• Strong SQL skills with experience querying large, complex datasets.
• Expert knowledge of Looker (not Looker Studio) and LookML, with hands-on experience building performant, reusable, and modular code for large-scale deployments.
• Ability to explain complex topics clearly and collaborate with both technical and non-technical stakeholders.
• Comfortable working autonomously to deliver features and influence the team’s roadmap.
• Experience in fast-changing environments, ideally in e-commerce or marketplace domains, understanding metrics like GMV, conversion rates, and user retention.
• Familiarity with data engineering principles and ELT pipelines, including communicating requirements to data engineers.
• Skilled in building reports, dashboards, and integrations that communicate insights clearly.

What you’ll do

• Provide end-user support in Looker for both data producers and consumers.
• Design and deliver training and guidance to improve self-serve BI adoption.
• Clean up, standardize, and shift-left Looker definitions into the data stack, simplifying the instance, improving performance, and reducing reliance on manual code changes.

Business Intelligence Reporting Lead £44k Salary

Job Details

Directorate: Corporate Services

Department/Team: Strategy and Business Intelligence

Location: London-based office with flexibility to work remotely

Hours: Contracted hours to be agreed locally with line manager

Job Purpose

The Business Intelligence (BI) Reporting Lead will be the organisation’s leading expert in Power BI and other reporting tools, playing a key role in enhancing data maturity and enabling data-driven decision-making.

They will oversee the full lifecycle of BI reports and dashboards, from requirements gathering through to design, deployment, maintenance, and optimisation, while providing best practice guidance on reporting across business systems such as Dynamics and Assemble.

The role involves complex data troubleshooting, process improvement, and collaboration across departments to resolve data quality issues and enhance reporting capabilities. The BI Reporting Lead will also contribute to the broader data and digital strategy, particularly within Microsoft Azure data architecture, shaping the strategic use of BI tools and defining the future direction of reporting across the organisation.

Key Responsibilities and Accountabilities

1. Strategic Leadership: Lead the development and implementation of robust organisation-wide BI best practices and standards, embedding a “hub and spoke” model that ensures alignment with governance, security, and data usage policies.
2. BI Expertise: Act as the organisation’s BI reporting expert, collaborating with IT to develop, procure, and optimise BI tools, including the extraction, transformation, and loading (ETL) of complex datasets in line with technical standards.
3. Lifecycle Management: Oversee the complete lifecycle of Power BI reports and dashboards—from gathering requirements to deployment, maintenance, and archiving.
4. Reports and Dashboard Development: Lead the execution of the Power BI roadmap, delivering user-focused reporting solutions aligned with strategic goals. Ensure technical consistency, high-quality documentation, and effective stakeholder engagement.
5. BI Tool Optimisation: Optimise Power BI performance through advanced data modelling, efficient queries, and continuous monitoring. Proactively identify and resolve performance issues in collaboration with IT.
6. Data Maturity and Culture: Support organisational data maturity initiatives and foster a culture of data-driven decision-making. Provide training and technical support to BI users, building strong stakeholder relationships.
7. Innovation and Best Practice: Stay up to date with emerging BI technologies and methodologies, advocating for innovative approaches to improve access to and use of data.
8. Performance Monitoring: Analyse and evaluate performance metrics, reporting against objectives and KPIs, and ensuring timely corrective action when required.

Requirements – Essential / Desirable

• Proven experience as a BI Lead overseeing development and rollout of BI tools (Essential)
• Strong SQL proficiency with experience in data modelling, integration, and ETL processes (Essential)
• Understanding of Microsoft Azure data storage and analytics (Essential)
• Extensive Power BI experience including reports, dashboards, DAX, and Power Query (Essential)
• Knowledge of data governance and quality principles (Essential)
• Advanced analytical and problem-solving skills (Essential)
• Demonstrated ability to resolve complex technical problems (Essential)
• Experience managing third-party vendors (Essential)
• Strong interpersonal and influencing skills (Essential)
• Excellent organisational and workload management abilities (Essential)

Dimensions of the Role

Resources: Accountable for the strategic positioning and maintenance of BI tools across the organisation.

Key Relationships

• Internal: Collaborates with all business units and user groups to ensure BI tools meet organisational needs. Works closely with data and technology teams.
• External: Manages supplier relationships, collaborates with external peers and sector groups to share knowledge and track developments.

Information Security and Governance: Responsible for upholding data governance and security protocols relevant to the role.

Key Deliverables

1. High system availability and strong user satisfaction with BI tools
2. Strategic and operational Power BI reports that meet user and organisational needs
3. Engaged BI user groups fostering collaboration and trust
4. System optimisation reducing support and procurement costs
5. Development and management of a Power BI product roadmap
6. Strong working relationships across IT and Data functions

Level Descriptions

• 5 Strategic: Deep understanding of organisational systems and strategy; represents the organisation externally; makes high-impact decisions.
• 4 Expert: Recognised authority; leads and influences others; manages significant resources.
• 3 Complex: Uses experience and judgment to solve complex problems and collaborate across teams.
• 2 Enhanced: Manages internal and external processes, relationships, and problem-solving.
• 1 Foundation: Contributes to organisational goals without managerial responsibility.

Qualifications and Training

• Essential: Advanced Power BI experience or equivalent.
• Desirable: Microsoft Azure and Fabric expertise.

Additional Information

1. Confidentiality: Handle sensitive data responsibly and in compliance with GDPR and relevant legislation.
2. Equality, Diversity & Inclusion: Support the organisation’s commitment to diversity and inclusion, ensuring accessibility and fairness in all activities.
3. Health & Safety: Contribute to a safe working environment and complete any required training.
4. Safeguarding: Promote responsible working practices and contribute to safeguarding initiatives.
5. Digital & Data Proficiency: Use digital tools confidently, including Microsoft Office, Power BI, intranet systems, and relevant reporting software.

Other Requirements:

• Occasional travel for team meetings or events
• Some out-of-hours work may be required
• Ability to respond promptly to urgent technical issues

Business Intelligence Analyst

Location: London

Department: Business Development

Reports To: VP Business Development

Type: Full-time | Permanent | Hybrid

Company Overview

Oriflame is a global beauty and wellness company founded in Sweden, with over 55 years of heritage and generating sales of over €604 million in 2024. Operating in over 60 countries worldwide, we offer high-quality, accessible products while empowering individuals to build their own businesses through a trusted and sustainable direct-selling model.

We are now embarking on an exciting transformation journey, modernising how we work, embracing digital and social commerce channels and rolling out strategic change initiatives across the business. At Oriflame, you’ll find the scale and stability of a global company combined with agility and an entrepreneurial spirit. Our people thrive on innovation, collaboration, and continuous development.

The Role

We are looking for an analytical and commercially minded Business Intelligence Analyst to join our global Business Development team. You will bring in fresh thinking, new ideas, and a proactive mindset to shape commercial decisions and strategy. You will report to the VP Business Development and work closely with colleagues across Finance and commercial teams, at a global level.

The role offers strong exposure to senior stakeholders and diverse markets, with plenty of opportunity to grow through collaboration on global projects and strategic business initiatives.

Key Responsibilities

• Research and track market, consumer, and competitor trends in the industry to support commercial decision-making.
• Deliver deep business analysis on internal performance, to identify opportunities for improved growth, efficiency, and profitability.
• Connect external market insights with internal data to create a holistic, 360° view that drives smarter strategic decisions.
• Translate complex data into clear insights , building reports and presentations to support senior decision-making.
• Work closely with Business Development, Marketing, Sales, Digital and Finance to provide actionable intelligence that informs strategic initiatives.
• Prepare and present market reports, competitor benchmarking, and business reviews to senior stakeholders.
• Support evaluation of new market opportunities as part of business planning and innovation processes.
• Act as a trusted voice of intelligence across the organisation, helping teams stay ahead of market trends, emerging risks, and strategic opportunities.
• Contribute to the development and improvement of BI processes, tools, and reporting structures to enhance business insight capabilities.

Candidate Experience & Skills

• 5 years’ experience in Business Intelligence, Market Research or Strategic Analysis.
• Proven ability to translate complex data into clear, actionable insights and influence business outcomes.
• Strong data analysis skills using tools such as Excel, Power BI/Tableau , or similar.
• Confident communicator with excellent storytelling skills and ability to engage senior stakeholders with clarity and impact.

Personal Attributes

• Self-starter who takes ownership and is proactive in identifying opportunities for analysis and improvement.
• Commercially curious with strong critical and creative thinking skills.
• Detail-oriented with the ability to connect the dots across datasets and business questions.
• Comfortable working independently while collaborating across functions in a dynamic, fast-paced environment.

BI Analyst - London (Hybrid)

3 days/week in-office for the first 5–6 months, then typically 1–2 days/week

Our ecommerce clients is looking for a BI Analyst who can bring data to life and build trusted relationships across the business. You’ll design clear, impactful dashboards, write advanced SQL to power them, and work directly with teams in marketing, e-commerce, operations and supply to make data central to decision-making.

What you’ll do

• Create and maintain dashboards and data visualisations that drive action (Looker Studio preferred; Power BI/Tableau experience also valued).
• Write complex SQL queries (joins, subqueries, nested logic) to deliver robust reporting.
• Partner with stakeholders across functions — understanding their processes, shaping requirements, and iterating dashboards that really get used.
• Run deep-dive analysis projects and support ad-hoc data needs while helping reduce them through better self-serve tools.
• Contribute to a culture of consistent KPI definitions, strong governance and clear documentation.

What you’ll bring

• 2+ years’ experience in an analytical or BI role.
• Strong portfolio of dashboarding/data visualisation work.
• Advanced SQL capability (beyond simple selects).
• Confidence working directly with non-technical teams and building trust.
• Bonus: travel/e-commerce sector background

Salary: up to £48k.

About Us

We are DEWYNTERS, the leading integrated advertising agency for live entertainment. Across the worlds of theatre, immersive, festivals and exhibitions, our unique blend of creativity, insights and commercial expertise delivers best-in-class campaigns that place our clients at the centre of attention and keep them there.

Our clients include Disney Theatrical Productions, The Royal Shakespeare Company, The Book of Mormom, Moulin Rouge: The Musical, Mamma Mia!, Wicked, Frameless and The Devil Wears Prada the Musical.

About the Role:

We are seeking a Business Intelligence Director to join our passionate Insights team. You will report into the Head of Insights.

As the Business Intelligence Director, you will lead the development and implementation of business intelligence strategies across the agency, including being responsible for the teams management, development and creation of all business intelligence tools.

You will undertake all elements of project management of our report/dashboard development including report building and testing to continually improve our dashboard reporting framework and ensure effective business partnering.

Your Responsibilities:

Strategic Leadership & Vision

• Define and lead the business intelligence process across the department, specifically implementing a comprehensive data infrastructure and strategy aligned with business objectives.
• Champion a culture of data-driven decision making across the agency by embedding BI insights into strategic planning, operational performance and client delivery.
• Partner with the Head of Insights to inform the business intelligence new business strategy, including pitching to prospective clients and representing the BI team in key client settings.

Programme & Project Delivery

• Oversee the successful delivery of large-scale business intelligence projects, ensuring timely delivery, budget compliance, and stakeholder satisfaction.
• Provide governance and oversight for day-to-day BI operations, acting as the senior escalation point for critical issues across the agency.
• Ensure BI applications and outputs consistently enhance decision-making at both strategic and operational levels.

Team Leadership & Development

• Lead, mentor, and develop the BI team (Managers, Developers, Analysts), fostering high performance and supporting continuous professional growth.
• Partner effectively with your HR counterpart to drive team performance and development, ensuring alignment with agency-wide people practices.
• Take responsibility for team 1:1s, development plans, and appraisals, embedding structured performance management into day-to-day leadership.

• Encourage innovation and best practice adoption within the team to maximise capability and impact.

Data & Technology Excellence

• Evaluate, implement, and optimise BI tools and technologies to enhance performance, efficiency, and insight generation.
• Oversee the design and delivery of interactive reports, dashboards, and analytics that drive clarity and action.
• Resolve complex data and tracking challenges across multiple business-critical data flows (e.g. sales, campaign metrics, CRM, audience research, Google Analytics, budgets).
• Provide oversight of the day-to-day management of the business intelligence programmes.

Collaboration & Influence

• Work closely with department heads, executives, and external partners to identify business needs and develop data-driven solutions.
• Collaborate with cross-functional teams to identify areas for process improvement and data-driven solutions.
• Act as a trusted advisor to senior leaders, ensuring BI drives both agency growth and client success.

Governance & Compliance

• Govern data integrity, compliance, and security standards to ensure all BI initiatives adhere to regulatory and organisational requirements.
• Ensure the business intelligence applications enhance key decision making across the agency.
• Act as a senior escalation point for any BI issues that may crop out across the agency.

Requirements

• Strong problem-solving skills , with the ability to interpret complex data and present in an actionable manner
• Strong leadership and interpersonal skills
• Excellent written and verbal communication
• Proven experience in business intelligence or data analytics, with a track record of managing BI projects.
• Strong experience of BI tools including Google Big Query, Azure SQL, Google Analytics 4, Microsoft Power BI and Funnel
• Strong experience it with ETL pipelines and data infrastructure (MSSQL, SSIS, Azure, DAX)
• Experience with DevOps and Coding languages (Azure DevOps, Git, Python, Powershell)
• Proven experience with statistical modelling (ie XGBoost)
• Understanding of advertising and marketing metrics is desirable
• Advanced Excel skills
• Self starter
• Curious and enthusiastic
• Ability to motivate others
• Interest in the arts is desirable

Benefits

• 25 days holiday rising to 30 days holiday
• Flexible / Hybrid working
• Company pension scheme
• Private health insurance after 3 years
• Medicash
• Cognitive behavioural therapy
• Ability to purchase additional annual leave
• Bonus scheme
• Enhanced Maternity and Paternity package
• Life Assurance
• Income protection
• Season ticket Loan
• Cycle2Work Scheme
• Complimentary theatre/entertainment tickets