Analyst, Subscriber Forecasting & Strategy

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. You will play a critical role in understanding our subscriber forecasting models from end-to-end and helping create ad-hoc analyses to help drive model improvements and business understand. The focus areas will be (1) identifying trends to better inform the subscriber models, (2) conducting end-to-end ad-hoc analysis of subscriber and content data, and (3) leveraging SQL to build data pipelines to the feed and optimize existing and new models Key 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 Excel-based forecasting models Become an expert on the operation of existing forecasting models, with the goal of being able to independently tweak assumptions and generate scenario outputs for various stakeholder teams Analyze and synthesize data from multiple sources to produce clear, actionable insights and recommendations, communicating findings through concise data-driven narratives for business stakeholders Work closely with the rest of forecasting team members who are operating and improving forecast models, developing a sufficient understanding of the models’ structures to be able to support those functions at times as needed Build clean, executive-friendly PowerPoint slides explaining trends in Peacock subscriber growth, both for recurring reporting and more one-off ad-hoc needs Partner with a highly collaborative analytics team to deliver insights that drive data‑informed decisions across the NBCU Media Group. Help contribute to an equitable and inclusive work culture