Senior Business Insights Analyst

Philo•Cambridge, MA

7h•$125,000 - $180,000

About The Position

Philo is seeking a Senior Business Insights Analyst to improve decision-making through rigorous analysis, trusted metrics, and cross-functional partnership. This high-impact individual contributor role owns recurring KPI reporting, investigates ambiguous business questions, and presents clear, decision-ready recommendations to senior stakeholders. The analyst will serve as a strategic partner across the business, with particular ownership of billing and subscription analytics. The work covers the subscriber lifecycle and revenue streams, including trials, conversion, activation, 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 role also supports analysis across Finance, Product, Growth, Lifecycle Marketing, Content, Customer Experience, and Operations. The successful candidate will combine analytical depth, business fluency, crisp communication, and a strong commitment to data quality. They will independently refine questions, frame decisions, and deliver work that stakeholders trust and use. 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; salary varies by experience and location, with listed ranges from $125,000 to $180,000 annually.

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 visualizations, dashboards, and self-serve reporting environments in BI tools such as Mode, Omni, Tableau, or Looker.
Proven ability to translate 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 differing 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 work from important work, 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 such as trials, conversion, churn, retention, winback, LTV, plan mix, and add-on attachment.
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 covering 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.
Build deep expertise in Philo’s billing and subscription ecosystem, including trials, conversion, renewals, churn, reactivation, plan migration, add-on attachment, refunds, credits, failed payments, involuntary churn, and direct versus partner billing flows.
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 analyze how channels, titles, and viewing patterns drive acquisition, engagement, retention, upsell, and free-to-paid conversion opportunities.
Support customer-facing and operational teams with analysis of support contact drivers, account issues, billing friction, and subscriber pain points.
Build executive-ready materials that connect numbers to narrative, synthesize tradeoffs, and support confident decision-making by technical and non-technical stakeholders.
Improve business data quality and trust by partnering with analytics engineering and data engineering on instrumentation, metric governance, source-of-truth logic, and data quality issues.
Raise the analytical bar through clear documentation, thoughtful prioritization, and a pragmatic balance of speed and rigor.

Benefits

Full health, dental, and vision coverage for the employee and family.
401(k) plan with employer contributions: 100% match of deferrals up to 3% of pay and 50% match 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 for taking a two-week vacation.
$5,250 annually for professional development and educational assistance.
$1,250 annual home office and TV stipend 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 the offices.
Commuter benefits of $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.
Company stock options and health benefits are included in compensation.