Job Description
n Role Overview :
nThe Analyst is responsible for analyzing user behavior, identifying churn drivers, and improving customer lifetime value (LTV) through data-driven insights. This role works closely with CRM, marketing, and growth teams to design and evaluate retention strategies.
n
n Key Responsibilities :
n
n
Analyze customer cohorts, retention curves, and churn metrics across lifecycle stagesn
Build and monitor KPIs such as Retention Rate, Repeat Rate, LTV, CAC.n
Identify drop-off points in the user journey and recommend improvementsn
Design and evaluate CRM campaigns (email, WhatsApp, push, SMS) using A/B testingn
Perform segmentation based on behavior, RFM, purchase frequency, and engagementn
Analyze impact of discounts, loyalty programs, subscriptions, and nudgesn




Build dashboards and reports for weekly/monthly retention performancen
Support leadership with insights and actionable recommendationsn

n
n Skill Required :
n
n
Robust Advance SQL (CTEs, window functions, cohort analysis).n
Excel / Google Sheets (advanced formulas, pivots).n
Experience with BI tools (Looker, Tableau, Power BI, Metabase, etc.)n
Understanding of event-based data (GA4, Webengage).n
Cohort analysis & Funnel analysis.n
Solid understanding of customer lifecycle & CRM.n
Ability to translate data into business decisions.n

n Positive to have :
n
n
Python & Basic statistics.n
Experience working with retention or retention prediction models.n

n

📌 Data Analyst Bengaluru
🏢 Kapiva
📍 Bengaluru