Mis Executive

Job Summary

We are looking for a detail-oriented and analytical MIS Executive to join our Collections Loan Team. The ideal candidate will be responsible for managing data, generating reports, and supporting the collections team with actionable insights to improve recovery rates and overall efficiency. Experience in the fintech or NBFC sector is preferred.

Key Responsibilities

MIS Reporting :

Develop, maintain, and update daily, weekly, and monthly dashboards and reports for collections performance.

Generate reports on key metrics like delinquency rates (DPD buckets), collection efficiency, and recovery performance.

Track field agent productivity, bucket movement, and loan performance trends.

Data Analysis

Analyze borrower repayment behavior, identify default patterns, and highlight risk areas.

Provide actionable insights to improve collection strategies.

Automation Process Improvement

Automate repetitive reporting processes using Excel macros, SQL queries, Power BI, etc.

Collaborate with the tech / product team for report integrations with CRM or collection systems.

Coordination

Work closely with collection agents, team leaders, and managers to provide real-time data support.

Coordinate with finance, credit, and customer support teams for cross-functional data needs.

Key Skills Tools

Strong Excel (VLOOKUP, Pivot Tables, Macros)

SQL (mandatory or highly preferred)

Power BI / Tableau (good to have)

Google Sheets, Google Data Studio

Knowledge of Loan Management Systems (LMS) / Collection CRMs

Understanding of DPD buckets, NPA classifications, and collection metrics

Qualifications

Bachelors degree in Commerce, Statistics, Computer Science, or a related field

2 to 5 years of experience in MIS / Data role, preferably in fintech, NBFC, or banking collections

Strong analytical and problem-solving skills

Excellent communication and stakeholder management skills

Preferred Experience

Prior experience in a fintech or NBFC working in unsecured / small ticket loans

Exposure to digital collection tools and recovery analytics

Key Performance Indicators (KPIs)

Timeliness and accuracy of MIS reports

Quality of data insights driving business decisions

Level of automation implemented

Stakeholder satisfaction (internal collections team)

This job is provided by Shine.com

Skills Required

Power Bi, google sheets , Tableau, Excel, Sql