Real Estate Analytics & Strategy Analyst

Aon; Chicago (IL); Hybrid; USD 72,000 - 84,000; Full time

Benefits offered by this job

Comprehensive benefits package

401(k) with employer contributions

Paid time off and holidays

Tuition assistance

Employee assistance program

Job summary

A global consulting firm in Chicago is looking for a Real Estate Project Analyst responsible for preparing presentations and financial models, supporting transaction managers, and leading special projects. Ideal candidates will have 2+ years in corporate real estate, expertise in Excel and Power BI, and strong communication skills. This hybrid role requires presence in the Chicago office three days per week and offers a comprehensive benefits package.

Qualifications

• 2+ years in corporate real estate experience is required.
• Proficient in creating dashboards and working in Power BI.
• Experience with Excel in handling large spreadsheets.

Responsibilities

• Prepare real estate presentations and financial models for senior management.
• Support transaction managers in lease transactions and corporate lease administration.
• Communicate real estate plans through written and verbal presentations.

Skills

Corporate real estate experience

Excel (VLOOKUPs, macros, pivot tables)

Dashboard creation in Power BI

PowerPoint presentation skills

Financial modeling experience

Education

Bachelor’s degree in Real Estate, Business Administration, Mathematics, Data Analysis

Job description

A global consulting firm in Chicago is looking for a Real Estate Project Analyst responsible for preparing presentations and financial models, supporting transaction managers, and leading special projects. Ideal candidates will have 2+ years in corporate real estate, expertise in Excel and Power BI, and strong communication skills. This hybrid role requires presence in the Chicago office three days per week and offers a comprehensive benefits package.