Senior Business Intelligence Analyst

Philo•San Francisco, CA

2d•Hybrid

About The Position

Philo is seeking a Senior Business Insights Analyst to drive better, faster decision-making through rigorous analysis, trusted metrics, and strong cross-functional partnerships. This high-impact individual contributor role requires a blend of owning recurring KPI reporting, tackling ambiguous ad-hoc questions, and presenting clear, actionable recommendations to senior stakeholders. The analyst will serve as a strategic partner across various business units, with a deep focus on billing and subscription analytics, including trial conversion, activation, renewals, churn, reactivation, plan migration, add-on behavior, pricing and packaging performance, refunds and credits, failed payments, involuntary churn, and differences between direct and partner billing experiences. The role also involves supporting Finance, Product, Growth, Content, and Customer Experience teams with insights to understand subscriber base health, revenue streams, funnel friction, acquisition quality, engagement patterns, and customer pain points. The ideal candidate possesses analytical depth, business fluency, crisp communication, and a high standard for data quality, proactively refining questions and framing decisions.

Requirements

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.
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.
Strong stakeholder partnership skills and the ability to influence across Product, Finance, Marketing, Content, Operations, and technical teams.
Strong sense of ownership and prioritization; ability to manage competing requests and drive work independently.

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

Responsibilities

Own and evolve core business scorecards, dashboards, and ad-hoc analyses for 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 Philo's billing and subscription ecosystem (trials, conversion, renewals, churn, reactivation, plan migration, add-on attach, refunds, credits, failed payments, involuntary churn, direct vs. partner billing).
Identify operational and product levers to improve subscriber health, reduce friction, and strengthen revenue retention.
Partner with Growth and Lifecycle Marketing on acquisition quality, funnel performance, cohort health, promotional effectiveness, winback programs, and LTV/CAC.
Collaborate with Product, Design, and Data Science on customer journey analysis, feature adoption, experimentation readouts, and insight generation.
Partner with Content, Programming, and Marketing to understand drivers of acquisition, engagement, retention, upsell, and free-to-paid conversion.
Support customer-facing and operational teams with insights into support contact drivers, account issues, and billing friction.
Build executive-ready materials that connect data to narrative, synthesize tradeoffs, and facilitate confident decision-making.
Improve data quality and trustworthiness by partnering with analytics and data engineering on instrumentation, metric governance, and source-of-truth logic.
Raise the analytical bar across the organization through clear documentation, thoughtful prioritization, and a balance of speed and rigor.

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)
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
$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
Generous commuter benefits ($315/month towards transit, rideshare, bike rental, or parking at our HQ office in San Francisco)
Free Gympass subscription
Dog-friendly office
Company stock options
Health benefits