Senior Business Intelligence Analyst

Senior Business Insights Analyst

We’re looking for a Senior Business Insights Analyst to help Philo make better, faster decisions through rigorous analysis, trusted metrics, and strong cross‑functional partnership. This is a high‑impact individual contributor role for someone who is equally comfortable owning recurring KPI reporting, diving into ambiguous ad‑hoc questions, and presenting clear, decision‑ready recommendations to senior stakeholders.

Responsibilities

• Own and evolve the core business scorecards, dashboards, and ad‑hoc analyses leaders use to monitor subscriber growth, revenue, billing health, retention, engagement, content performance, and monetization trends.

• Translate ambiguous questions from stakeholders into structured analytical plans, clear findings, and actionable recommendations that inform real decisions.

• Build deep expertise in Philo’s billing and subscription ecosystem, including trials, conversion, renewals, churn, reactivation, plan migration, add‑on attach, refunds, credits, failed payments, involuntary churn, and direct vs. partner billing flows.

• Identify the 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, promotional effectiveness, winback programs, and LTV/CAC context.

• Partner with Product, Design, and Data Science on customer journey analysis, feature adoption, experimentation readouts, and insight generation across the viewing and account experience.

• Partner 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 where analytical clarity can improve the customer experience.

• Build executive‑ready materials that connect numbers to narrative, synthesize tradeoffs, 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; our team primarily uses Python, so candidates should be comfortable working in Python or willing to ramp up.

• Deep familiarity with subscription business metrics such as trials, conversion, churn, retention, winback, 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 (we match 100% of deferrals up to 3% of pay and 50% of the next 2% of pay)

• Flexible working hours

• Up to 20 weeks of fully paid parental leave

• Unlimited paid time off for vacation and sick leave

• $2,000 annual vacation bonus (we pay you to take a two week vacation)

• $5,250 annually for professional development and educational assistance

• $1,250 annual home office + TV stipend during first year of employment ($250 annually thereafter)

• $500/month ($6,000/year) bonus for employees who commit to working at least 3 days per week in our offices, plus generous commuter benefits ($315/month towards transit, rideshare, bike rental, or parking at our HQ office in San Francisco)

• Free Gympass subscription — an all‑in‑one corporate benefit that gives employees the largest selection of gyms, studios, classes, training and wellness apps

• Dog‑friendly office

Status and Compensation

Full‑time

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

Compensation includes annual salary, company stock options, and health benefits.

• San Francisco, New York City: $145K - $170K

• Boston, DC Metro, Los Angeles, Seattle: $135K - $160K

• Denver, Atlanta, Austin, Las Vegas, Sacramento, Chicago: $130K - $155K

• Texas, Florida: $120K - $145K

EEO and Diversity Statement

Philo is proud to be an Equal Opportunity Employer. We’re committed to supporting every candidate and employee. If you need an accommodation at any stage of the process, please email recruiting@philo.com and we’ll work with you to meet your needs.

We value a diverse and inclusive workplace and we welcome people of different backgrounds, experiences, skills, and perspectives.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

For California Residents: Philo’s CCPA Notice at Collection – Employees, Applicants, Owners, Directors, Officers and Contractors