Senior Real Estate Portfolio Analyst: Cash Flow & Modeling

ULLICO Inc; Chicago (IL); On-site; USD 120,000 - 156,500; Full time

Benefits offered by this job

Health/Dental/Vision

Pension

401K

Health Savings Account

Life Insurance

Paid Time Off

Job summary

Ullico, Inc. seeks a Senior Portfolio Analyst to join its Real Estate Debt Group in Chicago, IL. You will manage mortgage portfolio analytics, cash flow projections, and reporting for internal and GAAP filings, reporting to the Regional VP.

You will support underwriting oversight, prepare quarterly and monthly reports, and coordinate ad-hoc analyses for senior management. Bachelor’s in Finance/Economics and 3–5 years CRE experience required.

Qualifications

• Bachelor’s degree in Finance, Economics, or related field.
• 3–5 years of experience in commercial real estate loan underwriting with financial/credit analysis, discounted cash flow (DCF), and net present value (NPV) modeling.
• Proficiency in Excel, SQL, VBA, and ARGUS financial modeling.
• Strong analytical, communication, and presentation skills for interaction with internal senior management and external business leaders.
• Must complete a financial modeling exercise.

Responsibilities

• Maintain portfolio statistics and financial performance analysis for the mortgage portfolio.
• Prepare quarterly portfolio statistics detailing geographic and product concentrations.
• Perform cash flow projections and variance analyses for the portfolio.
• Assist underwriting portions of loans to ensure provisions are adhered to.
• Prepare monthly and quarterly portfolio reports for internal and external stakeholders.
• Monitor asset reports and assist in internal/external presentations.
• Undertake ad-hoc projects and reports.

Skills

Excel

SQL

VBA

ARGUS modeling

Education

Bachelor’s degree in Finance, Economics, or related field

Job description

Ullico, Inc. seeks a Senior Portfolio Analyst to join its Real Estate Debt Group in Chicago, IL. You will manage mortgage portfolio analytics, cash flow projections, and reporting for internal and GAAP filings, reporting to the Regional VP.

You will support underwriting oversight, prepare quarterly and monthly reports, and coordinate ad-hoc analyses for senior management. Bachelor’s in Finance/Economics and 3–5 years CRE experience required.