Analyst CMBS

Join us as an “Analyst CMBS ” at Barclays, CMBS origination team underwrites loans secured by commercial mortgages that are securitized in CMBS transactions. For each loan request, they are responsible for assessing the property economics in determining the appropriate loan amount, interest rate to be charged, risk inherent into the transaction and ensuring that all loans meet Barclays’ criteria.  Additionally, the team performs quarterly analysis of Balance Sheet loans and is involved in the underwriting & due diligence of the Acquisition facilities.                                                

To be a successful “Analyst CMBS” CMBS Underwriting and Origination team through financial modelling and deal review of the loan requests that they receive. The team prepares Loan Review Forms, Preliminary Underwriting/ Cash Flow Models, and Asset Summary Reports that help in determining whether Barclays should proceed with each transaction; and the loan amount, loan structure and spreads to be charged. The team is also responsible for creating and maintaining a database of static information for all the Conduit and SASB Deals issued since 2015 which allows easy comparisons for current deals and better due diligence.

You may be assessed on the key critical skills to help the team to size the number of deals that the team currently works on with the CMBS underwriters and Originators in New York and Los Angeles.

Basic/ Essential Qualifications:

• Review Offering Memos prepared by brokers and/or Borrowers to gain an understanding of the real estate and the requested financing.

• Evaluate and compile property level income statements, rent roll, reimbursements, occupancy statics, sales and occupancy cost information and other information into excel-based models.

• Compile market research to determine and verify a project’s economics and assumptions in the model. Market research will include third party sources (such as CoStar, Reis, Smith Travel Research and others) as well as public information available on the internet.

• Review tenant leases and related documentation and prepare an abstract of key terms.

• Evaluate historical and projected capital expenditure budgets.

• Prepare asset summary reports which cover short descriptions of property and market characteristics, and strengths and weaknesses of the transaction.

• Underwriting & Due Diligence of the Acquisition facilities.

• Quarterly performance analysis of Balance Sheet loans which include analysing the financial statements, rent rolls, occupancy statistics, covenants tracking, and transaction updates for the loans.

• Manage CMBS data and aid in aggregating, sourcing, and populating centralized databases.

• Oversee the work of juniors/new joiners in the team.

Desirable skillsets/ good to have:

• Postgraduate Degree (or equivalent)

• With prior experience in Real Estate finance or securitized products like CMBS, RMBS, etc.

• Excellent knowledge of Real Estate metrics and financial statements.

• Experience working in CMBS issuances and managing data.

• Excellent in Analytical skills and will be responsible for analyzing the results of the tests that they have developed.

• Experience in preparing Narratives or Asset Summary reports of the transaction.

• Experience in Due Diligence process.

• Experience of working on Argus Software.

• Familiar with Bloomberg or Trepp.

• Familiar with various market reports like CoStar & REIS.

This role will be based out of Mumbai.

Purpose of the role

To maintain the smooth and efficient operation of our trading desks, providing operational support and expertise to traders, sales professionals, and other key stakeholders, helping them maximize their productivity and minimize disruptions and handling administrative tasks, and providing market information and research. 

Accountabilities

• Provision of immediate and efficient technical support to traders and sales professionals on the trading desks, resolving hardware, software, and network-related issues to ensure uninterrupted trading activities.
• Coordination of trade execution by liaising with traders, clients, and other internal teams to ensure smooth transactions.
• Maintenance and updating of trade records, transaction logs, and client databases accurately.
• Reports, presentations, and documentation preparation to support sales and trading activities.
• Monitoring of market data and assist in the analysis of financial information for trading decisions.
• Operational tasks such as processing trades, confirming orders, and resolving trade discrepancies.

Assistant Vice President Expectations

• To advise and influence decision making, contribute to policy development and take responsibility for operational effectiveness. Collaborate closely with other functions/ business divisions.
• Lead a team performing complex tasks, using well developed professional knowledge and skills to deliver on work that impacts the whole business function. Set objectives and coach employees in pursuit of those objectives, appraisal of performance relative to objectives and determination of reward outcomes
• If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard. The four LEAD behaviours are: L – Listen and be authentic, E – Energise and inspire, A – Align across the enterprise, D – Develop others.
• OR for an individual contributor, they will lead collaborative assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments. They will identify new directions for assignments and/ or projects, identifying a combination of cross functional methodologies or practices to meet required outcomes.
• Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues.
• Identify ways to mitigate risk and developing new policies/procedures in support of the control and governance agenda.
• Take ownership for managing risk and strengthening controls in relation to the work done.
• Perform work that is closely related to that of other areas, which requires understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.
• Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategy.
• Engage in complex analysis of data from multiple sources of information, internal and external sources such as procedures and practises (in other areas, teams, companies, etc).to solve problems creatively and effectively.
• Communicate complex information. 'Complex' information could include sensitive information or information that is difficult to communicate because of its content or its audience.
• Influence or convince stakeholders to achieve outcomes.

All colleagues will be expected to demonstrate the Barclays Values of Respect, Integrity, Service, Excellence and Stewardship – our moral compass, helping us do what we believe is right. They will also be expected to demonstrate the Barclays Mindset – to Empower, Challenge and Drive – the operating manual for how we behave.