M&A Business Analyst

Harvey Nash; Bristol; Hybrid; GBP 45,000 - 60,000; Full time

Job summary

A leading consultancy in the energy sector is seeking an M&A Business Analyst to provide analytical support across multiple divestments. The candidate will be responsible for cost analysis, data consolidation, and creating automated reporting dashboards. A Bachelor's degree in Business or related fields is required, along with strong analytical skills. The role is hybrid based in Sunbury on Thames, offering an opportunity to contribute to significant M&A activities within the firm.

Qualifications

• Bachelor’s degree in Business, Finance, Data / Analytics, or related field.
• Prior experience in the energy sector helpful but not essential.
• Experience with dashboarding and automation tools preferred.

Responsibilities

• Pull together data from multiple sources for each deal.
• Analyse cost data to identify stranded costs and cost drivers.
• Develop automated dashboards and reporting packs for leadership.
• Collaborate with project teams to define scope and data needs.
• Support pre‑completion tasks and conduct data validation checks.

Skills

Analytical skills

Data consolidation skills

Strong project coordination skills

Automation tools

Requirements management

Stakeholder engagement

Education

Bachelor’s degree in Business, Finance, Data / Analytics, or related field

Tools

Power BI

Advanced Excel

Job description

Job Title: M&A Business Analyst

Job Location: Sunbury on Thames - Hybrid

Contract Length: up to April 2026

Industry: Oil and Energy, Legal

Working Hours: 8 per day / 40 per week

Role Purpose

The M&A Business Analyst provides analytical and operational support across multiple divestments, with a strong focus on stranded cost analysis, data consolidation, and building structured, automated reporting. The role supports deal teams by bringing clarity to complex data, enabling decision‑making, and ensuring high‑quality analysis throughout the M&A lifecycle.

Key Responsibilities

• Pull together data from multiple sources (finance, business operations, regional cost bases, TSA models, vendor files) to create a clear, consistent baseline for each deal.
• Analyse and structure cost data to identify stranded costs, cost drivers, risks, and potential mitigations.
• Develop automated dashboards and reporting packs, enabling leadership to track stranded costs, TSA cost recovery, deal impacts, and variances across the M&A pipeline.
• Collaborate with the M&A technology project team and functional SMEs to define scope, requirements, and data needs.
• Refine and document business and technical requirements, ensuring alignment across finance, technology, operations, and programme teams.
• Support completeness of pre‑completion tasks, including data validation, cutover readiness, scenario analysis, and governance reporting.
• Conduct data testing and checks to ensure accuracy prior to completion and hypercare.

Qualifications

• Bachelor’s degree in Business, Finance, Data / Analytics, or related field.
• Prior bp or energy sector experience helpful but not essential.
• Experience with dashboarding (Power BI), advanced Excel, or automation tools preferred.

Skills

• Exceptional analytical and data consolidation skills, able to interpret complex financial and operational data and generate actionable insights.
• Strong data structuring and modelling capability, including building repeatable templates across deals.
• Ability to automate reporting and build dynamic dashboards for leadership.
• Requirements management – ability to capture, document, and manage evolving deal needs.
• Strong project coordination skills; familiarity with Agile / Scrum beneficial.
• Excellent communication and stakeholder engagement.
• Ability to manage cross-border work with attention to regulatory and data‑handling requirements.
• Strong discipline in tracking risks, issues, and progress, with clear reporting.