Portfolio Monitoring Manager

Vistaar Finance

Bengaluru

On-site

INR 1,200,000 - 2,400,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Vistaar Finance in Bengaluru seeks an analytical professional to manage and monitor the lending portfolio across LAP, Secured Business Loans and Gold Loans. You will own end-to-end portfolio analytics, risk assessment and business insights generation.

The role requires strong SQL and Python skills, proficiency in Excel and BI tools, and the ability to translate complex data into actionable recommendations for Credit, Risk, Collections and Product teams.

Qualifications

  • Strong analytical capabilities with portfolio analytics focus.
  • Experience in lending portfolio and credit risk assessment.
  • Ability to translate data into business recommendations for multiple stakeholders.

Responsibilities

  • Monitor LAP, Secured BL and Gold Loan portfolios and KPIs.
  • Perform vintage, MOB, static pool and cohort analyses.
  • Develop predictive indicators and risk triggers for defaults.
  • Create automated portfolio reports and dashboards for senior management.
  • Collaborate with Business, Credit, Risk, Collections and Product teams.

Skills

SQL
Python
Excel
BI Tools
Portfolio Analytics
Credit Risk
Data Visualization

Tools

Tableau
Power BI
Redshift
PostgreSQL

Job description

Analyst cum Portfolio Manager Credit Portfolio & Risk Analytics

1. Job Overview

We are looking for a highly analytical and result-oriented professional to manage and monitor the company's lending portfolio across LAP, Secured Business Loans and Gold Loans.

The candidate will be responsible for end-to-end portfolio analytics and management, including portfolio performance monitoring, credit risk assessment, identification of emerging risks, portfolio segmentation and development of actionable business insights.

The role requires a combination of strong analytical skills, sound understanding of lending and credit risk, and the ability to translate complex data into meaningful business recommendations.

2. Key Competencies

  • Strong analytical and problem-solving capabilities.
  • Ability to interpret data and translate insights into business recommendations.
  • Good understanding of credit and portfolio risk.
  • Strong attention to detail and data accuracy.
  • Ability to work independently and manage multiple analytical assignments.
  • Effective communication and stakeholder management skills.
  • Proactive approach towards identifying risks and business opportunities.
3. Key Responsibilities

A. Portfolio Monitoring & Performance Management

  • Monitor the overall loan portfolio across LAP, Secured BL and GL.
  • Track key portfolio indicators such as DPD, PAR, NPA, collection efficiency, roll rates, bounce rates and delinquency trends etc.
  • Conduct vintage analysis, MOB analysis, static pool analysis and cohort-based performance tracking.
  • Monitor portfolio growth, disbursement trends, outstanding exposure and repayment behaviour.
  • Analyse portfolio performance across geography, branches, customer segments, sourcing channels, products and risk categories.
  • Identify early warning signals and emerging risks within the portfolio.

B. Credit Risk & Portfolio Analytics

  • Analyse credit quality and repayment behaviour of different customer segments.
  • Identify high-risk segments, geographies, branches and sourcing channels.
  • Conduct portfolio segmentation based on customer profile, bureau score, loan characteristics, exposure and repayment behaviour.
  • Perform roll-rate, flow-rate and delinquency migration analysis.
  • Evaluate the impact of credit policy changes on portfolio quality and business performance.
  • Identify factors contributing to delinquency, defaults and portfolio deterioration.
  • Develop predictive indicators and risk triggers to support early identification of potential defaults.

C. Business Performance & Portfolio Strategy

  • Evaluate the balance between portfolio growth, credit quality and risk appetite.
  • Analyse portfolio composition, product mix, customer concentration and geographical exposure.
  • Identify opportunities for portfolio optimisation and sustainable business growth.
  • Provide analytical inputs for credit policy modifications and portfolio-level interventions.
  • Recommend corrective actions based on portfolio trends and emerging risk indicators.
  • Work closely with Business, Credit, Risk, Collections and Product teams to drive portfolio performance.

