M&A Business Analyst

Harvey Nash; Greater London; Hybrid; GBP 55,000 - 70,000; Full time

Job summary

A leading consultancy firm is seeking an M&A Business Analyst to provide analytical and operational support for divestments. The ideal candidate will have a background in Business or Finance and experience with data consolidation and dashboarding tools such as Power BI. Responsibilities include analyzing costs, developing automated reports, and collaborating with deal teams. This hybrid role offers the opportunity to work in a dynamic environment within the energy sector, with a focus on delivering high-quality analysis throughout the M&A lifecycle.

Qualifications

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

Responsibilities

• Pull together data from multiple sources to create a clear, consistent baseline for each deal.
• Analyse and structure cost data to identify stranded costs and risks.
• Develop automated dashboards and reporting packs for leadership.
• Collaborate with project teams to define scope and data needs.
• Support completeness of pre‑completion tasks including data validation.
• Conduct data testing and checks to ensure accuracy prior to completion.

Skills

Analytical skills

Data consolidation

Dashboard automation

Requirements management

Project coordination

Communication

Education

Bachelor’s degree in Business, Finance, 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.