We are seeking an individual to work with a Fortune 50 Broadcast Media & Entertainment leader located in New York, New York. As the Forecasting Analyst, you will be embedded with the Subscriber Forecasting team, which is part of the Advanced Content Analytics department. In this role, you will have the opportunity to help develop short-term and long-term views on growth for the organizations subscriber base, leveraging first and third-party data to discern trends in signups, churn, consumption, and other growth metrics.
Minimum Qualifications:
- Bachelor’s degree in relevant quantitative field (e.g. Business Analytics, Data Science, Computer Science, Statistics, Mathematics, Economics, or other)
- 5+ years of financial modeling experience working with large, complex data sets
- 2+ 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 both SQL and Excel
- 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 in Tableau or an equivalent data-visualization tool is a plus
- Experience with statistical modeling and/or advanced data science techniques is a plus
Responsibilities:
- Become an expert on the organization’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 a new short-term forecasting model in Excel at higher levels of granularity than existing model, with a focus on (1) ability to rapidly change inputs and iterate on various scenarios and (2) ability to rapidly update model with actuals first-party data
- Interface with existing stakeholders of subscriber model to understand their needs and build model outputs and visualizations tailor-made to those needs
- Work with teammates on Forecasting team to answer ad-hoc questions from stakeholders and put together ad-hoc analyses using both the existing model and the re-vamped model as a data input
- Iterate on re-vamped model as needed based on continuously evolving stakeholder needs
- Help contribute to a diverse, equitable, and inclusive work culture
What’s in it for you?
- Working for a well-known, globally leading Media and Entertainment organization
- Opportunity to learn and grow subject matter expertise in video and streaming media.
- Exposure to high-level business professionals in a variety of departments and geographic locations.
- Opportunity to work and grow your career in a fast-paced environment.