D. Reporting, Dashboarding & MIS

  • Develop and maintain automated portfolio monitoring reports and dashboards.
  • Prepare periodic portfolio performance reviews for senior management.
  • Establish standardised portfolio KPIs, metrics and monitoring frameworks.
  • Ensure accuracy, consistency and timely delivery of portfolio reports.
  • Automate recurring analytical reports and eliminate manual reporting processes.
  • Present analytical findings and actionable recommendations to relevant stakeholders.

E. Data Analytics & Process Automation

  • Extract, transform and analyse large volumes of lending and repayment data.
  • Develop complex SQL queries for portfolio analysis and data extraction.
  • Build Python-based analytical solutions for data processing, automation and portfolio analysis.
  • Perform data validation, reconciliation and quality checks.
  • Identify opportunities to improve existing analytical processes through automation.
4. Technical Expertise

SQL (Mandatory)

  • Strong command of SQL and complex query writing.
  • Proficiency in joins, CTEs, subqueries, window functions and analytical functions.
  • Experience working with large datasets and performing complex aggregations.
  • Ability to develop efficient queries for portfolio-level analysis and reporting.
  • Exposure to data warehouse environments such as Amazon Redshift, PostgreSQL or equivalent.

Python – Strong Working Knowledge (Mandatory)

  • Proficiency in Python for data analysis and automation.
  • Working knowledge of Pandas, NumPy and other relevant analytical libraries.
  • Ability to automate recurring reports and data processing activities.
  • Experience in portfolio segmentation, trend analysis and statistical analysis.
  • Exposure to predictive modelling and machine learning techniques would be an advantage.

Microsoft Excel – Proficient

  • Advanced Excel functions, Pivot Tables, Lookup functions and data manipulation.
  • Ability to handle large datasets and perform complex analysis.
  • Experience in developing automated reports and analytical templates.

BI & Data Visualisation Tools

  • Exposure to Tableau, Power BI, QuickSight or equivalent BI tools.
  • Ability to develop dashboards and visualise portfolio performance.
  • Understanding of KPI reporting and effective data storytelling.
5. Functional & Domain Knowledge

  • Good understanding of retail and commercial lending products, particularly LAP, Secured BL and GL.
  • Understanding of the lending lifecycle, from sourcing and underwriting to disbursement and collections.
  • Knowledge of credit risk parameters, delinquency buckets, PAR, NPA and portfolio quality indicators.
  • Understanding of vintage analysis, MOB, static pool, roll-rate and cohort analysis.
  • Familiarity with bureau data and customer credit behaviour.
  • Ability to connect portfolio performance with underlying business and credit
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Analyst
Analyst

Shubham Housing Development Finance • Gurugram District

On-site
INR 1,000,000 - 1,600,000
Senior Associate
Senior Associate

SkillLabs Resource Services Pvt. Ltd. • Delhi

On-site
INR 1,400,000 - 2,200,000
Portfolio Credit Manager LAP
Portfolio Credit Manager LAP

Au Small Finance Bank Ltd. • Delhi

On-site
INR 2,500,000 - 4,000,000
Branch Credit Manager
Branch Credit Manager

Huey Tech • Delhi

On-site
INR 700,000 - 1,100,000
VP Risk & Portfolio Management
VP Risk & Portfolio Management

Comviva • Gurugram District

On-site
INR 2,500,000 - 4,000,000
Senior Data Analyst - LAP
Senior Data Analyst - LAP

Krazy Bee Services • Bengaluru

On-site
INR 1,200,000 - 2,400,000
CREDIT MONITORING OFFICER
CREDIT MONITORING OFFICER

Muthoot Fincorp • Tamil Nadu

On-site
INR 600,000 - 1,100,000
Senior Technical Analyst TSG
Senior Technical Analyst TSG

YES BANK • Maharashtra

On-site
INR 1,500,000 - 2,600,000
National Manager Credit Cards Pre-Acquisition Policy
National Manager Credit Cards Pre-Acquisition Policy

Weekday AI • Jaipur

On-site
INR 5,000,000 - 7,000,000
Credit Policy Manager
Credit Policy Manager

Yes Bank Ltd. • Mumbai

On-site
INR 1,500,000 - 2,800,000