M&A Business Analyst

Harvey Nash; Birmingham; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading consulting firm is seeking an M&A Business Analyst to provide analytical and operational support in divestments, concentrating on stranded cost analysis and data consolidation. The role includes developing automated dashboards, collaborating with project teams, and ensuring high-quality analysis throughout the M&A lifecycle. Ideal candidates will have a bachelor's degree in a related field, experience in the energy sector, and strong analytical skills, with proficiency in Power BI and advanced Excel.

Qualifications

• Bachelor’s degree in a relevant field.
• Experience in the energy sector is a plus.
• Proficient in dashboarding and automation tools.

Responsibilities

• Pull together data from various sources to create a deal baseline.
• Analyze cost data to identify stranded costs and risks.
• Develop automated dashboards for leadership tracking.
• Collaborate with project teams to define data needs.
• Document business and technical requirements.
• Support pre-completion tasks including data validation.
• Conduct data testing for accuracy.

Skills

Analytical skills

Data consolidation

Dashboarding (Power BI)

Advanced Excel

Project coordination

Communication

Agile / Scrum

Education

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

Tools

Power BI

Automation tools

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.