Analyst

Shubham Housing Development Finance; Gurugram District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Shubham Housing Development Finance is seeking a data analytics professional to drive portfolio insights across Risk, Collections and Operations. You will mine data, build dashboards and present actionable recommendations to senior stakeholders.

Proficiency in R, Python and SQL is essential, with advanced Excel skills and a solid grasp of mortgage analytics. The role requires ability to work cross-functionally, deliver high-quality reports, and proactively identify trends that improve GNPA

Qualifications

• Extensive experience with analytical tools e.g. R, Python, VBA, Excel, SQL.

Responsibilities

• Ensure to work with appropriate tools and techniques to understand portfolio & business characteristics and help in overall decision-making process.
• Provide analytics across departments: Portfolio, Collections, Risk, Operations, Sales.
• Ensure high quality and consistency of reports
• Customize standard dashboards as per business requirements
• Proactively looking at data trends and sharing key findings.
• Analyze credit bureau data and provide actionable recommendations
• Using appropriate data, processes & techniques for building high quality presentations.
• Work with a consultative mindset to gather requirements from other teams
• Work with tech teams to identify and resolve any data, infrastructure, or implementation issues
• Communicate analysis results and provide professional presentations in a simple yet actionable manner

Skills

Data analytics

Analytical thinking

Problem solving

Communication

Tools

R

Python

VBA

Excel

SQL

Job description

Scope of Work

• Data Analytics Data extraction, cleaning, transformation & summarization
• Risk Analytics
• Portfolio Analytics
• Business Intelligence

Key relationships

• Analytics team
• External analytics consultants
• Functional Heads

Key Results Areas

• Data mining and identifying trends
• Deliver actionable insights that reduce GNPA, improve collection efficiency, and optimize portfolio profitability
• Development of reports, dashboards and presentations

Responsibilities

• Ensure to work with appropriate tools and techniques to understand portfolio & business characteristics and help in overall decision-making process.
• Provide analytics across departments: Portfolio, Collections, Risk, Operations, Sales.
• Ensure high quality and consistency of reports
• Customize standard dashboards as per business requirements
• Proactively looking at data trends and sharing key findings.
• Analyze credit bureau data and provide actionable recommendations
• Using appropriate data, processes & techniques for building high quality presentations.
• Work with a consultative mindset to gather requirements from other teams
• Work with tech teams to identify and resolve any data, infrastructure, or implementation issues
• Communicate analysis results and provide professional presentations in a simple yet actionable manner

Skills and competencies

• Extensive experience of analytical tools e.g. R, Python, VBA, Excel, SQL etc.
• Experience in risk analytics, collection analytics, bureau analytics etc. Competencies:
• Able to deliver results independently with only high level inputs
• Can solve fairly complex data and analytics problems
• Understanding of mortgage business
• Able to interpret, share and discuss results in the business context
• Problem solving, Analytical approach and thinking
• Manage and prioritize own work stream