Commercial Analyst

  • Location: London, England, United Kingdom
  • Salary: GBP50000.00 - GBP55000.00 per annum
  • Job Type: Full time

A finance role focussed around supporting the sales department of the client. The role is responsible for analyzing and then presenting management information to stakeholders in the Sales Operations team, as well as driving commercial decisions through specific financial analysis. The ideal candidate will possess superlative analytical skills and excel modelling (macro), as well as highly developed interpersonals, which will allow them to build long lasting and productive relations with the sales team.

Commercial Sales Analyst

Reporting to the Head of Commercial and Sales Planning, the Commercial Sales Analyst will support the direct sales structures, third party sales structures and ultimately the Global Sales Director, as well as providing targeted dotted line support to the Sales Ops, Finance Operations and the Executive Leadership Team (ELT).
The Analyst will be responsible for supporting all colleagues across that spectrum with regards to providing detailed Operational Information, Sales Intelligence and Management Insight, but at the same time working with the relevant individuals in order to ensure a 'self-serve' culture around information is facilitated and adopted. As well as providing this actionable insight, the candidate will also deliver specific commercial analysis in order to drive informed business decisions.
Working with the Head of Commercial & Sales Planning and the existing Commercial Sales Analysts, some of the specific deliverables will be (although not exhaustive):

  • Production and circulation of the existing Information/ Intelligence/ Insight portfolio in line with the agreed schedule and cadence
  • Design and delivery of new schedules to enrich the existing portfolio and drive the business forward
  • Further developing a 'self-serve' culture, and providing the relevant tools/ dashboards to continue that shift
  • Data gathering/ mining from internal databases
  • Cultivating a working relationship with the sales teams and leaders in order to provide commercial information and support aimed at delivering and over delivering their targets
  • Specific commercial projects aimed at checks and balances e.g. discount analysis
  • Ad hoc data pulls and queries from the Sales Community

Qualifications and experience:
Advanced Excel:

  • Ability to aggregate and manipulate large amounts of data from varying sources and to present it in an accessible and consumable format
  • Experience in building statistical models to provide management information
  • Working knowledge of VBA (can record and execute macros)

SQL Server:

  • Basic working or self-taught understanding of relational databases and SQL Server queries

Other desirable technical proficiencies:

  • Experience with Salesforce CRM system and reporting tools; Qlikview, SAP etc


  • High level of numerical and analytical skills, with an excellent attention to detail
  • Confidence to liaise with senior individuals, in order to ensure their requirements are accurately gathered and interpreted
  • A proactive attitude and ability to use initiative is expected, along with a clear desire to learn more and expand upon your existing knowledge
  • Ability to work to deadlines
  • Excellent timekeeping

McGregor Boyall is an equal opportunity employer and do not discriminate based on race, religion, gender, age, sexuality, gender identification, or physical ability.