Senior Portfolio Analyst, Real Estate Debt Group

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., one of the nation’s largest sources for real estate first mortgage financing, is actively recruiting a Senior Portfolio Analyst to join a group that manages a $4.4 billion portfolio. Ullico’s Real Estate Debt Group offers construction and permanent debt financing for commercial real estate. This position reports to the Regional Vice President and is located in our Chicago, IL office.

The successful candidate will:

• Maintain overall statistics and financial performance analysis for the mortgage portfolio. Summarize and analyze reports for mortgage loans to include, but not limited to: analyzing operating statements on properties, obtaining financial background on properties, annual reviews, and project variance reports. Prepare quarterly portfolio statistics detailing geographic and product concentrations. Evaluate and recommend changes to reports to provide efficient and applicable information to management.
• Perform various analyses related to financial performance to include: cash flow projections, cash flow variance analysis, business operations "driver" analysis (critical success factors) and analysis of comparative performance with other companies in industry.
• Assist, coordinate and prepare financial projections for real estate and mortgage portfolio as required for internal reporting and external filing for both statutory and GAAP, as applicable.
• Assist in oversight and follow‑up on underwriting portions of loans to ensure all provisions are being adhered to.
• Prepare, secure approval and maintain portfolio data including monthly reports such as the J and W1 Portfolio Valuation, Performance Comparison, Property Income and Expense analysis for House Accounts and quarterly reports such as Appraisal Status, Annual Reviews, Portfolio Characteristics and General Account Valuation.
• Monitor individual asset reports due to VP from Regional Managers such as Construction Status reports, Multi‑Family Sales Status reports and Watch List reports. Prepare and submit to SVP for review and approval the same reports, when applicable, for House Accounts.
• Undertake ad‑hoc project and reports. Assist SVP/VP in the preparation of internal and external presentations.

Minimum Qualifications

• Bachelor’s degree in Finance, Economics, or a related field.
• 3 to 5 years of experience in commercial real estate loan underwriting, including financial/credit analysis, discounted cash flow (DCF), and net present value (NPV) modeling.
• Intermediate to advanced 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.

For over 95 years, Ullico, the only labor‑owned insurance and investment company, has been a proud partner of the labor movement. From insurance products for members, leaders and employers, to investments that have created thousands of union jobs, our customers continue to count on Ullico to protect them. The Ullico Inc. family of companies includes The Union Labor Life Insurance Company; Ullico Casualty Group, Inc.; Ullico Investment Company, Inc.; and Ullico Investment Advisors, Inc. Visit www.ullico.com.

Benefits

• Health/Dental/Vision
• Pension
• 401K
• Health Savings Account
• Life Insurance
• Paid Time Off

Ullico is an Equal Opportunity Employer. This organization participates in E‑Verify.

Salary Range: $120,000 - $156,500 (depending on relevant experience, skills, and credentials). This position is eligible to participate in Ullico Inc.’s annual incentive compensation program. An incentive award is contingent upon Ullico meeting financial goals set by the Ullico Board of Directors and your individual performance. The elements of the program, including eligibility, the range of potential incentive compensation, and the factors that determine the payment, will be shared with you after you become employed.