Sr. Market Planning Analyst

Cushman & Wakefield•Chicago, IL
•$80,750 - $95,000

About The Position

The Sr. Market Planning Analyst combines commercial real estate and financial analysis with advanced business intelligence and data visualization. The role develops Power BI solutions and works with portfolio data and enterprise data platforms to provide reliable, decision-oriented reporting. The analyst partners with real estate, finance, operations, and technology teams to integrate data from multiple sources, identify trends and performance opportunities, and deliver actionable insights to management. The position is both hands-on and business-oriented, with a focus on improving portfolio performance, supporting strategic decisions, and delivering measurable organizational value. The analyst develops and maintains portfolio dashboards and models, investigates data issues, and helps advance scalable reporting and real estate analytics capabilities, including through the organization's Databricks environment.

Requirements

  • 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.

Nice To Haves

  • 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.

Responsibilities

  • 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 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 quantitative recommendations.
  • Design, develop, maintain, and enhance interactive Power BI dashboards and reports for portfolio management, finance, operations, and executive leadership.
  • Use Power Query and other 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 user experience; improve dashboards based on user feedback.
  • Translate business requirements into practical reporting solutions.
  • Understand data flows through source systems, 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 data organization, catalog, governance, and reporting architecture.
  • Identify data-quality issues, reconcile inconsistencies across source systems, and document business rules and data definitions.
  • Support scalable, repeatable reporting processes that reduce reliance on manual spreadsheets and disconnected tools.
  • 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 communicating financial results, trends, risks, and opportunities.
  • 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 analytical opportunities and develop decision-support solutions.
  • Explore predictive analytics, advanced forecasting, and AI-enabled analytical capabilities where appropriate.

Benefits

  • Eligible employees may enroll in health, vision, and dental insurance programs.
  • Flexible spending accounts and health savings accounts.
  • Retirement savings plans.
  • Life and disability insurance programs.
  • Paid and unpaid time away from work.
  • Competitive pay.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service