Job description

Position Summary Public Storage is seeking a Senior Financial Analyst to support planning, forecasting, and asset management analytics across the Company's non-same-store, joint venture, commercial, and third-party managed portfolios. Working under the direction of the Senior Manager, Real Estate Finance, this role provides the modeling, reporting, and analytical support behind the Company's budget and forecast cycles, quarterly guidance process, and joint venture partner reporting. Workday Adaptive Planning is the primary tool for this work, and the analyst will be a daily hands-on user of it — forecasting, maintaining models and reports, and handling routine upkeep. Beyond the numbers, this role partners closely with the operating and asset management teams to interpret property performance, identify where results are diverging from plan, and work with those teams to drive performance and results. This is a high-visibility position: the work product reaches senior leadership and institutional joint venture partners, and the role interfaces regularly with the Acquisitions, Development, Construction, Lending, and Third-Party Management teams. The ideal candidate combines strong technical modeling skills with the judgment to explain why results are moving, not just what they are. Key Responsibilities Workday Adaptive Planning & Reporting • Serve as a power user of Workday Adaptive Planning (“WDAP”), using the system to load, build, and iterate on property- and portfolio-level forecasts through each planning cycle. • Maintain existing planning models and reports — updating drivers and assumptions, adding new properties and entities, refreshing hierarchies and mappings, and keeping structures updated. • Build and maintain reporting packages driven by WDAP, and reconcile system output against actuals and source data. • Handle basic administrative tasks in support of the cycle — version setup, sheet and template updates, user access requests, and data refreshes — coordinating with IT or the system owner on anything structural. • Build and maintain Power BI dashboards and standardized reporting packages that distribute planning and actuals data to finance, operations, and executive audiences. Budgeting & Forecasting Prepare and maintain property- and portfolio-level budgets and forecasts for: • Stabilizing Properties — forecast revenue, expense, and NOI for newly acquired and development properties, including timing of lease-up, expense ramp up, and stabilization. • Joint Ventures — entity-level forecasting, capital calls, capex reserve spend and spillover, distribution waterfalls, and promote calculations. • Commercial — office, industrial, and retail assets, including lease-level revenue modeling, renewals, downtime, and expense recoveries. • Managed Properties — third-party management fee revenue, platform economics, and property level modelling Consolidate inputs from business teams, test assumptions for reasonableness, and flag issues to the Senior Manager for resolution. Quarterly Guidance Support • Prepare the analysis, build-up, and supporting schedules that feed the Company's quarterly earnings guidance. • Build bridges from prior view to current view, isolating the drivers of change (rental rate, occupancy, expense timing, acquisition and development timing, capital activity). • Run sensitivity and scenario analysis to help frame ranges and downside cases for review by senior leadership. Asset Management Analysis • Analyze property and portfolio performance against forecast, budget, and original underwriting proforma; quantify and explain variances. • Track acquisition and development assets against underwritten NOI, stabilization timing, and yield-on-cost. • Participate in recurring meetings with operations, revenue management, and business team counterparts to review results, surface underperformance, and support follow-up actions. • Summarize analysis into clear findings and recommendations that inform rental rates, capital allocation, and hold/sell discussions. Real Estate Valuation • Maintain and update property- and portfolio-level valuation models, including DCF and direct capitalization approaches. • Compile market-level cap rate and discount rate support using comparable transactions, broker surveys, and public market data. • Support valuation deliverables to support the accounting and other business teams Finance Partnership • Provide analytical support to the Acquisitions, Development, Construction, Lending, and Third-Party Management teams. • Assist with acquisition underwriting and development proforma review; reconcile deal-model assumptions to the operating plan post-close. • Track development pipeline spend, delivery timing, and capitalized interest against budget. • Prepare supporting analysis for lending and structured investment activity. Management & Investor Reporting • Prepare recurring and ad hoc reporting packages for senior leadership, including monthly and quarterly performance reviews and inputs to board-level materials. • Produce joint venture partner reporting deliverables — operating results, budget-to-actual variance narratives, capital activity, distribution schedules, and valuation updates — for review prior to distribution. • Research and draft responses to partner and lender information requests, and support annual budget approval processes with JV partners. • Present findings clearly and concisely to audiences ranging from property operations to the executive team. Qualifications Required • Bachelor's degree in Finance, Accounting, Real Estate, Economics, or a related quantitative field. • 5-8 years of experience in real estate FP&A, or corporate finance. • Advanced Excel modeling skills (complex lookups, dynamic arrays, multi-sheet consolidation, scenario toggles); ability to build models others can audit and use. • Working knowledge of real estate finance fundamentals: NOI, cap rates, IRR, yield-on-cost, DCF, waterfalls, and lease economics. • Strong written and verbal communication; able to distill a complex model into a three-sentence explanation for an executive audience. • Attention to detail, comfort managing multiple deadlines across concurrent planning cycles, and a habit of checking work before it goes out. • Ability to work independently on defined workstreams, anticipate what reviewers and business partners will ask, and escalate the right issues at the right time. Preferred • Hands-on experience building forecasts and reports in WDAP (or a comparable EPM platform such as Anaplan, Hyperion, or Planful) as a finance user. Formal system administration experience is not required. • Power BI, SQL, or Python experience for data extraction, validation, and reporting automation. • Public company or REIT experience, particularly exposure to earnings guidance, same-store pool methodology, or supplemental disclosure. • Exposure to joint venture reporting and operating agreement mechanics. • Commercial real estate experience across any property type (multifamily, industrial, office, retail, self-storage, or similar). • CFA or CPA progress a plus. REF4434R Workplace • One of our values pillars is to work as OneTeam and we believe that there is no replacement for in-person collaboration but understand the value of some flexibility. Public Storage teammates are expected to work in the office five days each week with the option to take up to three flexible remote days per month. Public Storage is an equal opportunity employer and embraces diversity. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or any other protected status. All qualified candidates are encouraged to apply. **Sponsorship for Work Authorization is not available for this posting. Candidates must be authorized to work in the U.S. without restrictions or requiring sponsorship now or in the future. We do not provide training plans or support for F-1 OPT, STEM OPT extensions, or future visa sponsorship.**

