Marketing Data Analyst

We are seeking a dynamic individual to support a newly independent media company that has recently spun off from a larger parent organization. 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: • 4+ years of experience in Media/Entertainment/Tech industry and with analytical experience working with large, complex data sets and analytical tools • Experience building complex forecasting or financial models that leverage insights from 1st and 3rd party data sets and operate via well informed business assumptions • Advanced SQL coding skills for analytics and data analysis • Expertise in Excel and financial modeling • 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 performance forecasting models across a variety of dimensions & metrics using 1st, 2nd, and 3rd party data • 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.