Product Analyst Intern
Job Requirement - Product Analyst Intern
What is Lokal
We are Lokal, India's premier hyperlocal platform, offering services in various Indian languages. We focus on developing world-class products for non-English speakers across India by delivering local information, classified ads, and continually evolving to include new and significant use cases every day. We operate in several states including Andhra Pradesh, Telangana, Tamil Nadu, Kerala, Karnataka, Maharashtra, Gujarat, and are proud to have amassed over 45 million downloads to date.
Headquartered in Bengaluru, Lokal was founded in 2018 by Jani and Vipul, both distinguished IIT alumni recognised in Forbes 30 under 30 Asia 2020. As a Series B funded startup, we have garnered support from top-tier investors such as the Sony Innovation Fund, YCombinator, 3one4 Capital, India Quotient, and Global Brain. Our mission is driven by a commitment to innovation and a deep dedication to effectively serving our users.
We are being heard: Inc 42, Forbes, Economic Times
Product Analyst Intern JD
Description: As a Product Analyst Intern, you will work closely with cross-functional teams to deliver data-driven insights that drive key product and business decisions. You will be responsible for a variety of analytical tasks that contribute to tracking, monitoring, and optimizing product performance. This role offers hands-on exposure to real-world analytics and the opportunity to work on impactful projects that influence strategy and growth.- Collaborate with the Product team on specific problem statements, delivering data-driven insights and actionable solutions.
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 recommendations to stakeholders.
Analyze and interpret A/B test results to evaluate the impact of experiments on product performance and user behavior.
Conduct cohort-level analyses to evaluate user behavior and retention patterns, identifying opportunities for improvement.
Optimize product funnels (e.g., onboarding, payment) by analyzing user drop-offs, identifying bottlenecks, and recommending data-backed improvements.
Handle ad-hoc data requests from various teams, ensuring timely delivery of clear and structured solutions to address key business questions.
Skill Sets:
Necessary:
SQL Proficiency: Ability to write queries for data extraction and analysis.
Analytical Skills: A strong grasp of problem-solving and data interpretation.
Proficiency in Excel / Google Sheets: Comfortable using formulas, pivots, and creating clear and effective data visualizations.
-
Knowledge of Product Analytics: Familiarity with concepts like KPIs, product funnels, and A/B testing.
Traits Expectation:
Curiosity and Drive: A passion for understanding data and uncovering actionable insights.
Attention to Detail: Precision in analysis, ensuring accuracy and reliability in findings.
Collaborative Mindset: Ability to work effectively in cross-functional teams and communicate insights clearly.
Ownership: Taking responsibility for assigned tasks and driving them to completion.
Adaptability: A willingness to learn and adapt to new tools, methods, and fast-paced environments.
Expected Learning:
Hands-on experience with real-world product analytics, including KPI tracking, A/B test analysis, and cohort-level analysis to understand user behavior, product metrics, and retention strategies.
Practical exposure to event analytics and optimizing product funnels (e.g., onboarding, payment) by analyzing user flow and implementing solutions to improve conversion and user experience.
Experience collaborating with cross-functional teams to address business challenges by analyzing data and delivering well-structured insights and actionable recommendations.
Development of expertise in tools like SQL, Google Sheets, Google Data Studio, and Google Apps Script.
