Analyst, Client Reporting

PUBLICIS GROUPE • New York, NY

60d

About The Position

The Client Reporting Financial Analyst reports directly to the Client Reporting Finance Manager/Director. This position will partner with the Finance Directors and Client Finance Leads within the Brands of Publicis Communications North America to oversee all financial aspects related to a given client or group of clients

Requirements

• Resilient problem solver - Has the foresight to recognize problems with postings/data, can resolve 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 and verbal communication skills
• Excellent organizational skills and able 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
• Bachelor's Degree in Accounting or Finance
• Advanced in Microsoft Excel to streamline and make reports more efficient using functions and formulas, (Vlookups, If, SumIf, Pivot Tables, charts/graphs, etc.)
• 1 to 3 years of Client Finance experience preferably within Advertising, Marketing and Communications
• Knowledge in ERP systems, specifically SAP or similar.

Nice To Haves

• Ability to manage large data with use of Macros and VBA is an advantage

Responsibilities

• Work with client finance lead to create accurate revenue forecasts for annual and rolling budgets
• Reconcile Revenue within the general ledger and explain variances in results vs forecasts
• 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
• Create accurate Burn Reports to compare actual hours vs budget and escalate to Client Finance Lead/Finance Director in order to adjust staffing plans or scope
• Assist in pulling revenue reports and calculation of revenue based on time & materials, percent of completion, etc.
• Reconcile time reports for missing time and errors in coding
• Assist with client profitability reports and metrics
• Ensure job setup is properly completed to reduce system issues
• Prepare and review of unbillable client costs
• Assist with preparation of managerial reports to account and executive teams
• Assist with external and internal audits

Benefits

• Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive.
• Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Industry: Professional, Scientific, and Technical Services
• Number of Employees: 5,001-10,000 employees