Commercial Analyst

Company: Macdonald & Company
Apply for the Commercial Analyst
Location: London
Job Description:

Overview

In this role you will transform data into actionable insights to support commercial decisions across pricing, asset performance and financial planning. You will build dashboards, reports and models to improve visibility and enable both operational and strategic priorities. You will work with cross‑functional teams and regions to validate data, identify trends, and contribute to business cases that drive efficiency and value. You will interpret data through a commercial lens and embed BI into everyday decision‑making, with a clear focus on impact and governance.

Responsibilities

  • Develop and maintain BI tools and reporting frameworks to support commercial decision‑making across pricing, asset performance, and customer engagement
  • Ensure data collection, structuring and presentation are consistent and comparable across teams and markets
  • Support analysis of sales performance and its impact on asset‑level and portfolio metrics
  • Contribute to customer segmentation, pricing analysis, and asset planning by preparing datasets and reports
  • Use BI tools to explore key drivers of return across Capex, Opex, pricing, and delivery models
  • Build and maintain dashboards and visual reports for forecasting, scenario planning, and performance tracking
  • Assist in interpreting data to support commercial decisions and answer questions about asset and portfolio performance
  • Utilize analytics platforms (Power BI, Tableau, Excel) to build and update reports and dashboards

Key requirements

  • Strong ability to support BI activities that drive commercial clarity and operational insight
  • Proficient with Power BI, Tableau, or Excel to present data clearly
  • Ability to build and maintain dashboards for business reviews and performance tracking
  • Experience organizing and formatting data for executive reporting
  • Capable of linking data to business goals and understanding analytics’ impact on decision making
  • Comfortable working with financial and operational datasets across multiple geographies
  • Basic understanding of pricing analysis, customer segmentation and performance metrics
  • Strong understanding of P&L, cost structures, and profitability drivers
  • Curious and commercially minded
  • Strong analytical and data‑driven mindset
  • Collaborative and cross‑functional communication
  • Power BI
  • Tableau
  • Excel

…

Posted: October 6th, 2026