Real Estate Financial Analyst: Pro Forma & Market Insights

MIMCO LLC; El Paso (TX); On-site; USD 70,000 - 110,000; Full time

Job summary

MIMCO LLC seeks a highly analytical Financial Analyst to support acquisition, disposition, and development activities through financial modeling, debt management, market analysis, and budgeting. This role will drive accurate projections and data-driven investment decisions in a fast-paced environment.

The position requires advanced Excel modeling and proficiency with Yardi, plus familiarity with CoStar, to deliver timely insights to senior management.

Qualifications

• Bachelor’s degree in finance, accounting, real estate, economics, or related field.
• Minimum of 2 years of real estate financial analysis or underwriting experience.
• Strong proficiency in Microsoft Excel with advanced modeling skills.
• Familiarity with Yardi (Debt Menu and IM) preferred; exposure to Claude Excel plug-in is a plus.
• Solid analytical, problem-solving, and communication skills.
• Ability to manage multiple priorities and deadlines with attention to detail.

Responsibilities

• Produce and maintain acquisition, disposition, and development pro formas for MIMCO and affiliates.
• Develop refinance strategies and evaluate lender options; assist in refinancing loans ≤ $5M.
• Prepare quarterly debt portfolio reports for SVP of Finance.
• Assist with inputting debt information into Yardi systems.
• Conduct real estate market research, including comps and rental analysis; use CoStar.
• Support ad hoc financial analysis and investor relations; assist with Yardi IM.
• Complete seasonal valuations for MIMCO entities; participate in annual tenant reconciliations.
• Ensure accuracy, compliance with policies, and handle other duties as assigned.

Skills

Excel

Advanced modeling

Analytical skills

Communication skills

Time management

Problem-solving

Education

Bachelor’s degree in finance/real estate/economics

Tools

CoStar

Yardi

Claude Excel plug-in

Job description

MIMCO LLC seeks a highly analytical Financial Analyst to support acquisition, disposition, and development activities through financial modeling, debt management, market analysis, and budgeting. This role will drive accurate projections and data-driven investment decisions in a fast-paced environment.

The position requires advanced Excel modeling and proficiency with Yardi, plus familiarity with CoStar, to deliver timely insights to senior management.