Job DescriptionCLO Analytics, Modeller
• Build, maintain and review financial models for CLO Transactions
• Liaise with business partners (Technology, Legal, Compliance, Trustee, Relationship Management, Deal Admin and Sales) to ensure highest client service levels in compliance with US Bank standards
• Understand the CLO mechanics, review securitization documentation and provide commentary prior to deals closing to ensure we can complete the requirements and that the language is in line with US Bank practices
• Collaboration across teams to drive solutions, Responsible for developing value added partnerships with Relationship Management and Deal Administration to assist in client deliverables and improving defining process and techniques to improve efficiency and delivery
• Provide Innovative client solutions
• Program and reverse engineer financial models according to the terms and conditions defined in securitization documents
• Use excel models to allocate a collateral pool’s payments to various bondholders, swap counterparties, and investment managers
• Stress-test cash flow and collateral performance to gauge impact to portfolios under adverse market conditions
• Calculate various portfolio statistics, ratios and thresholds for use in hypothetical trading scenarios and periodic reporting
• Use SQL and other software to manipulate the considerable amount of collateral-related information maintained in the US Bank databases
• Working closely with the US to align modelling spec's and drive efficiencies
Key Skills and Competencies
• Advanced financial modelling skills, preferably with Structured Finance and/or CLO modelling experience
• Market awareness
• Clear communication skills on requirements and updates
• Building and maintaining partnerships both internally and externally
• Legal documentation review skills
• Strategic thinking
• Complex analytic transaction skills
• Problem-solving skills
• Compliance with all policies and procedures at bank-wide and departmental levels
: