Commercial Analyst

Overview

An exciting opportunity has arisen for an experienced Commercial Analyst to join our Commercial Hub.

This role is part of a vibrant team driving improvements in our commercial activities, introducing digital and efficient procurement practices. You will collaborate directly with the Senior Management Team, providing commercial intelligence and clear analysis to stakeholders.

As Commercial Analyst, you will be responsible for managing the council’s major categories of expenditure, creating opportunities to improve, leverage and drive best practice procurement across an annual revenue spend of more than £340M.

• Support all procurement‑related systems, acting as the lead user on the council’s e‑procurement software.
• Produce performance dashboards and reports, and illustrate data in formats suitable for Senior Management Reports.
• Identify, collect, migrate and transform data from a variety of internal and external systems, linking different data sets as required.
• Source new datasets for Local Authorities from open sources and other data returns.
• Collaborate with the Senior Management Team and other operational team activities; act as an adaptable communicator and influencer.

Essentially a remote working post, occasional attendance at the Council Offices in Ealing, W5, will be expected.

• Strong Excel, Power BI and PowerPoint skills.
• Producing performance dashboards and reports.
• Experience of identifying, collecting and migrating data to/from a range of internal and external systems to transform, manipulate and link different data sets as required.
• Sourcing new datasets for Local Authorities from a variety of sources.
• Strong analytical ability, including analysis of data sets.
• Excellent numeracy skills.
• Experience of e‑procurement and finance systems.

This role is deemed customer facing and as such you must have a command of spoken English which is sufficient to enable you to effectively perform the role. This requirement relates to Part 7 of the Immigration Act 2016.

We therefore welcome applications from all residents of the borough, particularly from candidates who are entering the employment market in the early stages of their career and mid‑career professionals, who are currently underrepresented in Ealing’s workforce.

This role is subject to Ealing Council’s enhanced vetting process.