Data Analyst

Skills

Knowledge of and certifications in programming, SAS/SQL/Python/ Tableau

Knowledge of best practices in coding, data manipulation and creating reusable artifacts

Knowledge of Banking / Financial Services Industry with preference in lending space (Personal Loans, Credit Cards, Auto loans etc.)

Ability to create recommendations and insights from data for developing risk strategy

Experience with utilizing credit risk data marts using internal and third party data

Ability to design the right KPIs for measuring strategy success

Understanding of various elements of risk strategy, such as delinquencies, roll rates, recoveries from both internal third party etc

Ability to communicate and present the results to business stakeholders

Description

Job Role: 

Good knowledge of SQL and MS Excel

Responsible for reports automation

Monthly login count is around 1,25,000 approx with input variables of approx 60 -70, multiple reports/ data is to be checked with various permutation and combinations

Multiple reports to be prepared on Portfolio parameters

Dialer reports where we are pushing 8-9 variables from dialer to LOS, various reports on logs and failures has to be maintained with various permutation and combinations

Monthly dashboard reports

Key Responsibilities:

Collaborate across other risk functions (example technology, product, etc.) to implement the analytical decisions.

Design and analyze campaigns for collections and recoveries related strategies using SAS/SQL.

Develop, maintain and improve risk policies, processes and procedures within the assigned function.

Utilize application, bank and bureau information to derive business insights KPI generation, tracking of risk and delinquency metrics for portfolios using SQL/Tableau Revamp collections strategy changes and launch A/B test to monitor impact and performance of the change.