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