This role is responsible for end-to-end ownership of data management, MIS design, and advanced analytics for the MFI portfolio under the DSMG function. The Manager will play a critical role in transforming raw data into strategic insights, driving evidence-based recovery strategies, and strengthening the overall collection efficiency through robust dashboards, reports, and predictive models.
- Design and maintain a comprehensive MIS framework to track recovery, delinquencies, roll rates, agency performance, and legal recoveries across all MFI portfolios.
- Ensure accuracy, consistency, and governance of all data sources used by the DSMG team.
- Build automated reporting systems and ensure timely publication of daily, weekly, and monthly reports.
- Own the development and standardization of dashboards (Power BI/Tableau/Excel) for real-time visibility.
- Perform deep-dive analyses on NPA flow, bounce rates, forward/rollback movement, and segment-level resolution behavior.
- Lead vintage, cohort, and root cause analysis to identify patterns in default behavior and recovery effectiveness.
- Develop predictive models for risk prioritization, bucket behavior, settlement likelihood, and field strategy optimization.
- Collaborate with risk and product analytics teams to derive customer scorecards and segmentation logic for better strategy alignment.
- Translate analytical insights into executable strategies for field teams, legal teams, and agency partners.
- Design KPI-based allocation strategies, campaign segmentation logic, and early warning triggers.
- Evaluate the performance of implemented strategies through pre/post-impact studies and provide agile feedback loops.
- Work closely with collections, product, legal, and technology teams to support decision-making and tech-based automation.
- Act as the data custodian for the DSMG-MFI vertical and support internal/external audits and compliance requirements.
- Proficient in SQL, Excel (Advanced), and Power BI/Tableau – Must have hands-on experience.
- Solid understanding of collections lifecycle, stress asset behavior, and recovery levers (legal, agency, campaigns).
- Ability to build, interpret, and communicate data stories for business action.
- Strong problem-solving mindset with experience in hypothesis testing, scenario analysis, and impact modeling.
- Exposure to data governance, dashboarding best practices, and automation of MIS pipelines.
- Graduate/Postgraduate in Data Analytics, Statistics, Finance, or Engineering.
- 5–8 years of experience in analytics, MIS, or strategy roles, preferably within NBFC, MFI, or BFSI collections/risk domain.
Prior experience in handling MFI or rural lending portfolios is highly preferred.