Handle, monitor & develop Excel models & dashboards capturing holistic view of UK
based borrowers, through assessment of borrower on multiple parameters, including financial
performance / KPIs, profitability, risk and return metrics. Should be able to handle multiple input analysis
on Excel, and have an eye for minute details & be proactive.
Job Responsibilities:
- Portfolio Monitoring (focused for Business Retention, existing clients)
- Conducting assessment of existing loan book to identify retention cases and possible business opportunities based on applicable triggers.
- Collaborating with cross functional teams to analyze risk factors, internal guard rails, clients relationship with ON
- Developing detailed dashboards covering financial statement analysis, variance analysis, covenant analysis, credit metrics, qualitative inferences, etc.
- Daily interactions with colleagues to keep track of developments in portfolio, compared with targets
- Creating repayment reports / retentions reports with key takeaways; reports should be concise, easy to read for Sr. management / credit committee to review and comments.
- Comparative Analysis (real estate)
- Conducting detailed comparative analysis for valuation of real estate against market standards in similar categories
Desired Skills:
- Strong understanding of financial statements including important credit risk metrices and covenants
- Experience of creating succinct and analytical reports
- Personal drive (proactive), flexible, creative (thinks out of the box), result driven, responsible, team player & fast learner
- Hands on attitude, willing/capable to understand the big picture
- Ability to succeed in a culture where change and speed are part of daily work
- Education - Chartered accountant (completed or pursuing) / MBA with specialization in finance
- Skilled in MS-Excel, MS-Word, spoken and written English language
ShortDescription
- Handle, monitor & develop Excel models & dashboards capturing holistic view of UK based borrowers, through assessment of borrower on multiple parameters, including financial performance / KPIs, profitability, risk and return metrics. Should be able to handle multiple input analysis on Excel, and have an eye for minute details & be proactive.
