Senior Analyst, Client Reporting

Senior Analyst, Client Reporting

Publicis Groupe is a global leader in communication and is positioned at every step of the value chain, from consulting to execution, combining marketing transformation and digital business transformation. Through a unified and fluid organization, Publicis Groupe partners with its clients across communication, media, data and technology to ensure access to the full breadth of capabilities in every market. Present in over 100 countries, Publicis Groupe employs around 103,000 professionals.

The Senior Client Reporting Analysts reports directly to the Client Reporting Associate Manager. This position will partner with the Finance Directors and Client Finance Leads within the Brands of Publicis North America to oversee all financial aspects related to a given client or group of clients. The Sr. Analyst should have a strong understanding of the general accounting principles, be self-motivated, and have strong intra-departmental communication skills.

Responsibilities include:

• Create/review accurate Burn Reports to compare actual hours vs budget and escalate to Client Finance Lead
• Partner with accounting team to submit revenue entries during month end calculating based on time & materials, percent of completion, etc.
• Responsible for mid-month revenue estimates (flash) in order to see where the client(s) is tracking for month end and flagging when there is a significant variance;
  Assist in the development of revenue targets for assigned clients.
• Work with HFM team & client finance leads to load accurate revenue forecasts for annual and rolling budgets
• Reconcile Revenue/client costs within the general ledger and explain variances in results vs forecasts
• Reconcile time reports for missing time and errors in coding
• Review WIP, A/R, and accrued revenue aging on a monthly basis. Ensure Client Account Teams are aware of current A/R and WIP aging status and partner with CBM team to ensure appropriate follow-up.
• Ensure job setup is properly completed to reduce system issues
• Ensure Agency is in compliance with current contractual guidelines for each client.
• Assist with external and internal audits
• Creating and managing job codes and POs, requesting and approving POs, sending POs to internal and external parties, managing vendors and contractors, handling contractor requests such as new vendor setups and account changes, and approving invoices for payment while maintaining trackers.
• Responsibilities include managing intercompany agreements and billing, updating billing trackers with statements of work and POs, communicating with billing teams, reviewing invoices, calculating time and materials (T&M) billing, weekly hours reporting, preparing month-end forecast files and journal entries, understanding accruals and deferrals, attending forecast meetings, updating forecasting tools like Anaplan, and assisting with audits.
• Duties include updating rate cards and cost rates in internal systems, reviewing and approving plans, various reporting tasks such as CPR/margin reporting, revenue aging, job status, weekly aging, handling miscellaneous ad hoc reporting requests, managing a finance inbox including responses to internal, client, and vendor requests, and direct communication with contractors and clients on billing questions.

Qualifications include:

• Resilient problem solver - Has the foresight to recognize problems with postings/data, can resolves issues efficiently, and knows when to seek guidance from others
• Ability to prioritize and handle multiple tasks in a changing and fast paced work environment
• Excellent written/verbal communication skills, and organizational skills to work according to fixed calendar cycles
• Ability to work independently is a must, as well as in team environment
• Dedicated to meeting others' expectations and requirements
• Advanced in Microsoft Excel to streamline and make reports more efficient using functions and formulas, i.e. vlookups, if, sumif, pivot tables, charts/graphs, etc.
• Experience in SAP and Hyperion HFM is a plus.
• 2- 3 years of Client Finance experience preferably within Advertising, Marketing and Communications
• Potentially supervise 1-2 staff members

Additional…