Manager – Collections Analytics

Role Overview

The MIS Executive for the Collection Back Office plays a critical role in bridging the gap between field operations, the legal department, and senior management. This role is responsible for end-to-end data management, tracking collection performance against projections, and preparing vital analytical reports (including DPD metrics). The ideal candidate will ensure seamless data flow to drive maximum recovery and facilitate timely legal interventions for delinquent accounts.

Key Responsibilities

1. Daily MIS & Data Management

• Daily Reporting: Prepare, publish, and maintain daily, weekly, and monthly Collection MIS reports for management review.
• Data Management: Manage large volumes of loan and recovery data with high accuracy.
• Dashboards: Maintain dynamic dashboards showcasing vital collection metrics, bounce rates, and resolution rates.

2. Field Team Coordination & Performance Tracking

• Target vs. Achievement: Coordinate daily with the field collection team to track on-ground performance against set monthly projections and targets.
• Data Allocation: Allocate daily calling and visitation lists to the tele-calling and field teams based on priority and delinquency buckets.
• Variance Analysis: Highlight shortfalls in expected collections versus actual recoveries and share actionable insights with field supervisors.
• Feedback Loop: Act as the central point of contact for the field team to resolve data-related discrepancies

3. Legal Team Coordination

• Legal Initiation: Identify chronic default accounts eligible for legal action (e.g., Section 138, Arbitration, Securitization) based on internal credit and collection policies.
• Documentation: Compile and provide necessary account statements, bounced cheque details, and borrower histories to the legal team for drafting notices.
• Status Tracking: Maintain a tracker of all accounts in the legal pipeline, updating case statuses and sharing progress reports with the Collection Head.

Key Skills & Competencies

• Advanced Excel Proficiency: Mastery of VLOOKUP/HLOOKUP, Pivot Tables, conditional formatting, complex formulas, and data validation. (Knowledge of Macros/VBA is a strong plus).
• Analytical Mindset: Strong ability to interpret numerical data, spot trends in borrower defaults, and draw logical conclusions.
• Stakeholder Management: Excellent verbal and written communication skills to effectively coordinate with aggressive field teams and formal legal departments.
• System Familiarity: Prior experience working with NBFC Loan Management Systems (e.g., FinnOne, Pennant, or similar software).
• Detail-Oriented: High accuracy in data handling; a zero-tolerance approach to data leakage or misreporting.

Qualifications & Experience

• Education: Bachelor’s degree in commerce
• Experience: 2 to 5 years of proven experience in MIS and data management, specifically within the collections, recovery, or risk department of an NBFC or Bank.