Risk Analyst

Ansu Trade & Fiscals; Mumbai Suburban; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Ansu Trade & Fiscals is seeking a Risk Analyst to study our loan portfolio, identify risks early and provide management with clear reports to support decisions.

You will prepare risk assessment reports, monitor KPIs like delinquency and NPA, and build dashboards to communicate findings to non-technical managers across credit, operations and finance teams.

Qualifications

• Experience in risk analytics for lending portfolios.
• Proficient in SQL and Excel data cleaning.
• Ability to present to non-technical managers.

Responsibilities

• Prepare risk assessment reports on the loan portfolio.
• Monitor key risk indicators: delinquency, DPD, NPA, PAR and collection efficiency.
• Identify early warning signs and suggest corrective actions.
• Support credit teams with risk analysis on products, regions and customer segments.
• Prepare daily, weekly and monthly MIS (disbursement, collection, overdue, NPA).
• Build and maintain management dashboards.
• Carry out portfolio analysis: DPD bucket, product-wise and region-wise.
• Prepare data for audits, board meetings and regulatory reporting.
• Pull and clean data from CRM and databases using SQL and Excel, and check accuracy before sharing.
• Work with credit, collections, finance and tech teams, and document report formats and data definitions.

Skills

Advanced Excel

SQL for data extraction

Risk analytics

Clear communication

Tools

Power BI

Tableau

Metabase

Looker Studio

Job description

Job description

We are a growing NBFC startup looking for a Risk Analyst to study our loan portfolio, identify risks early and give management clear reports to support decisions.

Responsibilities

• Prepare risk assessment reports on the loan portfolio
• Monitor key risk indicators: delinquency, DPD, NPA, PAR and collection efficiency
• Identify early warning signs and suggest corrective actions
• Support credit teams with risk analysis on products, regions and customer segments
• Prepare daily, weekly and monthly MIS (disbursement, collection, overdue, NPA)
• Build and maintain management dashboards
• Carry out portfolio analysis: DPD bucket, product-wise and region-wise
• Prepare data for audits, board meetings and regulatory reporting
• Pull and clean data from CRM and databases using SQL and Excel, and check accuracy before sharing
• Work with credit, collections, finance and tech teams, and document report formats and data definitions

Required skills

• Advanced Excel (pivots, lookups, formulas, charts)
• SQL for data extraction
• Experience with a dashboard tool (Power BI, Tableau, Metabase or Looker Studio)
• Understanding of DPD, NPA, PAR and collection efficiency
• Strong analytical thinking, attention to detail, and clear communication with non-technical managers