Rotational Financial Analyst – Real Estate Growth

SmartRecruiters, Inc.; Chicago (IL); On-site; USD 72,000 - 88,000; Full time

Benefits offered by this job

Rent discount

Health insurance (Medical, dental, & V

401(k) plan

Paid time off

Parental leave

Tuition assistance

Commuter benefits

Career growth

Job summary

AIR Communities is offering a three-year Medley Analyst Rotational Program with six six-month rotations across FP&A, Operations Finance, Debt Capital Markets, Insights, Investments, and Asset Management. You will gain hands-on experience in the real estate lifecycle, including market analysis, acquisitions, budgeting, and performance reporting.

The program begins in 2027, with bachelor’s or master’s degree expected between December 2026 and June 2027.

Qualifications

• Graduating with a bachelor’s or master’s degree between December 2026 and June 2027, preferably with a major in Accounting, Business, Economics, Finance, Analytics, Real Estate, Engineering, or a related field (but not required).
• Strong desire to learn how to be a well-rounded multifamily investment, asset management, and operations professional
• Experience with MS Excel
• Ability to prioritize and multi-task in a fast-paced environment
• Excellent organizational skills and attention to detail
• Excellent analytical and problem-solving skill
• A commitment to doing things differently and making the world a little bit better
• A naturally collaborative nature

Responsibilities

• Conduct in-depth analysis of large, complex datasets to uncover actionable insights related to asset performance, market dynamics, and resident behavior.
• Collaborate with cross-functional teams—including Finance, Asset Management, and Capital Finance—to support strategic initiatives and drive portfolio optimization.
• Build and enhance dashboards, reports, and presentations that translate data into compelling narratives for internal stakeholders.
• Assist in financial planning and analysis activities, including budget variance reviews, forecasting, and mid-year reforecasting processes.
• Contribute to process improvement efforts through documentation, training support, and testing of new systems and tools.
• Leverage advanced BI platforms to support data visualization and performance reporting.
• Audit and validate key operational datasets to ensure data integrity and usability across business functions.
• Participate in high-impact, ad hoc projects that inform executive decision-making and shape business strategy.
• Participate in targeted professional development and financial skills training.

Skills

MS Excel

Analytical thinking

Attention to detail

Collaboration

Fast-paced environment

Education

Bachelor's or Master's degree

Tools

Databricks

Power BI

Entrata

Oracle PBCS

Job description

AIR Communities is offering a three-year Medley Analyst Rotational Program with six six-month rotations across FP&A, Operations Finance, Debt Capital Markets, Insights, Investments, and Asset Management. You will gain hands-on experience in the real estate lifecycle, including market analysis, acquisitions, budgeting, and performance reporting.

The program begins in 2027, with bachelor’s or master’s degree expected between December 2026 and June 2027.