Product Analyst - Assistant Manager - Lending

One97 Communications Limited; Bengaluru; On-site; INR 500,000 - 800,000; Full time

Job summary

A leading fintech company in Bengaluru is seeking an entry-level Product Analyst to support the Merchant Lending team. The ideal candidate will analyze user behavior and product performance through data, using SQL and Python to generate insights. This role involves collaborating with Product Managers to drive product improvements in a vibrant and growing ecosystem.

Qualifications

• 2–4 years of experience in data or product analytics, preferably in fintech.
• Strong understanding of funnel analysis and behavioral analytics.
• Experience with AI/ML tools and LLMs for data summarization.

Responsibilities

• Build and monitor funnel performance for merchant lending offerings.
• Write complex SQL queries to analyze large datasets.
• Conduct Root Cause Analysis to provide actionable insights.

Skills

SQL proficiency

Data analysis with Python

Problem-solving skills

Communication of data insights

Education

Bachelor’s degree in Engineering, Mathematics, Statistics

Tools

Looker

Microsoft Excel

Job description

Overview

We are seeking a detail-oriented Product Analyst to support the Merchant Lending team. The ideal candidate will play a critical role in understanding user behavior, identifying funnel drop-offs, monitoring performance and working closely with Product Managers to drive product improvements through data.

Key Responsibilities

• Build & monitor funnel performance for various merchant lending offerings.
• Write complex SQL queries to extract, clean, and analyze large datasets.
• Conduct Root Cause Analysis (RCA) to identify bottlenecks or anomalies in product flows to deliver actionable insights and recommendations to Product Managers.
• Generate insights and validate hypotheses by working closely with Product Managers on user product interaction data.
• Keep plugged in to the latest developments in the data engineering, analytics and sciences ecosystem leveraging technologies such as LLMs to solve repetitive problems using a platform approach.
• Create dashboards and reports using Looker, MS Excel, and other BI tools to track KPIs.
• Collaborate with engineering, risk, and operations to support product experimentation and data validation.
• Automate regular reporting and deep dives for advanced analysis.

Requirements

• Bachelor’s degree in Engineering, Mathematics, Statistics, or a related field.
• 2–4 years of experience in a data or product analytics role, preferably in fintech
• Strong proficiency in SQL (window functions, CTEs, joins, nested queries, etc.).
• Hands-on experience with Python for data analysis and automation.
• Experience working with Looker (or similar BI tools like Tableau, Power BI). Advanced skills in Microsoft Excel, including pivot tables, data cleaning, and charting.
• Strong problem-solving skills with a structured approach to analysis.
• Ability to communicate complex data insights in a clear and actionable manner.
• Experience with AI/ML tools and ability to leverage LLMs (e.g., ChatGPT, Claude) for data summarization, insight generation, and automation.
• Familiarity with prompt engineering and an understanding of agentic AI systems and their applications in product analytics.
• Nice-to-have: Familiarity with A/B testing and experimentation design.
• Exposure to lending or risk-related product workflows.
• Understanding of funnel analysis, conversion optimization, and behavioral analytics.

Compensation

If you are the right fit, we believe in creating wealth for you with enviable scale: 500M+ registered users, 25M+ merchants, and depth of data in our ecosystem. We are in a unique position to democratize credit for deserving consumers and merchants, and we are committed to it. India’s largest digital lending story is brewing here. It’s your opportunity to be a part of the story.

Seniority level

• Entry level

Employment type

• Full-time

Job function

• Research, Analyst, and Information Technology

Industries

• Technology, Information and Internet