Private Real Estate - Research Analyst

Based in Hartford, CT, HIMCO is seeking a Research Analyst on the Private Real Estate Team supporting new loan originations and equity acquisitions across the country. This individual will provide real estate research, underwriting, valuation, and analytical support to support the Real Estate team with approximately $6.0 billion in commercial mortgages and $1.6BB of real estate investment (gross asset value). The ideal candidate will have the potential and desire to grow, with increasing knowledge and experience, into a direct production role.

Major Functions:

•Provide analytical support, including assistance in evaluating and structuring transactions, to the real estate acquisition team. This will include:

•Modeling base line property level cash flows and determining property valuations utilizing the discounted cash flow method in ARGUS and excel.

•Developing, modifying, and maintaining complex Excel based modeling tools

•Testing and validating assumptions used in modeling investments, including market rents, projected rent growth and current and future market vacancy in the subject submarkets.

•Conduct analysis and compile stressed scenario analysis in support of investment recommendations

•Conduct property inspections to verify valuation assumptions

•Work with Producers in preparing loan committee packages and investment committee memos; work with Producers and Attorneys on term sheets, applications, loan documents, and other transactional documents; coordinate internal reviews of all 3rd party reports including appraisal reviews.

•Preparation of closing documents and reports for new and current loans and investments, specifically:

•Reviewing, in consultation with legal counsel and Asset Management, operative deal documents to assure that business terms negotiated by Producers are properly reflected

•Conduct market analysis, including monitoring of the markets and regulatory environments for trends that could impact investments

•Conduct research as directed on markets, asset classes, companies, industries and/or sector (s); interpret and share outcomes of analyses to support investment recommendations

Qualifications:

5+ years of Investment Real Estate experience

Proactive learner and critical thinker with strong analytical and credit analysis skills

Finance degree and/or CFA strongly preferred

Effective verbal and written communications skills, persuasive negotiation skills.

Sound judgment and decision making skills

Proficient in Excel and Word (Argus preferred); experience with modeling and scenario analysis

Drive and potential to grow into a producer role.