BI and Data Analyst

Jai Finance; Bengaluru; On-site; INR 600,000 - 900,000; Full time

Job summary

Jai Finance, based in Bengaluru, seeks a detail-oriented Data Analyst to support the Business Intelligence function of a growing NBFC. The role focuses on developing dashboards, automating reports, and delivering insights to Credit, Risk, Collections, Finance, Operations, Product and Marketing teams.

You will write and optimize SQL queries, maintain KPI definitions, validate data across systems, and drive reporting improvements through Power BI dashboards and MIS outputs.

Qualifications

• Experience building dashboards and reports in Power BI.
• Strong SQL skills for data extraction, validation and reporting.
• Ability to define KPIs and document reporting processes.

Responsibilities

• Develop and maintain Power BI dashboards for Disbursal, AUM, Collections, Demand, and Portfolio Performance.
• Analyze lending portfolio performance using vintage, cohort, and risk analyses.
• Write, optimize, and maintain SQL queries for data extraction and reporting.
• Automate daily, weekly, and monthly MIS reports and dashboards.
• Collaborate with cross-functional teams to translate requirements into reports.
• Validate data across multiple systems to ensure accuracy.
• Create and maintain KPI definitions, SQL repositories, reporting docs, and SOPs.
• Improve dashboard performance and reporting processes.
• Support ad hoc data analysis and business reporting needs.

Skills

Power BI

SQL

Data Validation

MIS Reporting

KPI Definition

Stakeholder Management

Tools

SQL

Job description

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.