Sr. Market Planning Analyst

Cushman & Wakefield

Chicago (IL)

Hybrid

USD 81,000 - 95,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health, vision, and dental insurance
Paid time off and paid holidays
Competitive compensation

Job summary

Cushman & Wakefield is seeking a Sr. Market Planning Analyst who will blend commercial real estate analysis with advanced BI to deliver portfolio insights.

You will design and optimize Power BI solutions, model data, and work with Databricks to enable enterprise reporting for finance, operations and leadership. The role emphasizes hands-on BI development, data governance, and collaboration with cross-functional teams to transform complex datasets into actionable business intelligence that drives

Qualifications

  • Bachelor’s degree and 3–7 years in real estate analysis, financial analysis, BI or data analytics.
  • Hands-on Power BI development experience including DAX, Power Query, data modeling and dashboards.
  • Proficiency in SQL and handling large, complex datasets.
  • Familiarity with Databricks and modern enterprise data platforms.
  • Strong Excel, forecasting and analytical skills.

Responsibilities

  • Analyze portfolio performance across locations, markets and assets.
  • Develop Power BI dashboards and reports for portfolio management and leadership.
  • Write SQL queries to extract and validate portfolio data; support Databricks-based reporting.
  • Create scenario models, forecasts and executive-ready reports.

Skills

Power BI development
SQL
Databricks
Data modeling
DAX

Education

Bachelor’s degree in Real Estate, Finance, Accounting, Business Analytics, Information Systems, or related field

Tools

Power BI
Databricks
SQL
Excel

Job description

Job Title

Sr. Market Planning Analyst

Job Description Summary

This position combines commercial real estate and financial analysis with advanced business intelligence and data visualization capabilities. The successful candidate will have strong expertise in Microsoft Power BI development, including data modeling, DAX, dashboard design, and report optimization, along with familiarity with the Databricks data platform and modern data architecture.
The analyst will work with real estate, finance, operations, and technology teams to integrate data from multiple sources, develop reliable portfolio reporting, identify trends and performance opportunities, and deliver actionable insights to management. This role will help advance the organization's real estate analytics capabilities by transforming complex datasets into consistent, accessible, and decision-oriented information.

Job Description
Position Profile

The successful candidate will be both a hands-on developer and a business-oriented analyst who understands that the ultimate objective of analytics is to improve portfolio performance, support strategic decisions, and deliver measurable value to the organization. This individual should be comfortable working directly with portfolio data, building sophisticated Power BI solutions, investigating data issues, and partnering with technology teams to leverage enterprise data platforms.

Key Responsibilities
Real Estate Portfolio Analysis
  • Analyze portfolio performance across locations, markets, property types, business units, and individual assets.
  • Evaluate occupancy, utilization, rent expense, operating costs, lease commitments, portfolio growth, and other key real estate performance indicators.
  • Develop financial models, scenario analyses, forecasts, and sensitivity analyses to support strategic real estate decisions.
  • Prepare management presentations, portfolio reviews, and recommendations supported by quantitative analysis.
Business Intelligence
  • Design, develop, maintain, and enhance interactive Power BI dashboards and reports for portfolio management, finance, operations, and executive leadership.
  • Apply Power Query and other data transformation techniques to cleanse, integrate, and prepare data for reporting.
  • Develop drill-through reports, interactive visualizations, variance analyses, trend reporting, and executive scorecards.
  • Optimize Power BI data models, report performance, refresh processes, and overall user experience.
  • Translate business requirements into practical reporting solutions and continuously improve dashboards based on user feedback.
Data Integration and Management
  • Understand how data moves through modern data environments, including source systems, data pipelines, transformation layers, and analytical data models.
  • Write and troubleshoot SQL queries to extract, reconcile, validate, and analyze portfolio data.
  • Develop an understanding of the organization's Databricks environment, including its data organization, catalog, governance, and reporting architecture.
  • Assist in identifying data-quality issues, reconciling inconsistencies across source systems, and documenting business rules and data definitions.
  • Support the development of scalable, repeatable reporting processes that reduce reliance on manual spreadsheets and disconnected reporting tools.
Financial Analysis, Forecasting, and Reporting
  • Develop scenario models to assess the financial impact of lease decisions, portfolio changes, market conditions, and strategic initiatives.
  • Reconcile data across financial, lease administration, property management, and other relevant systems.
  • Prepare concise, executive-ready reports that communicate financial results, emerging trends, risks, and opportunities.
Process Improvement and Analytical Innovation
  • Identify opportunities to automate recurring portfolio reporting and reduce manual data manipulation.
  • Establish consistent analytical methodologies, reporting standards, and documentation.
  • Improve the accuracy, timeliness, and usability of portfolio data.
  • Partner with stakeholders to identify new analytical opportunities and develop solutions that support better decision-making.
  • Explore opportunities to incorporate predictive analytics, advanced forecasting, and AI-enabled analytical capabilities where appropriate.
