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
- Solid 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
- Strong understanding of customer lifecycle & CRM.n
- Ability to translate data into business decisions.n

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

n

📌 Data Analyst (Bengaluru)
🏢 Kapiva
📍 Bengaluru