Commercial Analyst

BRAND: Publicis Groupe
Job Function: Finance
Location: London, United Kingdom
Experience Level: Intermediate
Workplace Type: Hybrid

Company description

OVERVIEW
Publicis Groupe is one of the world's largest communications holding companies, present in over 110 countries and employing about 100,000 professionals.. The Groupe is positioned at every step of the value chain, from consulting to execution, combining marketing transformation and digital business transformation.

HELPING OUR CLIENTS UNLOCK GROWTH IN THE PLATFORM WORLD
Our clients compete in the platform world, a horizontal marketplace between creators and consumers, between speakers and listeners, between buyers and sellers. To thrive in the platform world, companies must continue to innovate their products and business models. Four imperatives (1. Real Identity, 2. Dynamic, Diverse and Disruptive Creativity 3., Smart Media and 4. Direct Relationships) via our suite of world-class agencies, are necessary for modern brands to win in the platform world. At Publicis Groupe, we've invested in capabilities across these four imperatives our clients need to unlock growth. As the only one who can architect, build and orchestrate end to end solutions, not only do we have a proven record of building bespoke models for clients and leading expertise across all major industry categories, we are able to offer our talents more opportunities to grow and benefit from a richer learning experience. We call this Power of One. Powered by a 100,000-strong network via Marcel, our AI-based platform, we are also able to provide our clients and talents instant access to resource, knowledge for any need, any time, in any market.

THE SPIRIT OF VIVA LA DIFFERENCE
Viva La Difference is deeply rooted in everything we do. It has always been in our DNA. From the birth of Publicis, 94 years ago, when Marcel Bleustein-Blanchet, our founder, invented French advertising. Viva La Difference expresses how we value and respect each individual and recognize what makes us distinctive. This is the charge that inspires our teams to celebrate the differences in identity, background, culture, and experience of all of us. It is how we behave with each other and our clients, and it is deeply rooted throughout our work, to elevate and bring to life our differences throughout the platform world.

Overview

About the role

This role will be supporting Leos in London, reporting directly to the Senior Commercial Analyst and Commercial Finance Director and working closely with key stakeholders across Leos. You will collaborate with other finance teams across Publicis Groupe and is a great opportunity for someone who has the ambition to develop their career with a fast-growing company.

About the candidate

You will need to have good attention to detail, a strong understanding of accounting principles and be a confident and able excel user. Also enjoy working with people and playing an important role in a team. Furthermore be interested in developing your accounting, analytical and commercial skills. You will need to have some experience of working in an organisation in a finance role and be ready to take your next step and build your career.

Your responsibilities will include:

Forecasting

• Prepare annual revenue budgets across a portfolio of clients, including understanding the client's remuneration terms and business model.
• Monthly reforecasting of revenue and resourcing with client leads across creative and production budgets, updating confirmed and pipeline revenue status and aligning on resourcing allocation
• Help identify commercial risks and opportunities across portfolio of clients
• Business partnering with senior management and client leads to achieve agency revenue and KPI's targets
• Prepare revenue reforecast analysis and upload onto Hyperion by deadline

Commercial Analysis

• Partner with business leads to produce client commercial analysis for remuneration discussions, including reviewing team structures
• Analyse timesheet reports to deliver monthly and adhoc client requests and understand over/under-burn of project scopes.
• Support the preparation and maintenance of agency hourly rates.
• Prepare staff utilisation reports for agency resourcing decisions
• Prepare monthly CPR reporting, providing insight and strategic priorities to client leads to improve profitability
• Prepare, analyse and review time and personnel data to produce Publicis Groupe client profitability and utilsation dashboards
• Support Commercial Director with Publicis Groupe project initiatives
• Assist Commercial team with client contract negotiations
• Assist Commercial Director with new business proposals

Month end reporting

• Working with agency client leads and budget controllers to ensure client remuneration is invoiced in a timely manner
• Ensuring revenue recognition process is accurate and aligned with Groupe standards
• Calculate any required revenue accruals and deferrals at month end by analysing client remuneration and project completion status
• Provide commentary on variances for month end Publicis reporting packs
• Review and co-ordinate intercompany recharges for Production projects
• Assist Commercial Finance Director in preparing monthly management reporting packs for senior leadership, including revenue variances, risks and opportunities
• Support any client or Publicis audit requests

Personal qualities and skills

• Forecasting experience preferred
• Clear understanding of accounting concepts and processes
• Strong user of Excel with experience of managing large data files and complex formulas including, pivot tables, vlookups, sumifs, match & index functions.
• Knowledge of Hyperion & SAP preferred
• Can be studying towards an accountancy qualification (ACCA, CIMA)
• Thorough with excellent attention to detail
• Well-organised and tenacious
• Self-starter with a problem-solving attitude
• Commercially aware and able to build complex data models
• Strong Communication skills

#LI-CR1

Additional information

Publicis Groupe operates a hybrid working pattern with full time employees being office-based three days during the working week.

We are supportive of all candidates and are committed to providing a fair assessment process. If you have any circumstances (such as neurodiversity, physical or mental impairments or a medical condition) that may affect your assessment, please inform your Talent Acquisition Partner. We will discuss possible adjustments to ensure fairness. Rest assured, disclosing this information will not impact your treatment in our process.

Please make sure you check out the Publicis Career Page which showcases our Inclusive Benefits and our EAG's (Employee Action Groups).