Senior Business Intelligence Analyst

About Philo Philo is a modern TV company that combines high‑quality streaming technology with a clear focus on value, simplicity, and the viewing experience. The product includes paid subscription plans, premium bundles, add‑ons, and a free‑channel experience, operating across subscription, billing, content, and product departments in a rapidly evolving media landscape. Location San Francisco, CA or remote within the U.S. Role Senior Business Insights Analyst. This high‑impact, individual‑contributor position requires rigorous analysis, trusted metrics, and strong partnership across the organization. The analyst owns recurring KPI reporting, tackles ambiguous ad‑hoc questions, and presents decision‑ready recommendations to senior stakeholders. The role has deep ownership of billing and subscription analytics—trial conversion, churn, plan migration, pricing performance, and comparative billing models—and extended influence across Finance, Product, Growth, Content, and Customer Experience. Responsibilities Own and evolve core business scorecards, dashboards, and ad‑hoc analyses for monitoring subscriber growth, revenue, billing health, retention, engagement, content performance, and monetization trends. Translate ambiguous stakeholder questions into structured analytical plans, clear findings, and actionable recommendations that inform real decisions. Develop deep expertise in Philo’s billing and subscription ecosystem, including trials, conversions, renewals, churn, reactivation, plan migration, add‑on attach, refunds and credits, failed payments, involuntary churn, and direct vs. partner billing flows. Identify operational and product levers that improve subscriber health, reduce friction, and strengthen revenue retention across the lifecycle. Partner with Growth and Lifecycle Marketing on acquisition quality, funnel performance, cohort health, promotion effectiveness, win‑back programs, and LTV/CAC context. Collaborate with Product, Design, and Data Science on customer journey analysis, feature adoption, experimentation readouts, and insight generation across the viewing and account experience. Work with Content, Programming, and Marketing to understand which channels, titles, and viewing patterns drive acquisition, engagement, retention, upsell, and free‑to‑paid conversion opportunities. Support customer‑facing and operational teams with insights into support contact drivers, account issues, billing friction, and subscriber pain points to improve the customer experience. Build executive‑ready materials that connect numbers to narrative, synthesize trade‑offs, and help technical and non‑technical stakeholders make decisions with confidence. Improve the quality and trustworthiness of business data by partnering with analytics engineering and data engineering on instrumentation, metric governance, source‑of‑truth logic, and data quality issues. Help raise the analytical bar across the organization through clear documentation, thoughtful prioritization, and a pragmatic balance of speed and rigor. Key Qualifications 6+ years of experience in business insights, analytics, strategy analytics, finance analytics, business intelligence, or a closely related function. Advanced SQL skills and experience working with large‑scale behavioral, subscription, billing, financial, or operational data sets. Strong experience building data visualizations, dashboards, and self‑serve reporting environments in BI tools such as Mode, Omni, Tableau, Looker, etc. A proven track record of translating vague business questions into clear analyses, sharp recommendations, and polished decision‑ready narratives and presentations. Excellent spreadsheet skills in Excel or Google Sheets. Strong analytical fundamentals across cohort analysis, funnel analysis, segmentation, retention and churn analysis, trend analysis, KPI design, forecasting support, anomaly detection, and practical experimentation or quasi‑experimental measurement. Excellent written and verbal communication skills, including experience presenting to senior stakeholders with different levels of technical fluency. Strong stakeholder partnership skills and the ability to influence across Product, Finance, Marketing, Content, Operations, and technical teams. A strong sense of ownership and prioritization: you can manage competing requests, separate urgent from important, and independently drive work forward. Ideal Qualifications Experience in subscription, streaming, media, entertainment, ad‑supported products, or another event‑rich consumer business. Experience using Python or R for deeper ad‑hoc analysis, automation, or statistical workflows; the team primarily uses Python. Deep familiarity with subscription business metrics such as trials, conversion, churn, retention, win‑back, LTV, plan mix, and add‑on attach. Experience with billing, payments, dunning or retry flows, refunds and credits, and direct or partner‑billing analytics. Experience with content, engagement, lifecycle marketing, or free‑to‑paid funnel analytics in a consumer product environment. Familiarity with modern data platforms and event‑tracking environments such as Snowflake, dbt, Segment, Avo, GrowthBook, or similar tools. Benefits Full health, dental and vision coverage for you and your family 401(k) plan with employer contributions (match 100% of deferrals up to 3% of pay and 50% of the next 2% of pay) Up to 20 weeks of fully paid parental leave Unlimited paid time off for vacation and sick leave $2,000 annual vacation bonus that encourages a two‑week vacation $5,250 annually for professional development and educational assistance Stipends for home office, TV, and commuter costs up to the first year of employment Bonus for employees working at least 3 days per week in our offices, plus commuter benefits Free Gympass subscription for physical fitness and wellness benefits Compensation Includes an annual salary, company stock options, and health benefits. Salary ranges by location are: Denver, Atlanta, Austin, Las Vegas, Sacramento, Chicago: $130K – $155K Texas, Florida: $120K – $145K EEO Statement Philo is an equal opportunity employer. We believe our strength comes from diverse perspectives and backgrounds. We welcome applicants of all genders, ages, significance notes, races, religions, ethnicities, and nationalities. We welcome etc. (any text describing that we comply with EEO, need to keep legally required statement). #J-18808-Ljbffr