Senior Manager, Subscriber Forecasting & Strategy, Decision Sciences, Peacock
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