Lokal App - Senior Product Analyst

Job Responsibilities:

- Work closely with Product Managers and cross-functional teams (Marketing, Tech, Design, User Research, Sales, Strategy, and Business) to identify data-driven opportunities and solve key business challenges.

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

- Design, analyze, and interpret A/B tests to evaluate experiment impact on product performance and user behavior.

- Conduct cohort analysis and retention studies to improve user engagement and long-term retention strategies.

- Develop monthly and quarterly KPI projections to assist in strategic planning.

- Write and test event analytics for frontend clickstream data, ensuring accuracy in staging and production environments.

- Set up feature-specific tracking for new releases to measure adoption and guide product improvements.

- Optimize key product funnels (e.g., onboarding, payment) by identifying bottlenecks and proposing data-backed solutions.

- Handle ad-hoc data requests from various teams and provide timely, structured insights.

- Explore advanced analytics opportunities to enhance user experience and drive revenue growth.

Required Skills:

1. SQL Expertise - Strong ability to write complex queries using CTEs, Window Functions, Subqueries, and Advanced Joins.

2. Clickstream Data Analysis - Experience in analyzing user behavior and interactions.

3. Problem-Solving Mindset - Ability to approach challenges with structured, data-driven solutions.

4. Product Analytics Knowledge - Understanding of product metrics, user funnels, A/B testing methodologies, and behavioral analysis.

5. Collaboration & Communication - Ability to translate data insights into actionable recommendations for all the stakeholders.

6. Ownership & Initiative - Ability to take end-to-end ownership of data exploration, insights generation, and implementation of solutions.

7. Adaptability & Continuous Learning - Quick to learn new tools, methods, and adjust to fast-paced environments.

Good to Have: Hands-on experience with Google Apps Script to automate tasks and create efficient workflows.