Portfolio Insights Analyst: Real Estate Data & Dashboards

AIR Communities

Chicago (IL)

On-site

USD 85,000 - 95,000

Full time

1 hour ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Base pay: $85,000–$95,000 with annual-
Rent discount 25% at AIR communities
Medical, dental, vision, and life; HSA
401(k) with employer matching up to 6%
Paid time off: vacation, sick time, 14
16 weeks parental leave
Tuition assistance and certification
Community service time

Job summary

AIR Communities is seeking a Portfolio Insights Analyst to translate portfolio and operating data into clear, actionable insights for leadership across a multifamily portfolio. The role supports reporting, dashboard development, and ad hoc analyses.

Ideal candidates are analytical, curious, and comfortable handling complex datasets. You will develop dashboards with Power BI, SQL, and Oracle PBCS, collaborating across cross-functional teams to drive portfolio performance insights.

Qualifications

  • Bachelor’s degree in real estate, finance, economics, business, data analytics, or related field.
  • 1+ years of relevant experience.
  • Experience or interest in multifamily real estate or portfolio analytics.
  • Strong analytical and business acumen with complex data.
  • Proficiency in Excel; SQL querying and data analysis.
  • Experience with Power BI or Tableau; Oracle PBCS a plus.
  • Strong written/verbal/visual communication and detail orientation.

Responsibilities

  • Analyze portfolio-, market-, and asset-level performance to identify trends, drivers, risks, and opportunities.
  • Analyze operating metrics including gross and net rents, occupancy, retention, concessions, and rental income trends.
  • Support quarterly reporting materials and executive talking points.
  • Develop dashboards and analytical tools using Power BI, SQL, Oracle PBCS, and Excel.
  • Collaborate with Asset Management, Operations Analytics, Finance, Revenue Management, and Data Insights teams.

Skills

Excel
SQL
Power BI
Tableau
Communication skills

Education

Bachelor’s degree in real estate, finance, economics, business, data analytics, or related field

Tools

Oracle PBCS

Job description

AIR Communities is seeking a Portfolio Insights Analyst to translate portfolio and operating data into clear, actionable insights for leadership across a multifamily portfolio. The role supports reporting, dashboard development, and ad hoc analyses.

Ideal candidates are analytical, curious, and comfortable handling complex datasets. You will develop dashboards with Power BI, SQL, and Oracle PBCS, collaborating across cross-functional teams to drive portfolio performance insights.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Portfolio Insights Analyst — Data-Driven Real Estate Growth
Portfolio Insights Analyst — Data-Driven Real Estate Growth

AIR Communities • Denver (CO)

On-site
USD 85,000 - 95,000
Rent discount
Medical, dental, vision
401(k) with match
+3
Portfolio Analytics Lead: Real Estate Insights & Dashboards
Portfolio Analytics Lead: Real Estate Insights & Dashboards

PNC • Pittsburgh

On-site
USD 120,000 - 160,000
Medical coverage
Life insurance
Disability protection
+9
Portfolio Analytics Lead: Real Estate Data & Insights
Portfolio Analytics Lead: Real Estate Data & Insights

Pittsburgh Tomorrow • Pittsburgh

On-site
USD 120,000 - 170,000
Health benefits
401(k) with match
Paid time off
Real Estate Analytics Lead: Power BI & Portfolio Insights
Real Estate Analytics Lead: Power BI & Portfolio Insights

Cushman & Wakefield • Oregon

Hybrid
USD 81,000 - 95,000
Portfolio Analytics Lead - Power BI & AI Insights
Portfolio Analytics Lead - Power BI & AI Insights

BranCore Technologies • Chesterfield Court House (VA)

Hybrid
USD 85,000 - 110,000
Portfolio Data Analyst: Power BI & AI Insights (Hybrid)
Portfolio Data Analyst: Power BI & AI Insights (Hybrid)

Ampcus, Inc • Chesterfield Court House (VA)

Hybrid
USD 90,000 - 130,000
Portfolio Analytics & Insights Analyst (Power BI)
Portfolio Analytics & Insights Analyst (Power BI)

U.S. Anesthesia Partners, Inc. • United States

On-site
USD 67,000 - 114,000
Senior Data Analyst — BI, KPIs & Insights
Senior Data Analyst — BI, KPIs & Insights

Realtor • Jackson (TN)

On-site
USD 95,000 - 145,000
Medical coverage
Dental coverage
Vision coverage
+3
Remote Real Estate Data Analyst – Insights Leader
Remote Real Estate Data Analyst – Insights Leader

Placements24 • Queenstown (MD)

Hybrid
NZD 48,000 - 80,000
Competitive salary
Health insurance
Bonuses
+5
Senior Data Analyst: Real Estate Insights & BI
Senior Data Analyst: Real Estate Insights & BI

CBRE, Inc. • San Juan (PR)

On-site
USD 120,000 - 130,000
401(K)
Dental insurance
Health insurance
+2