Senior Business Insights Analyst

Philo•San Francisco, CA

1d•$125,000 - $180,000•Remote

About The Position

Philo is seeking a Senior Business Insights Analyst to improve business decision-making through rigorous analysis, trusted metrics, and strong cross-functional partnership. This high-impact individual contributor will own recurring KPI reporting, investigate ambiguous ad-hoc questions, and present clear, decision-ready recommendations to senior stakeholders. The role is a strategic analytical partner across the business, with particular ownership of billing and subscription analytics, including trials, conversion, renewals, churn, reactivation, plan migration, add-on behavior, pricing and packaging, refunds and credits, failed payments, involuntary churn, and direct versus partner billing experiences. The analyst will also support a broad range of business questions across Finance, Product, Growth, Lifecycle Marketing, Content, Customer Experience, Operations, and technical teams. Work may include analyzing revenue variances and packaging scenarios, customer funnels and acquisition quality, engagement and content performance, account and billing pain points, and retention opportunities. The role requires translating business questions into analytical plans, findings, and recommendations; communicating insights in executive-ready materials; and improving the quality and trustworthiness of business data in partnership with analytics and data engineering teams. Philo is a streaming service offering paid plans, premium bundles, add-ons, and free channels. The position is full-time and may be based in San Francisco, California, or remotely within the United States. Compensation includes annual salary, company stock options, and health benefits. Listed salary ranges vary by location: $145,000–$180,000 in San Francisco or New York City; $135,000–$170,000 in Boston, the DC Metro area, Los Angeles, or Seattle; $130,000–$160,000 in Denver, Atlanta, Austin, Las Vegas, Sacramento, or Chicago; and $125,000–$155,000 in Texas or Florida.

Requirements

At least 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 datasets.
Strong experience building data visualizations, dashboards, and self-serve reporting environments using BI tools such as Mode, Omni, Tableau, or Looker.
Proven ability to turn 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 varied levels of technical fluency.
Strong stakeholder partnership skills and ability to influence across Product, Finance, Marketing, Content, Operations, and technical teams.
Strong ownership and prioritization skills, including the ability to manage competing requests, distinguish urgent from important, and independently drive work forward.

Nice To Haves

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, and candidates should be comfortable with Python or willing to ramp up.
Deep familiarity with subscription business metrics, including 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, or GrowthBook, or similar tools.

Responsibilities

Own and evolve core business scorecards, dashboards, and ad-hoc analyses used to monitor 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.
Develop deep expertise in billing and subscription analytics, including trials, conversion, renewals, churn, reactivation, plan migration, add-on attach, refunds, credits, failed payments, involuntary churn, and direct versus partner billing.
Identify operational and product levers that improve subscriber health, reduce friction, and strengthen revenue retention across the customer 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 insights across the viewing and account experience.
Partner with Content, Programming, and Marketing to assess how channels, titles, and viewing patterns affect acquisition, engagement, retention, upsell, and free-to-paid conversion.
Support customer-facing and operational teams with analysis of support contact drivers, account issues, billing friction, and subscriber pain points.
Create executive-ready materials that connect metrics to a clear narrative, synthesize tradeoffs, and support decisions by technical and non-technical stakeholders.
Partner with analytics engineering and data engineering to improve instrumentation, metric governance, source-of-truth logic, and data quality.
Raise analytical standards through clear documentation, thoughtful prioritization, and a pragmatic balance of speed and rigor.

Benefits

Full health, dental, and vision coverage for the employee and their family.
401(k) plan with employer contributions: 100% match on deferrals up to 3% of pay and 50% match on 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 for taking a two-week vacation.
$5,250 annually for professional development and educational assistance.
Home office and TV stipend of $1,250 during the first year and $250 annually thereafter.
$500 per month bonus for employees who commit to working at least three days per week in an office.
Commuter benefits of up to $315 per month toward transit, rideshare, bike rental, or parking at the San Francisco headquarters.
Free Gympass subscription with access to gyms, studios, classes, training, and wellness apps.
Dog-friendly office.
Annual salary, company stock options, and health benefits.