Required Qualifications
  • Bachelor’s degree in real estate, Finance, Accounting, Business Analytics, Information Systems, or a related field.
  • Approximately 3-7 years of relevant experience in real estate analysis, financial analysis, business intelligence, or data analytics.
  • Strong hands-on Power BI development experience, including DAX, Power Query, data modeling, and dashboard design.
  • Proficiency in SQL and experience working with large, complex datasets.
  • Familiarity with Databricks and modern enterprise data platforms.
  • Strong Excel, financial modeling, forecasting, and analytical skills.
  • Ability to translate business requirements into practical analytical solutions and communicate findings to technical and nontechnical audiences.
Preferred Qualifications
  • Experience with commercial real estate portfolios, lease administration, occupancy costs, or corporate real estate strategy.
  • Familiarity with Databricks SQL, Unity Catalog, Delta Lake, or related technologies.
  • Knowledge of Python or PySpark and experience integrating financial, lease, or property management data.
Core Competencies
  • Analytical thinking: Ability to identify patterns, evaluate alternatives, and translate data into business recommendations.
  • Technical proficiency: Ability to independently develop high-quality Power BI solutions and work effectively with enterprise data platforms.
  • Real estate acumen: Understanding of real estate portfolio economics, occupancy costs, lease structures, and portfolio strategy.
  • Business partnership: Ability to collaborate with real estate, finance, operations, and technology stakeholders.
  • Communication: Ability to present complex findings in a clear, concise, and actionable manner.
  • Ownership and execution: Ability to manage analytical assignments from requirements gathering through development, validation, delivery, and ongoing support.
Measures of Success

Success in this role will be measured by the analyst's ability to:

  • Deliver accurate, reliable, and timely portfolio dashboards and management reporting.
  • Reduce manual reporting effort through automation and reusable analytical solutions.
  • Improve visibility into portfolio costs, utilization, lease commitments, and performance trends.
  • Strengthen the consistency and reliability of data used for real estate decision-making.
  • Translate portfolio data into actionable recommendations and measurable business value.
  • Improve the accessibility and adoption of Power BI reporting across the organization.
  • Establish scalable reporting solutions that leverage the organization's Databricks environment.

Cushman & Wakefield also provides eligible employees with an opportunity to enroll in a variety of benefit programs, generally including health, vision, and dental insurance, flexible spending accounts, health savings accounts, retirement savings plans, life, and disability insurance programs, and paid and unpaid time away from work. In addition to a comprehensive benefits package, Cushman and Wakefield provide eligible employees with competitive pay, which may vary depending on eligibility factors such as geographic location, date of hire, total hours worked, job type, business line, and applicability of collective bargaining agreements.

The compensation that will be offered to the successful candidate will depend on factors such as whether the position is covered by a collective bargaining agreement, the geographic area in which the work will be performed, market pay rates in that area, and the candidate’s experience and qualifications.

The company will not pay less than minimum wage for this role.

The compensation for the position is: $ 80,750.00 - $95,000.00

Cushman & Wakefield is an Equal Opportunity employer to all protected groups, including protected veterans and individuals with disabilities. Discrimination of any type will not be tolerated.

In compliance with the Americans with Disabilities Act Amendments Act (ADAAA), if you have a disability and would like to request an accommodation in order to apply for a position at Cushman & Wakefield, please call the ADA line at 1-888-365-5406 or email Accommodations@cushwake.com. Please refer to the job title and job location when you contact us.

INCO: "Cushman & Wakefield"

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr Business Analyst
Sr Business Analyst

Cushman & Wakefield • New York (NY)

On-site
USD 119,000 - 140,000
Health insurance
Vision insurance
Dental insurance
+2
Business Analyst
Business Analyst

Cushman & Wakefield • Weehawken (NJ)

Hybrid
USD 70,000 - 82,000
Health, vision & dental insurance
Retirement savings plans
Finance Analyst
Finance Analyst

Cushman & Wakefield • Chatham (NJ)

On-site
USD 66,000 - 78,000
Account Director
Account Director

Cushman & Wakefield U.S., Inc. • North Carolina

On-site
USD 183,000 - 215,000
Health benefits
Competitive compensation
Director - Global Technology Solutions
Director - Global Technology Solutions

Cushman & Wakefield • California

On-site
USD 174,000 - 204,000
Health, Vision & Dental Insurance
Retirement savings plans
Flexible spending accounts
Data Analytics Engineer
Data Analytics Engineer

Cw • United States

Remote
USD 106,000 - 125,000
Health, vision, and dental insurance
Retirement savings plans
Paid time off
Property Manager
Property Manager

Cushman & Wakefield • Irvine (CA)

On-site
USD 94,000 - 110,000
Sr. Director, Project & Development Services
Sr. Director, Project & Development Services

Cushman & Wakefield • Olympia (WA)

On-site
USD 196,000 - 230,000
Director, Critical Environments - Engineering
Director, Critical Environments - Engineering

Cw • United States

Remote
USD 145,000 - 170,000
Health insurance
Retirement plans
Paid time off
Property Manager (CRE)
Property Manager (CRE)

Cushman & Wakefield • Atlanta (GA)

On-site
USD 85,000 - 100,000