Senior Financial Analyst – Real EstateLocation: Chicago, IL (hybrid WFH, 3 days onsite in the loop, 2 days WFH)
Summary:As a Senior Financial Analyst, you'll be joining a team of financial professionals responsible for real estate investment opportunity analysis, underwriting, monthly/quarterly investment performance reporting, asset management performance analysis, budgeting, reforecasting, etc.
You'll be responsible for preparing, analyzing and presenting reports around this type of real estate analysis.
If you are passionate about real estate (experience not required), unlocking value through financial analysis and enjoy interacting with executive stakeholders to present your findings, come join us today!
What you'll be doing:- Aggregating and analyzing monthly real estate performance analysis through reporting: Includes extracting and aggregating portfolio data; preparing summary spreadsheets, graphs and tables; evaluating performance metrics; highlighting notable issues and trends; and developing meaningful and insightful commentary.
- Preparation and review of quarterly Board materials: work with the team on high-profile deliverables presented to Blackstone senior real estate leadership team at the quarterly board meeting.
- Underwrite real estate opportunities in collaboration with the managers.
- Participate in the annual budget and reforecast processes: develop unit renovation and common area budgets; utilize budgeting templates and tools to develop initial budget; work interactively with various real estate teams to finalize the budget; prepare summary reports and communicate to executive leadership team.
- Assist the real estate teams in developing short, medium, and long-term strategies for each property.
- Administer training to operating partners on the use of renovation systems and processes.
- Create and maintain financial and operational dashboards to better assist the asset management, pricing, and marketing teams.
- Vigilantly and proactively participate in continual process improvement initiatives.
- Develop processes that save time while maintaining the highest quality standards, design data-rich and aesthetically pleasing outputs, leverage internal and external resources to efficiently achieve goals.
- Prepare ad-hoc analyses for upper-level management.
Skills we're seeking:- Bachelor's Degree, preferably in a finance, accounting or real estate focused field.
- 1+ year of experience with financial analysis experience.
- Experience preparing financial reports, and providing recommendations based on your analysis.
- Experience interacting with and presenting findings to executive stakeholders.
- Must have strong Excel skills.
- Must have at least decent PowerPoint skills to assemble presentations of your financial analysis.
Nice to have experience:- Experience with Power BI (what we mainly use) or other reporting/dashboard development tools such as Tableau.
- SQL experience.
- Real estate experience.
#J-18808-Ljbffr
