Sr. Market Planning Analyst

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

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

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

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

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

5. 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. INCO: “Cushman & Wakefield”