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. 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
 

Qualifications
Basic Qualifications:

Bachelor’s degree in relevant quantitative field (e.g. Business Analytics, Data Science, Computer Science, Statistics, Mathematics, Economics, or other)
Familiarity with subscription business KPIs and metrics (TV& streaming subscription metrics is a plus)
Strong Proficiency in SQL, Microsoft Excel, and Microsoft PowerPoint
Working knowledge of Python & Databricks
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 presenting to senior executive audiences preferred)
Experience in data-visualization tools
Desired Characteristics:

Experience working at a subscription business analyzing subscriber data sets
Experience with statistical modeling and/or advanced data science techniques