About the position
Our Direct-to-Consumer (DTC) portfolio is a powerhouse collection of consumer-first brands, supported by media industry leaders, Comcast, NBCUniversal and Sky. When you join our team, you’ll work across our dynamic portfolio including Peacock, NOW, Fandango, SkyShowtime, Showmax, and TV Everywhere, powering streaming across more than 70 countries globally. And the evolution doesn’t stop there. With unequalled scale, our teams make the most out of every opportunity to collaborate and learn from one another. We’re always looking for ways to innovate faster, accelerate our growth and consistently offer the very best in consumer experience. But most of all, we’re backed by a culture of respect. We embrace authenticity and inspire people to thrive. 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.
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 clean, executive-friendly PowerPoint slides explaining trends in Peacock subscriber growth, both for recurring reporting and more one-off ad-hoc needs, with limited hand-on guidance and a high degree of independence
- Interface with existing stakeholders of subscriber model to understand their needs and build model outputs and visualizations tailor-made to those needs
- 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
- Develop end-to-end data pipelines from SQL to Excel/PowerPoint to quickly update analyses and associated slides aimed at answering leadership questions around executive reporting, subscriber growth, and business performance
- 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
- Help contribute to a diverse, equitable, and inclusive work culture at Peacock
Requirements
- Bachelor’s degree in relevant quantitative field (e.g. Business Analytics, Data Science, Computer Science, Statistics, Mathematics, Economics, or other)
- 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 SQL, Microsoft Excel, and Microsoft PowerPoint
- 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 presenting to senior executive audiences preferred)
Nice-to-haves
- 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
Benefits
- Medical insurance
- Dental insurance
- Vision insurance
- 401(k)
- Paid leave
- Tuition reimbursement
- Variety of other discounts and perks
