M&A Business Analyst

Harvey Nash; Leeds; Hybrid; GBP 45,000 - 70,000; Full time

Job summary

A leading consulting firm is seeking an M&A Business Analyst in a hybrid role based in the UK. This position involves providing analytical support across multiple divestments, focusing on stranded cost analysis and automated reporting. The ideal candidate will hold a Bachelor’s degree in Business or a related field, and have strong skills in data consolidation and dashboarding, particularly with Power BI. This role offers a collaborative environment with cross-functional teams to facilitate decision-making and high-quality analysis throughout the M&A lifecycle.

Qualifications

• Bachelor’s degree in a relevant field required.
• Prior experience in the energy sector advantageous.
• Experience with dashboarding and automation tools preferred.

Responsibilities

• Create a consistent baseline for each deal using multiple data sources.
• Analyse cost data to identify stranded costs and risks.
• Develop automated dashboards to track stranded costs and deal impacts.
• Collaborate with project teams to define scope and requirements.
• Refine and document business and technical requirements.
• Support pre-completion tasks including data validation and governance reporting.
• Conduct data testing to ensure accuracy.

Skills

Analytical skills

Data consolidation

Dashboarding (Power BI)

Advanced Excel

Project coordination

Communication

Education

Bachelor’s degree in Business, Finance, Data / Analytics

Tools

Power BI

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.