Philo

Senior Business Intelligence Analyst

Philo$145K — $170K *
Business Services
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 6+ years in business insights, analytics, or related field.
  • Advanced SQL skills for large dataset handling.
  • Proficiency in BI tools for data visualization and reporting.
  • Track record of transforming ambiguous business questions into actionable insights.
  • Strong Excel or Google Sheets expertise.
  • Solid understanding of analytical fundamentals like cohort and trend analysis.
  • Excellent communication skills for presenting to senior stakeholders.

Responsibilities

  • Own and enhance core business scorecards and dashboards for monitoring key metrics.
  • Translate ambiguous stakeholder queries into structured analysis and actionable insights.
  • Develop expert knowledge in billing and subscription analytics.
  • Identify operational and product levers to improve subscriber health and revenue retention.
  • Collaborate with Growth and Marketing on performance and acquisition insights.
  • Partner with Product and Data Science for customer journey and feature adoption analyses.
  • Support operational teams with clarity-driven insights to enhance customer experience.

Benefits

  • Comprehensive health, dental, and vision coverage for employees and families.
  • 401(k) plan with substantial employer matching contributions.
  • Unlimited paid time off with flexible hours.
  • Generous parental leave up to 20 weeks fully paid.
  • Annual $2,000 vacation bonus to encourage time off.
  • Substantial educational development budget of $5,250 per year.
  • Home office stipend in the first year and ongoing TV stipend.
  • Bonus for employees working in-office with additional commuter benefits.
  • Free subscription to Gympass for wellness activities.
Full Job Description
The Role

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.

You will serve as a strategic analytical partner across multiple parts of the business, with especially deep ownership in billing and subscription analytics. That includes trial conversion, activation, renewals, churn, reactivation, plan migration, add-on behavior, pricing and packaging performance, refunds and credits, failed payments, involuntary churn, and the differences between direct and partner billing experiences. You will help Philo understand the health of its subscriber base and revenue streams in a way that connects clearly to action.

This role will also touch many other parts of the company. One week you may be helping Finance understand a revenue variance or size a packaging scenario; the next you may be partnering with Product on funnel friction, Growth on acquisition quality and retention, Content on engagement patterns, or Customer Experience on account and billing pain points. The ideal candidate combines analytical depth, business fluency, crisp communication, and a high bar for data quality. They do not wait to be told exactly what analysis to run - they refine the question, frame the decision, and deliver work people trust and use.

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.

Status: Full-time
Location: San Francisco, CA or remote within the U.S.
Compensation: Includes annual salary, company stock options, and health benefits. Salary is determined by experience and location:
  • 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

We value a diverse and inclusive workplace and we welcome people of different backgrounds, experiences, skills, and perspectives. Philo is an equal opportunity employer. We believe that everyone does their best work when they are supported by each other and the company, and we offer a generous set of benefits to make sure the Philo team is happy and healthy. Here is a sampling of the benefits we offer our team:
  • 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
  • And much more!

About Philo

Philo is an American internet television company that offers live TV, on-demand, and DVR capabilities. It is a subscription-based service that allows users to watch live TV channels, as well as record and pause live TV. Philo offers a variety of channels, including entertainment, lifestyle, and news channels. The company was founded in 2009 by Andrew McCollum and Bryan Trussel. Philo is headquartered in San Francisco, California.
Learn more about Philo
Size
100 employees
Industry
Founded
2010

Similar Jobs

More Jobs at Philo

More Business Services Jobs

Find similar Senior Business Intelligence Analyst jobs: