Revenue Planning Analyst

NBC - Tampa, FL

Full-time

Tampa, FL

Broadcasting and Content Providers

About the position

NBC Sports Next, a division of NBCUniversal, is seeking a Revenue Planning Analyst to support the revenue planning and strategic analysis efforts within the Youth & Recreational Sports (YRS) business. This role is pivotal in assisting with long-range planning and the annual budget process for our service and subscription brands. The Revenue Planning Analyst will play a key role in developing revenue-enhancing strategies and will be responsible for analyzing large datasets using Microsoft SQL Server Management Studio and Amazon Redshift SQL. The ideal candidate will also be proficient in Microsoft Excel to create executive-level summaries of key trends and manage revenue models that support strategic decision-making across various operations teams. In this role, the Revenue Planning Analyst will assist in long-range planning, monthly forecasting, and various ad-hoc requests across the Youth & Rec Sports businesses. They will help translate and distribute internal operating revenue goals to various stakeholders, enhancing cooperation and improving the ability to achieve overall budgetary goals. The analyst will also be tasked with developing revenue-enhancing strategies by utilizing SQL to package data and build Excel-based revenue models that drive optimal decision-making. Additionally, the role involves creating or enhancing automated Tableau dashboards to provide visibility into the performance of NBC Sports Next for Direct-to-Consumer, Sales, Marketing, and Executive leadership. Regular communication of business insights and performance trends with internal business leaders will be a critical aspect of this position.

Responsibilities

• Assist in long-range planning, monthly forecasting, and various ad-hoc requests across the Youth & Rec Sports businesses.
• Translate and distribute internal operating revenue goals for various internal stakeholders to enhance cooperation and improve budgetary goal achievement.
• Develop revenue-enhancing strategies by utilizing SQL to package data and build Excel-based revenue models.
• Create or enhance automated Tableau dashboards to provide visibility into the performance of NBC Sports Next for Direct-to-Consumer, Sales, Marketing, and Executive leadership.
• Regularly communicate business insights and performance trends with internal business leaders.

Requirements

• BS/BA degree in Business Analytics, Finance, Economics, Statistics, Decision Sciences, Management Science, or a related field.
• Proficiency in writing complex SQL queries, stored procedures, and functions, with the ability to optimize existing SQL queries for performance and scalability.
• A minimum of 1+ years of financial or revenue/sales planning & analysis experience.
• Strong critical thinking and problem-solving skills with the ability to work through complex problems.
• Ability to work effectively under pressure and meet tight deadlines.
• Self-starter with a passion for data and using it to drive insights for our businesses.
• Demonstrate a passionate drive for continuous learning and professional growth.

Nice-to-haves

• Advanced skills in Excel and SQL as well as reporting tools like Tableau, R, Business Objects, etc.