Sr. Market Planning Analyst (Power BI)

Location: Remote, with the position associated with Chicago, Illinois, USA

Salary: $80,750–$95,000 annually

Company

Cushman & Wakefield provides commercial real estate services and develops analytics capabilities for real estate portfolio management and strategic decision-making.

What you will do

• Analyze portfolio performance across locations, markets, property types, business units, and individual assets, including occupancy, utilization, rent expense, operating costs, and lease commitments.
• Build and enhance interactive Power BI dashboards, reports, drill-through views, variance analyses, trend reports, and executive scorecards.
• Develop financial models, scenario analyses, forecasts, and sensitivity analyses to support lease, portfolio, and strategic real estate decisions.
• Integrate, reconcile, validate, and document data from financial, lease administration, property management, and other source systems.
• Use SQL and the Databricks environment to support scalable, repeatable reporting processes and resolve data-quality issues.
• Automate recurring reporting, establish analytical standards, and explore predictive analytics, advanced forecasting, and AI-enabled capabilities.

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.
• Ability to manage analytical assignments from requirements gathering through development, validation, delivery, and ongoing support.

Nice to have

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

Culture & Benefits

• Collaboration with real estate, finance, operations, and technology stakeholders.
• Health, vision, and dental insurance; flexible spending and health savings accounts.
• Retirement savings, life and disability insurance, and paid and unpaid time away from work.
• Competitive compensation may vary by geographic location, job type, business line, collective bargaining coverage, experience, and qualifications.