Requirements

Must-haves

Workday Adaptive Planning & Reporting
Serve as a power user of Workday Adaptive Planning (“WDAP”), using the system to load, build, and iterate on property- and portfolio-level forecasts through each planning cycle.
Maintain existing planning models and reports — updating drivers and assumptions, adding new properties and entities, refreshing hierarchies and mappings, and keeping structures updated.
Build and maintain reporting packages driven by WDAP, and reconcile system output against actuals and source data.
Handle basic administrative tasks in support of the cycle — version setup, sheet and template updates, user access requests, and data refreshes — coordinating with IT or the system owner on anything structural.
Build and maintain Power BI dashboards and standardized reporting packages that distribute planning and actuals data to finance, operations, and executive audiences.
Budgeting & Forecasting
Prepare and maintain property- and portfolio-level budgets and forecasts for:
Stabilizing Properties — forecast revenue, expense, and NOI for newly acquired and development properties, including timing of lease-up, expense ramp up, and stabilization.
Joint Ventures — entity-level forecasting, capital calls, capex reserve spend and spillover, distribution waterfalls, and promote calculations.
Commercial — office, industrial, and retail assets, including lease-level revenue modeling, renewals, downtime, and expense recoveries.
Managed Properties — third-party management fee revenue, platform economics, and property level modelling
Consolidate inputs from business teams, test assumptions for reasonableness, and flag issues to the Senior Manager for resolution.
Quarterly Guidance Support
Prepare the analysis, build-up, and supporting schedules that feed the Company's quarterly earnings guidance.
Build bridges from prior view to current view, isolating the drivers of change (rental rate, occupancy, expense timing, acquisition and development timing, capital activity).
Run sensitivity and scenario analysis to help frame ranges and downside cases for review by senior leadership.
Asset Management Analysis
Analyze property and portfolio performance against forecast, budget, and original underwriting proforma; quantify and explain variances.

Nice-to-haves

Power BI, SQL, or Python experience for data extraction, validation, and reporting automation.
Public company or REIT experience, particularly exposure to earnings guidance, same-store pool methodology, or supplemental disclosure.
Exposure to joint venture reporting and operating agreement mechanics.
Commercial real estate experience across any property type (multifamily, industrial, office, retail, self-storage, or similar).
CFA or CPA progress a plus.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpython

Platform: smartrecruiters
Effort: medium