Manager, Financial Planning and Analysis

Starlight Investments; Ontario; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company in real estate finance is seeking a Manager for Financial Planning and Analysis. The role focuses on enhancing financial modeling, overseeing budgeting processes, and collaborating with various departments to drive informed decision-making. The ideal candidate will have a strong background in finance, experience with analytical tools like Power BI, and excellent communication skills. This position offers the opportunity to contribute significantly to the company's financial strategy and operational efficiency.

Qualifications

• 5 years of finance or relevant consulting experience.
• Expert in Excel financial modeling and analytical models.

Responsibilities

• Assist in the annual budgeting process for US and Commercial business lines.
• Work with portfolio finance teams to analyze financial results and risks.
• Develop Power BI reports and improve organizational data flow.

Skills

Excel

Analytical Modeling

Financial Analysis

Education

Bachelor’s degree in Finance

MBA

Tools

Power BI

Yardi

Anaplan

Job description

The Manager, Financial Planning and Analysis will play a critical part in driving the financial planning and analysis function within the organization including the further development of the analytical tools used to provide context to our financial results. The primary goal of the role is to assist with providing timely, accurate, complete and contextual financial and non-financial data to allow our investments, asset management, finance and other departments to make more informed, timely decisions. This role involves assistance with the oversight of the budgeting / forecasting process, financial modeling and providing strategic insights to support decision-making primarily for the US and Commercial business lines. The role will also assist with the standardization of FP&A and other finance processes across all business lines, including the use of Power BI and other transformation projects. The successful candidate will have a detailed knowledge of real estate finance and will work closely with senior management and various departments to ensure financial goals are met and to drive business performance. The role also requires extensive collaboration with finance team members from across the organization and will act as a key liaison for asset management, investments and other departments to help drive better informed decisions.

This role will also assist the Senior Manager FP&A and Finance Transformation Committee, consisting of senior team members across the Starlight finance team, to automate and improve various operational and finance related processes to allow the business to derive more insightful, timely and accurate information to make more informed business and operating decisions. This part of the role is project-based and requires standalone and collaborative work effort in order to accomplish these goals.

Duties and Responsibilities

Business Planning, Budgeting and Financial Analysis

• Assist the Senior Manager, FP&A to oversee the annual budgeting process for the US and Commercial business lines including planning, development and approval of annual business plans and budgets for all properties, including consolidation of financial results by investment vehicle, by partnering with asset management, financial reporting team, investments team and property management teams in a collaborative manner.
• Assist in production of high-quality, insightful quarterly partner presentation materials, where applicable.
• Partner with asset management to ensure underlying financial models capture the business KPIs and data-flow for all stakeholders is efficiently managed.
• Assist with the implementation of potential budgeting software to help automate budgeting and forecast processes.

Operational & Performance Review

• Work with portfolio finance teams and property accounting team (“CORE”) to analyze financial results of properties, risks and opportunities and work with various stakeholders including asset management and property managers, where applicable, to ensure an effective plan is put into place to action such recommendations and subsequently track the rollout of such initiatives.
• Identify areas where to improve financial performance within business and work closely with Asset Management and Sr. Manager FP&A to develop action plan around it.
• Capture, track and report operational and financial KPIs.
• Assist in building analytical tools and reporting to measure business results, key success metrics and efficiency, leveraging existing infrastructure as appropriate and create new capabilities as required.
• Work with core finance to summarize key trending in financial results of properties and highlight trends comparatively to relevant benchmarks for consumption by business.
• Stakeholder management and business partnering with core financial reporting team, asset management and investment team.
• Ad-hoc reporting and analysis, as required.

Change Management & Transformation

• Assist with the visioning and implementation of systems or processes identified by a key priority by the Finance Transformation Committee.
• Assist with the development of Power BI reports and ensuring an efficient workflow of Power BI.
• Work with Sr. Manager, FP&A to identify areas where organizational data flow could be improved and work with IT, asset management, finance and investments to implement process improvements to address areas of opportunity.
• Understand stakeholder perspectives, needs and wants in order to sift out the information required to garner buy-in and implement change successfully.
• Work with Sr. Manager, FP&A and other stakeholders to identify financial and operational systems that will elevate and differentiate the performance of our business.
• Work with Sr. Manager, FP&A and other business leads to obtain necessary approvals to implement recommendations.

Requirements

• Expert Excel financial modeling skills and relevant experience that demonstrates ability to work with detailed financial models and diligent, auditable financial models.
• Experience in building analytical models via Power BI is a strong asset.
• Bachelor’s degree in Finance, Mathematics or Business Administration (MBA an asset).
• CPA / CFA, or experience that demonstrates sound understanding of finance / accounting.
• 5 years in Finance or relevant consulting experience demonstrating similar skills.
• Must have experience working with ERP systems (preferably Yardi) or complex data models.
• Previous working knowledge of Budgeting software such as Anaplan (nice to have).
• Experience with presentations to communicate and convey insights to a diverse group of company stakeholders, e.g., building infographics, PowerPoint decks and other related business presentation formats / files / documents.