About Kashti

Kashti is a fintech lending marketplace focused on connecting customers with suitable lending partners. We work across the digital lending journey, from customer acquisition and application processing to lender allocation, approval, disbursement and post-disbursement tracking.

About the Role

We are looking for a Data Analyst who can work closely with Business, Product, Technology, Operations, Risk and Lender Partnerships teams. This is a hands-on role for someone who can move beyond preparing MIS and use data to identify business opportunities, operational leakages and actionable insights.

Key Responsibilities

· Own daily, weekly and monthly MIS across leads, applications, approvals, disbursements and lender performance.

· Build lender-wise dashboards covering lead allocation, application status, approval rates, disbursal rates, TAT, rejection reasons and disbursal value.

· Analyze the complete customer funnel: Lead → Application → Login → Approval → KYC → Disbursement.

· Track and analyze lender-wise conversion, customer eligibility, approval probability and drop-offs.

· Reconcile data received from multiple lenders, APIs, internal systems and operational teams and identify discrepancies.

· Build automated reporting processes to reduce manual Excel/MIS work and improve reporting accuracy.

· Write SQL queries to extract, transform and analyze large datasets from databases.

· Create dashboards in Power BI, Tableau, Looker Studio or similar BI platforms.

· Identify anomalies, data-quality issues, leakage points and unusual movements in business metrics.

· Analyze customer acquisition channels and measure CAC, conversion and disbursement performance.

· Support lender allocation and routing decisions using historical performance and customer-level data.

· Track operational metrics including TAT, pending cases, KYC completion,



approval ageing and disbursement ageing.

· Support portfolio analytics including repayment, bounce, delinquency and collection trends wherever applicable.

· Work with Technology teams to validate API responses, database fields, data flows and integration-level reporting.

· Prepare management dashboards and concise insights for leadership reviews.

· Handle ad-hoc analysis and data requests from business and leadership teams.

Required Skills

· Strong SQL skills with ability to write complex queries, joins, aggregations and subqueries.

· Advanced Excel / Google Sheets including Pivot Tables, XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS and dashboard creation.

· Hands-on experience with Power BI, Tableau, Looker Studio or another BI tool.

· Strong data-cleaning, reconciliation and validation skills.

· Ability to work with large datasets and convert analysis into business insights.

· Strong attention to detail and ownership of data accuracy.

· Good communication skills and ability to work with non-technical stakeholders.

Valuable to Have

· Experience in fintech, digital lending, NBFC, banking, payments or financial services.

· Understanding of the loan lifecycle and digital lending funnel.

· Knowledge of credit, bureau and lending-related metrics.

· Basic Python / Pandas knowledge.

· Experience working with APIs, JSON data or database integrations.

· Experience automating MIS using SQL, Python, Power BI or similar tools.

· Experience handling data from multiple lenders or financial partners.

Pay: ₹300,000.00 - ₹500,000.00 per year

Application Question(s)

- What is your total experience..?
- What is your experience in Data Analyst role?
- Do you have experience working with Fintech/Finance/NBFC..?(Must have)
- Do you have experience in SQL, Python, Advance excel etc..?
- What is your current ctc..?
- Expected CTC..?
- What is your notice period..?
- Current location.?

Work Location: In person

📌 Data Analyst (J. P. Nagar)
🏢 Kashti FInserv
📍 J. P. Nagar