Senior Financial Analyst - FP&A

Hillpointe • Winter Park, Florida, United States • Full-time

$80,000

per year

FP&A Budgeting Financial Analyst Forecasting Real Estate Finance

Job Description

Hillpointe is a fully integrated real estate development and investment management firm focused on developing market-rate workforce housing across the Sun Belt. Ranked at the top of NMHC's Builders and Development companies, our team ensures best-in-class execution. This position is more than just a job - it's a career-defining opportunity! At Hillpointe, you'll be part of a dynamic, innovative team that makes tangible impacts on day-to-day operations and contributes directly to overall success.

Senior Financial Analyst - FP&A

Position Description:

Hillpointe is seeking a dynamic and self-driven Senior Financial Analyst to support the Financial Planning & Analysis (FP&A) team. Reporting to the Manager, FP&A, the Senior Financial Analyst will support budgeting, cash flow forecasting, monthly financial analysis and monthly & quarterly reporting processes. The right candidate will be extremely detail-oriented, a self-starter and will comfortably shift between FP&A duties and reporting tasks, supporting both functions as the business requires.

Essential Duties and Responsibilities

Monthly financial review & report preparation for a portfolio of properties. Ensure all entries have been completed and prepare commentary for executive reporting.
Support both the ongoing stub budget preparation as well as the annual budget reporting process. Responsible for initial data load and draft preparation, working cross-functionally to gather inputs and ensure timely submission of budget drivers.
Maintain actuals, budgets and forecasts in our FP&A Software (Prophix). Monitor Prophix workflows for budgeting and forecasting, follow up with operational, capital markets or risk teams as needed. Build out additional reporting as requested by other departments.
Support property and fund cash flow forecasting, ensuring actuals have loaded properly into our FP&A software (Prophix) and relevant business updates have been gathered from our construction, capital markets and operational teams for incorporation.
Support preparation of our monthly internal and quarterly external reporting packages, consolidating and validating both operational and financial metrics.
Review of loan documentation, consolidating terms and loading into Prophix.
Support of lender and investor requests as needed, building reporting for Capital Markets and Debt teams to increase efficiency and standardization in response.
Data compilation & analysis for capex tracking of existing portfolio, analyze financials for trends and preparing reporting to influence strategy and capex budgeting.
Supporting Capital Markets team to provide necessary data and create ad hoc charting utilized in Hillpointe’s quarterly investor letters.

Qualifications:

Education and Experience

Bachelor’s degree in Finance, Mathematics, Economics or a related field
Master’s degree preferred, and contributes toward required experience
Minimum 4-5 years of experience in Finance, Asset Management, Private Equity, Investment Banking or a related field
Experience in multifamily is highly preferred
CFA designation or progress towards a CFA is a plus
Understanding of GAAP accounting principles, and ability to interpret and review complex journal entries & financial statements
Experience building forecasts using driver-based methodologies
Track record of assembling in-depth investor reporting packages with a high level of accuracy and attention to detail
Experience reviewing CRE loan documentation and modeling debt structures
Demonstrated experience working cross-functionally to bridge operational and financial data, consolidating into actionable insights for executives
Experience querying data from a data warehouse, utilizing SQL
Proficiency in Python or other object-oriented/scripting languages is a plus
Experience using an FP&A software (Prophix, Adaptive Planning, Vena, etc.) is a plus

Skills and Competencies

Extremely detail-oriented, with a strong focus on accuracy and reliability in our financial & operational data
A self-starter who will drive assignments to completion, managing time effectively
A strong grasp of mathematics, and the ability to spot inconsistencies and gaps in financial data
A team-player, who can work closely with our Operations, Capital Markets and Debt teams to interpret actuals as well as forecast effectively
Open to new ideas and approaches, with a strong drive to learn and optimize existing workflows
Advanced Microsoft Excel & PowerPoint skills required
Knowledge of SQL required
Experience with Macabacus a plus

NOTE: This document outlines the general nature and level of work expected from individuals in this role. It's important to understand that this is not an exhaustive list of responsibilities, duties, and skills. Additional tasks or job functions that can be safely performed may be required as necessary by supervisory personnel. This flexibility in additional duties showcases the company's adaptability and encourages employees to be versatile. The employee is expected to adhere to all work rules, procedures, and policies established by the company, including, but not limited to, those contained in the employee handbook.