Role Overview :

The 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.

Key Responsibilities :

- Analyze customer cohorts, retention curves, and churn metrics across lifecycle stages
- Build and monitor KPIs such as Retention Rate, Repeat Rate, LTV, CAC.
- Identify drop-off points in the user journey and recommend improvements
- Design and evaluate CRM campaigns (email, WhatsApp, push, SMS) using A/B testing
- Perform segmentation based on behavior, RFM, purchase frequency, and engagement
- Analyze impact of discounts, loyalty programs, subscriptions, and nudges




- Build dashboards and reports for weekly/monthly retention performance
- Support leadership with insights and actionable recommendations

Skill Required :

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

- Good to have :

- Python & Basic statistics.
- Experience working with retention or retention prediction models.

📌 Data Analyst - Central Analytics (Bengaluru)
🏢 Kapiva
📍 Bengaluru