Analyst in Situs Asset Management

Since 1985, Situs has been the premier, global provider of end-to-end commercial real estate and loan advisory services and integrated solutions, offering customized services to leading financial institutions, investors, owners, and developers. We offer a wide array of services, including enterprise and process improvement, capital markets and commercial real estate advisory, primary and special servicing, and creative staffing solutions.

Member of the Asset Management team which is responsible for managing, monitoring and reporting on the performance of TRT’s $3.6B portfolio of largely transitional commercial real estate loans. This role will involve working closely with the Situs Asset Management Team, TPG, and the Situs Servicing team to deliver accurate, timely and consistently high quality services.

* Model new assets in loan performance models that report historical and projected cash and P&L. This may involve making customizations of template based on negotiated loan terms, and coordination with underwriters, Servicing, and Asset Management. * Review and summarize deliverables and milestones provided under loan documents and enter those requirements in an Asset Management-focused Access database * Spread financial statements * Loan to Value, Debt Yield and Debt Service Coverage Ratio analyses * Prepare monthly asset-level reports in Excel * Gather market data in terms of rent, occupancy, absorption, sales trends, etc. * Support asset management team in their daily responsibilities * Assist in preparation of quarterly collateral valuations * Assist in preparation of various ad-hoc reports

* Strong analytical and computer skills with a thorough knowledge of Excel including the ability to perform cash flow analyses. Must be able to work efficiently with large datasets to process and present results as requested * Ability to work in a team environment, to think independently and generate quality work product * Ability to manage multiple priorities and meet tight deadlines * Adhere to processes and procedures but suggest and implement improvements when warranted * Attention to detail is a must * Strong reading comprehension * Strong business writing, presentation and interpersonal skills **Required Work Experience & Education:** * Internship or approximately 1 year of experience in the financial services industry with a focus on real estate finance. * A bachelor’s degree in finance, accounting or related subjects * Experience with VBA and Access very helpful; experience with Argus desirable, but not required