Global real estate investment firm is seeking a sharp Senior FP&A Analyst. The Senior Analyst will play a vital role in the Financial Planning & Analysis team by performing various analytical duties associated with operating a large portfolio of properties. The duties revolve around analyzing operational and financial data to support asset managers in improving performance for the benefit of various stakeholders including various departments executive leadership.
Responsibilities:
- Gather, analyze, and interpret financial and operational data to provide critical insights on trends and variances and identify opportunities to improve performance.
- Complete “deep-dive” property assessment reports for at-risk assets not meeting budget and/or operational expectations.
- Prepare monthly, quarterly, and ad hoc financial reports for executive leadership including presenting financial data and analysis clearly and concisely.
- Execute annual budgeting and forecasting process, including coordinating with asset managers, department heads, operators, and other key stakeholders to gather relevant data and assumptions.
- Assist in preparing the quarterly board book: coordinate and work across departments on high profile deliverable presented to Blackstone senior real estate leadership team at the quarterly board meeting.
- Develop and maintain complex corporate-level financial models to provide multi-year visibility into financial performance.
- Work with IT and other stakeholders to automate manual reporting, work on software implementation, and create interactive business intelligence tools and dashboards.
- Utilize third-party data to monitor and analyze market and industry trends. Data sources will include a range of different products (Yardi Matrix, Green Street, Bureau of Labor Statistics, etc.).
- Perform special ad hoc projects on a frequent basis.
Qualifications:
- Bachelor’s degree in business, finance, or accounting.
- 3-5 years’ experience in FP&A and/or financial reporting within a commercial real estate firm.
- Excellence with Excel and PowerPoint: efficient database sourcing, utilization of standard Excel functions (sumif/s, sumproduct, index/match, indirect, pivot tables, data tables, filters, and keyboard shortcuts) to aggregate and summarize data, creation of graphs in proper context of data presented, use of best practices for insuring data integrity, design of executive/board level presentation quality outputs. Experience with Yardi and/or data analytics is a plus.
- Excellent oral and written communication skills since interaction with personnel at all levels will be required.
- A strong work ethic, the strength to thrive in a dynamic and demanding work environment, and an ability to meet critical deadlines.
- Intelligence with a keen focus on details.