Subscriber Cohort Retention & Churn Prediction Engine
Subscription churn was rising by 3.2% QoQ without visibility into which user cohorts decayed after month 2. The executive team relied on lagging 30-day billing summaries and lacked proactive leading risk indicators.
Architected automated dbt/Snowflake data models structuring 1.8M subscriber activity logs. Built Python survival analysis (Kaplan-Meier & Cox Proportional Hazards) to isolate core friction milestones. Designed an automated Power BI dashboard with DAX-driven cohort decay tracking and real-time alerts for at-risk accounts.