Analytics Analyst 3-4 Years

Job Description

Note :

• Round 1 will be excel test.
• Specific / mandatory skills : Advanced excel & analytical sills
• Experience range : 3-4 Years
• Open to considering fresher candidates (Yes / No) : Yes, but should be good at excel
• Open to considering relocation / non-local candidates (Yes / No) : Yes
• Contract duration : 6 months
• Shift timings : 11.00 am to 8.30 PM
• Number of days work from office : 2 days
• Preference of hiring only diversity candidate (Yes / No) : No

Description :

Business / Team Description Loans / lending commitments are often a key component of the relationships held by Bank with its corporate and financial institutional clients. Relationship loans are typically issued to support the generation of franchise revenues booked by the product lines across the Corporate Bank and Investment Bank divisions. Strategic Corporate Lending ('SCL') provides governance around the investment of loan capital into these client relationships and risk manages the approved final hold positions down to pre-defined thresholds set by Credit Risk Management. SCL owns the loan risk that it is hedging within its predominantly senior, unsecured asset class Institutional and Corporate Credit portfolio. SCL hedges the final hold positions down to the pre-defined thresholds using single name CDS and the issuance of CLOs referencing the underlying loan risk.

SCL Client MIS team within SCL is primarily responsible for assisting loan execution team in Capital allocation forum (CAF) memo preparation which enables the SCL regional heads on lending decision making process. Additionally, the team provides various tools to monitor the cross sell & profitability of relationship lending

Job Responsibilities

Key Competencies

Skills Required

Advanced Excel, Basic Vba, Excel Macros