Analyst, Credit Analytics

SitusAMC•Overland Park, KS

1d•Remote

About The Position

This role will be part of the Credit Analytics team that is responsible for managing, monitoring, and reporting on the performance of a $100B+ portfolio of largely transitional commercial real estate loans. This role will involve working closely with the Situs Asset Management Team and Servicing team to deliver accurate, timely and consistently high-quality deliverables. The incumbent should possess strong analytical skills, advanced Excel skills and a basic understanding of real estate finance, terminology, and performance metrics.

Requirements

Bachelor’s degree in finance, accounting or related subjects or equivalent combination of education and experience.
Entry level professional with 0-2 years of industry and/or relevant experience, typically at an Analyst level role or external equivalent.
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.

Nice To Haves

Basic understanding of real estate finance, terminology, and performance metrics.

Responsibilities

Model new assets in loan performance templates that report historical and projected cash flow.
Determine and coordinate customizations of templates based on negotiated loan terms or analysis parameters required by underwriters, servicing, and asset management.
Review and summarize loan covenants provided under loan documents and enter those requirements in an asset management database.
Spread borrower-provided financial statements within financial models and advise on any emerging asset-level performance risk.
Perform loan to value, debt yield and debt service coverage ratio tests and advise asset management on loan performance based on Lender requirements.
Gather market data in terms of rent, occupancy, absorption, sales trends, etc. and advise asset management of any emerging market risk within assigned portfolios.
Process draw requests for loans with a construction or renovation component and make recommendations to asset management on funding conditions.
Prepare monthly/quarterly asset-level reports in Excel and review for accuracy.
Support asset management team in their daily responsibilities.
Assist in preparation of quarterly collateral valuations.
Assist in preparation of various ad-hoc reports.