Product Analyst - Assistant Manager - Lending

One97 Communications Limited; Dadri; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading fintech company is looking for a detail-oriented Product Analyst to support the Merchant Lending team. The ideal candidate will analyze user behavior, build funnel performance models, and provide actionable insights to improve product offerings. Candidates should have a background in Engineering or Mathematics, with strong SQL and Python skills. Experience in fintech is preferred.

Qualifications

• 2–4 years of experience in a data or product analytics role, preferably in fintech.
• Strong proficiency in SQL including advanced functions.
• Experience with AI/ML tools is a plus.

Responsibilities

• Build & monitor funnel performance for merchant lending offerings.
• Conduct Root Cause Analysis (RCA) for product flows.
• Create dashboards and reports using BI tools.

Skills

SQL proficiency

Python for data analysis

BI tools experience (Looker, Tableau)

Problem-solving skills

Data cleaning and analysis

Education

Bachelor’s degree in Engineering, Mathematics, Statistics, or related field

Tools

Looker

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

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.

Qualifications

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