Data Analyst - Central Analytics

Job description

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. • Strong 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.