Portfolio Analyst

Role Description

• Loans / lending commitments are a key component of the relationships held by Deutsche 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 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 using single name CDS and the issuance of CLOs referencing the underlying loan risk. Along with hedging the credit risk of loan book, CLOs also provide regulatory capital relief to the Bank.
• The CLO servicing team provides support to the SCL Securitization teams in New York, London and Frankfurt that originate and execute CLOs to facilitate the economic risk hedges required for its hedging / RWA relief mandate. Team is currently assisting in managing multi-billion size of SCL CLO portfolios, along with transactions that assist other Corporate Bank, Investment Bank and Private Bank business areas in managing their own hedging / RWA relief mandates. The investors in these transactions are some of the Banks largest institutional clients including investment funds, pension funds and hedge funds as well as supranational institutions.The CLO servicing team currently has six members in Mumbai. We are expanding the team to hire two more people for supporting workstreams related to the issuance and servicing of CLOs which securitize the Banks German consumer loans portfolio with the aim of generating regulatory capital relief for the Bank.

Your key responsibilities

• Independently automating of existing manual tasks using Python/ excel vba
• Interpreting / analyzing/ working on large financial data sets
• Assist in CLO origination related tasks from portfolio construction, performing checks to ensure the portfolio complies with CLO documentation, preparing data/analysis requested by potential investors
• Monthly CLO replenishment/rebalancing activities, including verification of asset events, identifying data issues, verifying replenishment eligibility and selecting assets with the aim of optimizing RWA relief for the Bank
• Regular data quality checks to ensure accurate data for monthly CLO replenishments; working with relevant teams such as Technology and Loan Operations teams to identify and fix the root causes
• Deep dive investigations into unexplained or unclear asset activity, working with relevant cross-functional teams including Private Bank, Finance, Credit Risk Management, Technology and Loan Operations teams
• Development and modification of desk tools to assist in CLO origination, CLO replenishment and risk management analysis
• Review of CLO documentation and Simple, Transparent and Standardised (STS) criteria
• Calculation of note holder payments and co-ordination with Treasury, Finance and Paying Agents to ensure payments are correctly made to CLO Investors
• Preparation of Credit Event Notices in line with CLO documentation and working with external accountants to demonstrate CLO compliance to contractually documented terms & conditions
• CLO termination and redemptions tasks including informing relevant teams in Finance, Treasury and Paying Agents, and ensuring internal systems are updated
• Preparation of European Securities and Markets Authority (ESMA) Investor Disclosure templates
• Working on miscellaneous reports and ad-hoc analysis as requested by SCL management

Your skills and experience

• Graduate / Postgraduate with 7-8 years of work experience (We are open to consider suitable candidates with lesser experience)
• Excellent Python/ vba skills and should be able automate tasks independently using Python/ vba
• Excellent excel skills including extensive use of formulas comfortable in building ad-hoc excel based tools to assist in day-to-day tasks
• Should be comfortable in handling large financial data sets/excel files
• Prior work experience in securitization will be added advantage (but not must)
• Excellent communication skills and initiative to engage with other teams
• Strong attention to detail
• Demonstrable problem-solving ability, organized with an ability to manage multiple issues
• High degree of initiative but also the ability to raise problems immediately to the broader SCL team when necessary