Data Analyst - NBFC - Contractual Role

Data Analyst - Topt-tier NBFC - Contractual Role

At Outsized, we match clients in financial services and management consulting to high-quality independent consultants and boutique/specialist firms for the execution of their key projects.

Our client, a prominent non-banking financial company (NBFC) in India, is actively seeking a Data Analyst with prior experience working with R programming language to join their team in Mumbai. Presently, the data analytics function is outsourced to an external partner, but the company is now aiming to develop this capability internally.

Key responsibilities:

1. Product MIS:

-Product Through The Door (TTD) metrics monitoring through dashboards: logins, approvals, sanctions, disbursals, rejections, approval Rates, write rate, TAT (vertical/LOB wise, location/geography-wise, program-wise, policy-wise, collateral wise)

- Portfolio metrics monitoring: coincidental delinquency tracking (30+, 60+, 90+), butterfly charts and static pool analysis, collection efficiency, and bounce tracking. program-wise, policy-wise, collateral-wise

- Productivity tracking: sales and rredit productivity tracking (no of logins, sanctions, disbursals per DST/CM, etc).

2. Analytics and Modeling:

- Statistical Modeling such as time series forecasting, decile/quintile/quartile distributions of data, performance and delinquency and risk ranking

- Preparing Scorecards and rate calculators with metrics such as income program, customer bureau score, property type, loan type, etc.

- Preparing excel calculators for retention, rate benefit/reduction, top-up eligibility, interest saving

- R coding for filtering data, combining data, and calculating fields from various data sources as metadata (LOS/LMS dumps, manual MISs/excels, database tables, etc).

- VBA and macros for Excel reports having pivots, slicers, graphs

3. Presentations/Decks and Data views:

PPT/Views to show movements and interpretation of various metrics through graphs/charts etc

Ideal background:

- 7 to 12 years of experience in data analytics

- Prior experience working with R programming language and Microsoft Excel is mandatory

- Substantial experience in the BFSI industry is mandatory

- Advanced Excel skills (pivots/power pivots, slicers, macros, VBA) and understanding of data sources

- A reliable team player with strong interpersonal skills, ability to actively incorporate input from various sources and collaborate with others for preparing data reports for specific actionable

- Understanding of lending/assets and strong presentation skills is a plus

This is a 12-month contractual opportunity. The project location for this role is Mumbai.