Analyst, Subscriber Forecasting & Strategy

NBCUniversal • New York, NY

9h • $70,000 - $95,000 • Hybrid

About The Position

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

Requirements

• 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

Nice To Haves

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

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

Benefits

• This position is eligible for company sponsored benefits, including medical, dental and vision insurance, 401(k), paid leave, tuition reimbursement, and a variety of other discounts and perks.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Number of Employees: 5,001-10,000 employees