Lokal App - Product Analyst - SQL

Responsibilities :

• Collaborate with Product Managers and cross-functional teams (Marketing, Tech, Design, User Research, Sales, Strategy, Business) to identify data-driven opportunities and solve key business problems.
• Set up and maintain automated dashboards and tracking sheets to monitor critical KPIs.
• Conduct in-depth analyses of KPI trends, identify anomalies, and perform root cause analyses (RCA) to provide actionable insights to stakeholders.
• Analyze and interpret A / B tests to evaluate the impact of experiments on product and user behavior.
• Conduct cohort analysis and retention studies to drive strategies for improving user engagement and long-term retention.
• Develop monthly and quarterly projections for KPIs to assist in strategic planning and goal-setting.
• Write and test event analytics for frontend clickstream data, ensuring accuracy in staging and production environments.
• Set up feature-specific tracking for new releases, ensuring accurate measurement of feature adoption and providing actionable insights to guide the product team on next steps and improvements.
• Optimize product funnels (e.onboarding, payment) by identifying bottlenecks and proposing improvements.
• Handle ad-hoc data requests from various teams and provide timely, well-structured solutions.
• Continuously explore advanced analytics opportunities within product and business functions to enhance user experience and increase revenue.

Requirements :

ref : hirist.tech)