Senior Manager, Subscriber Forecasting & Strategy, Decision Sciences, Peacock

Job Description

Job Description
This position will be embedded with the Subscriber Forecasting team, part of Peacock's Advanced Content Analytics department. Peacock's Subscriber Forecasting team develops short-term and long-term views on growth of the Peacock subscriber base, leveraging first and third-party data to discern trends in signups, churn, consumption, and other growth metrics. We work with a broad set of stakeholders across the company to provide insights on the success of growth initiatives and develop long-term growth strategy for both subscribers and revenue. As the complexity of the forecasting process has increased, so has the need for deeper and more insightful analysis to inform forecast inputs and to frame insightful findings to key stakeholders using forecast outputs. You will play a role in broadening the output of the forecasting team, with a focus on (1) developing clear executive-facing narratives using first party data to explain Peacock subscriber growth trends, (2) identifying analytical gaps in our forecasting models that can be informed by additional retrospective analyses, and (3) conducing end-to-end ad-hoc analysis of subscriber and content data from data querying to slide making.

Responsibilities:
• Become an expert on Peacock's first-party growth metrics data and existing data infrastructure underlying it
• Write SQL queries to generate first-party data sets that are tailor-made for feeding an Excel-based forecasting model
• Build a new short-term forecasting model in Excel at higher levels of granularity than existing model, with a focus on (1) ability to rapidly change inputs and iterate on various scenarios and (2) ability to rapidly update model with actuals first-party data
• Interface with existing stakeholders of subscriber model to understand their needs and build model outputs and visualizations tailor-made to those needs
• Work with teammates on Forecasting team to answer ad-hoc questions from stakeholders and put together ad-hoc analyses using both the existing model and the re-vamped model as a data input
• Iterate on re-vamped model as needed based on continuously evolving stakeholder needs
• Help contribute to a diverse, equitable, and inclusive work culture at Peacock
Qualifications
• Bachelor's degree in relevant quantitative field (e.g. Business Analytics, Data Science, Computer Science, Statistics, Mathematics, Economics, or other)
• 6+ years of financial modeling experience working with large, complex data sets
• 3+ years of experience working at a subscription business analyzing subscriber data sets
• Familiarity with subscription business KPIs and metrics (TV& streaming subscription metrics is a plus)
• Strong proficiency in both SQL and Excel
• Strong analytical skills with the ability to interpret data and draw actionable insights
• Proficient in maintaining meticulous records, documenting procedures, and ensuring accuracy in all aspects of work, reflecting exceptional attention to detail
• Excellent verbal and written communication skills
• Experience in Tableau or an equivalent data-visualization tool is a plus
• Experience with statistical modeling and/or advanced data science techniques is a plus
Additional Requirements:
Hybrid: This position has been designated as hybrid, generally contributing from the office a minimum of three days per week.
This position is eligible for company sponsored benefits, including medical, dental and vision insurance, 401(k), paid leave, tuition reimbursement, and a variety of other discounts and perks. Learn more about the benefits offered by NBCUniversal by visiting the Benefits page of the Careers website.
Salary range: $115,000-$165,000 (bonus and long-term incentive eligible).

Jobcode: Reference SBJ-re7030-216-73-216-222-42 in your application.