Senior Business Intelligence Analyst

Philo

Senior Business Insights Analyst at Philo leveraging data for insights into subscriber health and revenue streams. Collaborating across teams to define metrics and drive decision-making through analytical clarity.

Posted 5/27/2026full-timeRemote • California • 🇺🇸 United StatesSenior💰 $130,000 - $170,000 per yearWebsite

Tech Stack

Tools & technologies

SQLTableau

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

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!

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdata visualizationdashboard creationbusiness intelligencecohort analysisfunnel analysisretention analysistrend analysisKPI designanomaly detection

Soft Skills

analytical thinkingcommunicationstakeholder partnershipinfluenceownershipprioritizationpresentation skillsdocumentationdecision-makingproblem-solving