Lokal App - Senior Product Analyst - SQL

Role : Senior Product Analyst

Work Location : Bangalore - Onsite

About Lokal :

In 2018, we began with a WhatsApp group with a simple hypothesis : people in tier-2/3 towns weren't really using the internet meaningfully yet. We believed that if we started with local content in their own language, they'd come back every day; once there was a habit and trust, that same space could naturally grow into classifieds and, eventually, something they used for almost everything online.

This spark became Lokal. Our first instinct was to put everything in one place & one app - local updates, classifieds, jobs, matrimony and more. It worked, till it stopped working. Users gave us the insight - when one use case outweighs the others, everything else seems like noise. We listened. Like how Craigslist quietly seeded a generation of focused companies & marketplaces, we began unbundling and verticalising.

Today, Lokal is a house of focused apps, many products, one mission : to connect Tier-2/3+ India to the Knowledge, opportunities, tools and experts they've always deserved.

We now operate dozens of live apps across categories like :

• Edutainment & Skill Learning - practical skills and learning in regional languages (GyanTV)

• Matrimonial Matchmaking - hyperlocal, compatibility-first partner search (Lokal Matrimony)

• Agri Consulting - farmer-first advisory in local languages (AgriLokal)

• Local Jobs - blue- and grey-collar opportunities close to home (Lokal Jobs)

• Social & Community - Place to find & post social updates (Lokal app)

• Emotional Well-being & Peer Support - safe spaces to talk and feel heard (Dostt & Eaze)

• Astrology & Guidance - instant access to trusted Astrologers via chat and voice (AstroLokal)

• Advisory Services - early bets in legal help, financial guidance, career counselling, and more

Under the hood, Lokal is a discovery and access platform : local-language internet + deep Bharat insight+ AI. When someone opens a product we've built, they don't wade through clutter; they get a straight line to what they came for.

This is the story new teammates walk into : a company that started as a whatsapp group, became a family of focused apps, and kept one belief at the centre - access changes lives.

We ship fast. We learn fast. We build for Bharat.

We are backed by leading global and domestic investors including Y Combinator, Sony, Global Brain, India Quotient, and 3one4 Capital

Role Overview :

We're looking for a Product Analyst to drive data-backed product decisions and optimize user experience. You'll work closely with Product, Engineering, and Business teams to define metrics, uncover insights, and evaluate feature performance. This role focuses on user behavior analysis, experimentation, and building scalable analytics frameworks, while also contributing to a strong data-driven culture.

Job Responsibilities :

• Lead end-to-end data analysis initiatives, driving actionable insights that influence product strategy and decision-making.

• Partner closely with Product Managers and cross-functional teams to define key metrics and evaluate product performance.

• Design and implement scalable analytical frameworks to support continuous product optimization.

• Conduct deep-dive analyses on user behavior, conversion funnels, and retention to guide product roadmap decisions.

• Evaluate feature performance using A/B testing and multivariate experimentation methodologies.

• Translate complex datasets into clear, actionable insights through reports and dashboards for stakeholders.

• Mentor and guide junior analysts, fostering a strong data-driven culture within the team.

• Maintain thorough documentation of analytical processes, methodologies, and findings to ensure reproducibility.

• Stay updated with emerging analytics tools, trends, and best practices to drive innovation.

Requirements : Must Have :

• 3+ years of experience in Analytics, with at least 1.5+ years in Product Analytics (preferably in a tech/startup environment).

• Strong proficiency in SQL, including complex queries using CTEs, joins, and data transformations.

• Deep understanding of product metrics, user behavior analysis, cohort analysis, and A/B testing.

• Experience leading data-driven discussions and presenting insights to senior stakeholders.

• Hands-on experience with visualization tools like Tableau, Looker, or Power BI.

• Working knowledge of Python or R is an added advantage.

• Strong communication skills with the ability to simplify complex data for non-technical audiences.

• Strategic thinking with a user-centric approach to product improvements.

• Experience working in fast-paced, iterative startup environments.

Good to Have :

• Exposure to large-scale data tools such as Google BigQuery or Apache Spark.

• Experience with automation tools like Google Apps Script.

• Understanding of customer journey mapping and UX principles.

Why Join Us?

We're scaling fast with strong fundamentals, on a mission to empower millions through AI and access. At Lokal, you'll take ownership from day one, build for real impact, and help redefine the roadmap of how Bharat connects to opportunities, knowledge, and experts.