Analyst – Media & Subscription Forecasting Location: Hybrid (3 days on-site, 2 remote) at Universal City, CA Duration: 12-month W2 contract (potential for extension or conversion) Industry: Media / Entertainment / Streaming Pay Rate: USD 55 /hr. - USD 75.00+ /hr. depending on experience Start Date: ASAP About the Role: Our Fortune 500 Media client is seeking a highly skilled Data Analyst with strong experience in financial modeling, forecasting, and SQL. This person will work cross-functionally with Finance, Content, and Strategy stakeholders to drive insights that inform key business decisions for a subscription-based streaming platform. You will independently extract and shape data, build complex models, and generate reports that guide the direction of revenue, subscription growth, and content strategy. Key Responsibilities: • Develop and maintain complex financial models for forecasting, scenario planning, and performance evaluation. • Extract, interpret, and analyze data using SQL and Excel, focusing on forecasting and revenue reporting. • Conduct cohort analyses, churn modeling, and lifetime value forecasting to support subscription business strategy. • Deliver ad hoc analysis and reports tailored to stakeholder needs. • Present findings to business and finance leaders, providing clear data-driven insights. • Partner with finance and business teams to analyze and quantify the impact of various revenue scenarios. • Act as a self-sufficient analyst, pulling and shaping data independently without reliance on data engineering teams. • Participate in stakeholder meetings and cross-functional collaboration, aligning with company forecasting goals. Required Qualifications: • Bachelor’s degree in a STEM field (e.g., Economics, Mathematics, Computer Science, Engineering, Finance); bootcamps or micromasters with SQL/finance focus considered. • 3–6+ years of relevant experience in roles like: Data Analyst, Financial Analyst, Forecasting Analyst, etc. • Advanced SQL skills – Ability to query and manipulate large datasets independently. • Advanced Excel modeling – Forecasting, scenario planning, and financial projections. • Experience in media, entertainment, or streaming preferred. • Strong business acumen and understanding of subscription-based revenue models. • Comfort communicating insights to non-technical stakeholders. • Familiarity with tools like PowerPoint for executive-ready reporting. Nice-to-Haves: • Experience with building data pipelines or working closely with data engineers. • Exposure to content analytics or creative performance evaluation. • Consulting or deal analysis background. • Familiarity with tools like Tableau, Looker, or other BI platforms. • Experience in evaluating the effectiveness of marketing, promotions, or original content based on financial performance. Top 3 Must-Have Skills: • SQL (independent coding & data extraction) • Excel Financial Modeling / Forecasting • Business-minded approach to Financial/Revenue Analysis Additional Details: Schedule: Hybrid – 3 days onsite (Tues–Thurs) Location: Universal City, CA Contract Type: W-2 Potential: Conversion to FTE or long-term extension for the right candidate