NBC Universal Planning Analyst in New York, New York

Job Number 34274BR

Job Title Planning Analyst

Business Segment Ad Sales

Sub-Business Ad Sales Strategic Planning

Posting Category Sales

About Us NBCUniversal is one of the world’s leading media and entertainment companies in the development, production, and marketing of entertainment, news, and information to a global audience. NBCUniversal owns and operates a valuable portfolio of news and entertainment television networks, a premier motion picture company, significant television production operations, a leading television stations group, and world-renowned theme parks. NBCUniversal’s policy is to provide equal employment opportunities to all applicants and employees without regard to race, color, religion, creed, gender, gender identity or expression, age, national origin or ancestry, citizenship, disability, sexual orientation, marital status, pregnancy, veteran status, membership in the uniformed services, genetic information, or any other basis protected by applicable law.

Career Level Experienced

Country United States

State/Province New York

City New York

Responsibilities

  • The ADU Analyst will maintain the list of All Guaranteed Deals by unique News Property & prioritize then allocate the ADU’s monthly in order to efficiently write down the News Liability balance.

  • Assist in Developing Internal (ADU) & External (Selling) Rate Cards

  • Maintain & Update Changes to Rate Cards in On-Air System

  • Create ,Maintain & Update weekly Excel ADU Shell for Rating Projection & Schedule ChangesManage, Track, & Support ADU Shell Stewardship Deal By Deal

  • Work closely with Inventory Manager & Directors of Planning to Develop Strategy for Marketplace ADU Placement

  • Work with Ad Sales & Program Research in Analyzing Actual & Forecasted Rating Trends & Impact to Guaranteed Booked Sales

  • Allocates ADU Allocation as Required to Maximize Inventory Yield Based on Sellout, Demo Skew, & Frequency. Consider Cross Network ADU’s & Non Traditional Inventory as alternative efficiencies

  • Work closely with ASR’s to ensure ADU Package Have Been Booked Properly & Timely in the On-Air System

  • Provide Weekly, Monthly, Quarterly ADU Net Position via On-Air Stewardship Tool to the Ad Sales Teams

  • Provide Quarterly Budget Reviews & Quarterly Closing ADU Net Position to the Finance Team

  • Provide Cross Net ADU Value Impact

  • Provide Ad-hoc Makegood Inventory Value Analytics

  • Support Planning, ASR’s, Inventory Teams, As Needed

Qualifications/Requirements

  • Strong Attention to Details, Demonstrated Analytical Modeling & Media Math Knowledge

  • Excellent Time Management Skills , Problem Solving Skills, Ability to Multi-Task, CreativeManage High Work Volume & Meet All Established Guidelines

  • Strong People Skills & Ability to Partner EffectivelyBroadcast Network & Cable Ad Sales Planner / ASR or Ad Sales Finance Experience

  • Knowledge of On-Air, Nielsen , MSA, Digital, TADProficiency Using Microsoft Excel & Power Point

  • Bachelor's Degree

We are an equal opportunity employer, offering a great work environment, challenging career opportunities, professional training and competitive compensation. Clickto view the NBCUniversal Candidate Privacy Statement.