Job Description

Join us as an "CMBS Originations & Underwriting - AVP" at Barclays, a transatlantic consumer, corporate and investment bank offering products and services across personal, corporate and investment banking, credit cards and wealth management, with a strong presence in our two home markets of the UK and the US. Our goal is to become the bank of choice by providing superior services to customers and clients and supporting our stakeholders via a commercially successful business that generates long-term sustainable returns.


To be a successful "CMBS Originations & Underwriting - AVP" candidate is consistent with the objective of delivering long-term sustainable value for all our stakeholders, we have developed our Shared Growth Ambition - our approach to citizenship and the sustainability of the business model we operate. The aim is to make decisions and do business that provides our clients and customers, and the communities which we serve, with access to a prosperous future.


You may be assessed on the key critical skills relevant for success supports the 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.

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. Streamlining, Automation, Tool Building to assist decision making and increase efficiency in the team. Drive the optimisation and automation of any databases and standardised reports.

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. Experience in preparing Narratives or Asset Summary reports of the transaction. Good at Senior stakeholder engagement. Strong Analytical skills and hands-on approach to problem solving. Expert in PowerPoint presentations, writing reports and designing storyboards. Strong knowledge and hands-on experience in one of the programming languages Python, VBA, R, C++ is highly preferred. Enhance Controls, streamline processes and bring efficiencies through automation, wherever possible. Proficiency in MS Excel, Word and PowerPoint. Programming skills/ exposure to Tableau, Qlikview, Python is an added benefit. Exposure to Generative AI/ ML. 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.