M&A Business Analyst

Harvey Nash; Glasgow; Hybrid; GBP 80,000 - 100,000; Full time

Job summary

A consulting firm is seeking an M&A Business Analyst based in Sunbury on Thames for a hybrid role. The analyst will provide operational support across various divestments, focusing on stranded cost analysis and report automation. Candidates must have a relevant bachelor's degree, with analytical abilities to interpret complex data. Experience in the energy sector is beneficial, along with skills in Power BI and Excel. This role includes developing dashboards, supporting project teams, and ensuring accuracy in data handling.

Qualifications

• Bachelor’s degree in a relevant field is required.
• Energy sector experience is helpful but not essential.
• Preferred experience with dashboarding and automation tools.

Responsibilities

• Pull data from various sources to establish a clear baseline for deals.
• Analyse cost data to identify stranded costs and potential risks.
• Develop dashboards and reporting packs for tracking M&A activities.
• Collaborate with project teams to define requirements.
• Support pre-completion tasks and ensure data accuracy.

Skills

Analytical skills

Data consolidation

Dashboarding (Power BI)

Advanced Excel

Project coordination

Communication

Education

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

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.