Job Description
Responsibilities
The Ad Sales Finance team is seeking a new professional to join as the Analyst, Ad Sales Finance – Peacock. This position will be responsible for day-to-day core ad sales financial processes for NBCUniversal's streaming service, Peacock, reporting to the Manager of Ad Sales Finance. We are looking for an exceptional, results-oriented individual who uniquely combines the interpersonal skills to act as a primary liaison between the Ad Sales Finance team and the internal constituents within the Ad Sales and Peacock divisions and exhibits the quantitative skills to analyze and model the financial implications and results of the Peacock entity.
Duties and Responsibilities:
Include, But Are Not Limited To:
Financial Analysis
• Execute weekly sales reporting, pacing and variance explanations against targets
• Track & analyze key metrics (cash pacing, pricing, traffic performance, sell-thru, ARPU)
• Analyze trends to identify risks and opportunities, inform business decisions and strategy
• Provide business and financial trending analytics to support cross-functional teams (Sales, Strategy, Planning, Research) on ad hoc projects & analyses
• Develop and execute monthly financial close process, including coordination with Peacock Finance on journal entries as well as content and distribution revenue shares
Data Management
• Own data gathering (querying, pivoting and synthesizing) of key operational and financial metrics to support reporting and analytical needs
• Become subject matter expert in key systems and upstream/downstream processes influencing data output
• Continually design and implement process improvements to enhance efficiency of data management process and build complex models with standard Excel formulas (e.g. pivot tables, vlook-ups, sum-ifs, index/match, automation of link updates)
Executive Communication
• Support preparation of major deliverables and executive presentations such as weekly financial updates, operating reviews, budget, and long-range plan presentations
• Support preparation of major financial deliverables for Ad Sales, Peacock and Corporate
Qualifications/Requirements
• Four year degree (B.A., B.S.) at an accredited college or university in Business, Accounting or Finance or relevant experience
• 2+ years of finance experience
• Prior experience in a finance role supporting an ad sales function within a media or entertainment company highly desired
• Ability to build financial models (advanced excel skills) and presentations for leadership
• Demonstrated analytical strength and process mindset – ability to identify and resolve key issues quickly
• Ability to prioritize and meet deadlines with accuracy
• Excellent written and oral communication skills
• Proven team player with the ability to take on different assignments in a timely manner
• High energy and ability to multi-task
Jobcode: Reference SBJ-gqo74m-3-229-124-236-42 in your application.