Financial Analyst

AIR Communities; Chicago (IL); On-site; USD 80,000 - 96,000; Full time

Benefits offered by this job

Health insurance

Rent discount 25%

401(k) with employer contribution

Paid time off and holidays

Parental leave

Tuition assistance

Professional development

Commuter benefits

Pet insurance

Discounts

Job summary

AIR Communities is seeking a Medley Analyst Rotational Program participant to develop multifamily real estate leadership over three years across FP&A, Asset Management, and Revenue & Performance.

You'll rotate through six six-month assignments, building dashboards and analyses with tools like Databricks, Power BI, and Oracle PBCS while collaborating with Finance, Asset Management, and Capital Finance.

Qualifications

• Graduating between December 2026 and June 2027 with a bachelor’s or master’s degree.
• Strong desire to learn multifamily investment, asset management, and operations.
• Experience with MS Excel.
• Excellent analytical and problem-solving skills.
• A naturally collaborative nature.

Responsibilities

• Conduct in-depth analysis of large datasets to uncover actionable insights related to asset performance and market dynamics.
• Collaborate with cross‑functional teams—Finance, Asset Management, and Capital Finance—to support strategic initiatives and portfolio optimization.
• Build and enhance dashboards, reports, and presentations for internal stakeholders.
• Assist in budgeting, forecasting, and mid‑year reforecasting processes.
• Contribute to process improvement through documentation, training support, and testing of new systems and tools.
• Leverage Databricks, Power BI, Entrata, and Oracle PBCS for data visualization and reporting.
• Audit and validate key operational datasets to ensure data integrity across functions.
• Participate in high‑impact projects that inform executive decision‑making.

Skills

MS Excel

Analytical thinking

Multi-tasking

Team collaboration

Communication skills

Attention to detail

Education

Bachelor's or Master's degree in a relevant field

Tools

Databricks

Power BI

Entrata

Oracle PBCS

Job description

Company Description

AIR Communitiesis a Blackstone portfolio company headquartered in Denver, CO. We are one of the country's largest owners and operators of multifamily housing, managing high-quality properties in most major markets. At AIR, we value integrity, respect, collaboration, customer focus, and performance. These values are brought to life by our teammates, who are ultimately responsible for our success. When you join our team, you'll work alongside the most dedicated professionals in the industry and open the door to unlimited career opportunities.

Where You Will Work

This opportunity is physically located in either our Denver, CO headquarters or Chicago, IL office. Throughout the three-year program you may also have the opportunity for a rotation in one of our other AIR offices.

This is a 5-day a week, fully on-site position.

This is a Rotational Analyst Program, spanning 3 years.

Job Description

Our three-year Medley Analyst Rotational Program is designed to develop the next generation of multifamily real estate leaders. Through six, six-month rotations, analysts gain hands‑on experience across key business functions, including, but not limited to, FP&A, Operations Finance, Debt Capital Markets, Insights, Investments, Asset Management, and Revenue & Performance.

Participants build a comprehensive understanding of the real estate investment lifecycle, from market analysis, acquisitions, and financing to budgeting, revenue management, asset management, and dispositions. Along the way, analysts contribute to meaningful projects that directly support AIR’s business and growth.

Supported by a robust training curriculum focused on technical expertise, industry knowledge, and professional development, Medley Analysts graduate from the program as strategic, well‑rounded professionals. At the conclusion of the program, analysts participate in a matching process to transition into a permanent role aligned with business needs and their skills and interests.

Our 2027 Analyst Program will begin in either January or July 2027, dependent on candidate graduation date. Qualifying eligible candidates must be graduating with a bachelor’s or master’s degree between December 2026 and June 2027.

A Snapshot Of What You May Do

• 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 business intelligence platforms (e.g., Databricks, Power BI, Entrata, Oracle PBCS) 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.

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

What We Offer

• Expected pay rate of $80,000 plus annual target bonus. You will be provided a pay rate that is in line with your skills and experience as they relate to the requirements of the job.
• 25% Rent Discount at any AIR community (a rental application is required, and certain exclusions apply).
• Medical, dental, vision, and life insurance options, HSA/FSA plans, short and long‑term disability paid by the company.
• 401(k) plan with up to 6% employer contribution.
• Paid time off including vacation, sick time, and 14 holidays.
• Paid parental leave of up to 16 weeks.
• Tuition assistance program and up to 100% reimbursement for job‑related certifications and licenses.
• 15 hours of paid time annually for community service.
• Commuter benefits and pet insurance.
• Consumer discounts on various products and services.
• Opportunities for ongoing professional development, leadership training, and career growth.

What You Need to Know

Application Deadline: The initial deadline for applications is 10/12/2026. Applications submitted after this date may still be considered on a rolling basis until the position/program is filled. If a final decision has not been made by the initial deadline, subsequent applications will be reviewed as they are received.

Candidates extended an offer will be required to undergo pre‑employment screening that includes checking references, a four‑panel drug screening that excludes marijuana testing, employment verification & criminal background check.

AIR values diversity and provides equal employment opportunities to all employees and applicants for employment. AIR prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.