BI and Data Analyst

Industry: Mandatory experience in NBFC, Digital lending, banking or Financial services

Role Objective

We are looking for a detail-oriented Data Analyst to support the Business Intelligence function of a growing NBFC. The role involves developing dashboards, automating reports, performing portfolio analysis, ensuring data accuracy, and generating business insights to support Credit, Risk, Collections, Finance, Operations, Product, and Marketing teams.

Key Responsibilities

• Develop and maintain Power BI dashboards for Disbursal, AUM, Collections, Demand, Collection Efficiency, DPD, Bounce, NPA, Recoveries, and Portfolio Performance.
• Analyze lending portfolio performance through vintage, cohort, static pool, repayment behaviour, and risk analysis.
• Write, optimize, and maintain SQL queries for data extraction, validation, reconciliation, and reporting.
• Automate daily, weekly, and monthly MIS reports and business dashboards.
• Work closely with cross-functional teams to understand reporting requirements and provide actionable insights.
• Validate data across multiple systems to ensure reporting accuracy and consistency.
• Create and maintain KPI definitions, SQL repositories, reporting documentation, and SOPs.
• Assist in improving dashboard performance and reporting processes.
• Support ad hoc data analysis and business reporting requirements.

Preferred candidate profile

• Strong analytical and problem-solving skills.
• Good communication and stakeholder management abilities.
• Ability to work independently and manage multiple priorities.
• High attention to detail and commitment to data quality.
• Willingness to learn new technologies and improve reporting processes.
• Ability to present data-driven insights to business teams.

Lending Domain Knowledge

• Understanding of the lending lifecycle including sourcing, underwriting, disbursal, repayment, collections, foreclosure, write-off, and recovery.
• Knowledge of key lending metrics including AUM, DPD, PAR, NPA, Collection Efficiency, Bounce Rate, Roll Rate, Vintage Analysis, Static Pool Analysis, and Repayment Behaviour.
• Familiarity with credit bureau data, KYC, fraud checks, and RBI Digital Lending Guidelines.