Sr. Market Planning Analyst
-
IT/Tech
Job Description & How to Apply Below
Sr. Market Planning Analyst
Job Description SummaryThis 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.
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 ResponsibilitiesAnalyze 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.
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.
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.
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.
Iden…
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction