Sr. Analyst, Client Reporting

Company Description

Publicis Groupe, known for its award-winning creativity, best-in-class technology, digital and consulting expertise, is the world's third largest communications group. With 80,000+ colleagues in over 100 countries, the Groupe has four Solution hubs: Creative with Publicis Communications, Media with Publicis Media, Digital business transformation with Publicis.Sapient, and Health & Wellbeing with Publicis Health.

Since 2014 with the acquisition of Sapient, Publicis Groupe has undergone a profound transformation by scaling a new model connecting data, creativity, and technology. The Groupe has continued this journey with the 2019 acquisition of Epsilon to further scale the data-led offering and provide true momentum to our client's own transformation.

This model, with a country-led approach, is called the "Power of One" and gathers all the capabilities of the Groupe under one roof, putting clients at the core of the organization.

Job Description

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.

Senior Financial Analyst:

• 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

Qualifications

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 CRM software, SAP and Hyperion HFM is a plus.
• 3+ years of Client Finance experience preferably within Advertising, Marketing and Communications
• Potentially supervise 1-2 staff members

Additional Information

All your information will be kept confidential according to EEO guidelines.

Compensation Range: $58,500-92,000. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. For this role, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off.