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