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.

San Francisco, CA or remote within the U.S.

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.

• 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.

• 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…