Senior Analyst, Financial Planning & Analysis

Alterna Savings; Ottawa; On-site; CAD 70,000 - 90,000; Full time

Job summary

A financial institution in Ottawa is seeking a Financial Planning & Analysis professional to manage budgets and forecasts. The ideal candidate will have at least 5 years of experience in financial reporting, strong financial modeling skills, and proficiency in tools like Power BI and True Sky. This role offers competitive compensation and opportunities for continuous learning.

Qualifications

• 5+ years of experience in financial reporting, FP&A, corporate finance or management reporting.
• Financial designation required, preference for CPA.

Responsibilities

• Project manage the AOP and quarterly reforecasts.
• Publish self-serve reports in True Sky for budget holders.
• Optimize the use of True Sky, SEI, and Power BI.
• Collaborate with Financial Reporting for cost control.
• Provide training on budgeting and reporting tools.

Skills

Financial modeling

Data analysis

Proficiency in Excel

Continuous learning

Experience with BI platforms

Understanding of banking operations

Education

CPA designation or other relevant credentials (MBA, CFA)

Tools

True Sky

Sage Enterprise Intelligence

Power BI

Job description

Key Responsibilities

Planning & Forecasting

• Project manage all aspects of the AOP and three quarterly reforecasts.
• Coordinate with budget holders across business units to ensure inputs into True Sky, Alterna’s budgeting tool are complete and accurate.
• Reconcile and analyze product growth plans from Sales Reporting and the related net interest margin (NIM) forecasts from Treasury; manage the final input of growth and NIM into True Sky.
• Create pro-forma financial statements using Sage Enterprise Intelligence (SEI), maintain version control and ensure data integrity throughout the planning & forecasting cycles.
• Administer planning tools, including template design, user profiles, access controls and cost center hierarchies.
• Providing detailed analysis to drive key performance indicators used by Management.

Reporting & Analysis

• Publish self-serve reports in True Sky for budget holders.
• Develop and automate budget-to-actual reports and dashboards using SEI and Power Bi for senior leadership.
• Deliver insightful variance analysis and commentary to budget holders, executive leadership and the Financial Reporting team.
• Conduct peer benchmarking to support profitability and strategic planning.
• Develop a financial reporting dashboard of KPIs using analytic tools on a monthly basis for executive leadership.
• Support ad-hoc projects focused on financial planning, performance optimization and peer review.

Technology & Innovation

• Optimize the use of current tools (True Sky, SEI, Power BI) and leverage new technologies, including AI-driven analytics and digital reporting platforms.
• Design and enhance reporting templates and workflows to improve efficiency and data visualization.
• Providing training and support to True Sky users whenever required. internal stakeholders on self-serve budgeting and reporting tools.

Cross-Functional Collaboration

• Collaborate with Financial Reporting to support accruals and variance analysis for accurate financial reporting and cost control.
• Partner with budget holders to enhance reporting that drives accountability and results.
• Align with Sales Reporting on product growth assumptions and with Treasury on NIM forecasts for integrated planning.
• Liaise with software consultants to ensure a seamless user experience with Alterna’s planning tools.

Qualifications

• Financial Designation is required with a preference for a CPA designation or; other relevant credentials (MBA, CFA)
• 5+ years of experience in financial reporting, FP&A, corporate finance or management reporting.

Knowledge / Skills

• Strong financial modeling and data analysis skills.
• Proficiency in Excel and openness to learning tools such as True Sky and SEI.
• Strong desire for continuous learning and skills development.
• Experience with BI platforms (i.e. Power BI), True Sky or Sage Enterprise Intelligence would be an asset; and
• A strong understanding of banking operations.