Cmbs Originations

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