Sr Manager - DSMG strategy and Analytics

Tata Capital; Mumbai; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

Tata Capital is seeking a Manager to own data management, MIS design, and advanced analytics for the MFI portfolio within DSMG. You will transform raw data into strategic insights, drive evidence-based recovery strategies, and strengthen collection efficiency through dashboards, reports, and predictive models.

The role requires deep hands-on experience with SQL, Excel, and BI tools to deliver real-time visibility and actionable recommendations for field teams, legal partners, and agency

Qualifications

• Strong command of SQL and advanced Excel for data manipulation and reporting.
• Experience designing dashboards and dashboards automation.
• Experience with BI tools for real-time analytics and decision support.

Responsibilities

• Own MIS data management and governance for the MFI portfolio.
• Lead analytics portfolio insights including NPA flow and recovery patterns.
• Develop predictive models for risk prioritization and field strategy.
• Collaborate with risk, product analytics, and governance teams.

Skills

SQL

Excel (Advanced)

Power BI

Tableau

Education

Graduate/Postgraduate in Data Analytics/Statistics/Finance/Engineering

Tools

Power BI

Tableau

Job description

Job Summary

Job Purpose: 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.

Key Responsibilities

MIS Data Management

• 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.

Analytics Portfolio Insights

• 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.

Strategy Development Impact Monitoring

• 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.

Cross-Functional Collaboration

• 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.

Key Skills Competencies

• 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.

Qualification Experience

• Graduate/Postgraduate in Data Analytics, Statistics, Finance, or Engineering.
• Prior experience in handling MFI or rural lending portfolios is highly preferred.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.