Reporting to the Manager, Budgeting and Reporting, the Budgeting and Reporting Analyst provides dedicated financial analytics to support HOOPP internally through, budgeting and forecasting reporting, and analysis of key data-points, including spend variances. As a single point of contact for all financial matters relating to the divisions/projects under their responsibility, the Budgeting and Reporting Analyst is responsible for providing divisional managers with clear, concise, customized and meaningful financial data and analysis, to support effective business decision-making. This position's focus is on providing accurate reliable data in the most efficient way possible. This position will be responsible for balancing the necessities of financial governance and controls while meeting the needs of the business stakeholders they support. They will be required to provide financial oversight into expenditure reporting as well as highlight underlying key financial messages to their clients and finance management.
What you will do:
Facilitate the budgeting and forecasting process with HOOPP's divisions/projects by performing duties such as:
Meeting and communicating with key contacts to understand their critical business needs and ensuring that the operating plan includes the appropriate costs
Providing accurate information to stakeholders to support spending projections, including identification of changes from the original budget and prior forecasts
Understanding the business need for each item included in budgets/forecasts
Developing and effectively leveraging subject matter expertise to scrutinize budget assumptions submitted by cost centre managers.
Data cleansing and reconciling before integrating into the Financial Reporting system prior to Forecasting and Budget cycles.
Ensuring that all budget/forecast data is accurate and that all costs are included.
Working with other Analysts to ensure there is no duplication of costs and that gaps do not exist
Document budget/forecast details and provide the results to the divisional SVP for approval.
Act as the subject matter expert for the areas of the organization they support. Involves understanding cost drivers and translating the impact of business activities on financial performance to management, for the purpose of reporting to senior management and the Board of Trustees.
Ability to think "out of the box" to present management reporting in creative ways, using graphs and other visual aids, dashboards, business intelligence software, etc., always keeping the audience and key financial messages in mind.
Perform month-end activities such as ensuring costs are captured in the appropriate cost centre or project, preparing monthly variance explanations on behalf of divisions and reviewing explanations with management as required.
Work with business stakeholders to determine financial reporting needs. Collaborate with the Manager of Budgeting & Reporting and the Business Solutions Manager to leverage technology to meet these needs.
Prepare & present ad-hoc analyses to management (including SVPs) as requested related to actuals, budgets and forecasts weighing the benefits of ad-hoc requests against the work effort required. Where necessary, provide alternate approaches to analysis without compromising quality.
Generate operational expense reports and provide stakeholders (both to management and divisional managers) with financial reporting according to their needs. Cost descriptions, level of detail and presentation are adjusted according to the end user's unique needs with a strong focus on visual aesthetics and presentation.
Continually review processes and recommend improvements.
What you bring:
University degree in a discipline such as Business, Accounting or related discipline
Professional accounting designation or MBA is an asset
At least 2 years of accounting experience. Planning experience (budgeting/forecasting) is an asset
High level of proficiency using Microsoft Excel, to analyze and present complex data in easily understandable and actionable formats
Experience with business intelligence software (Microsoft Power BI) is considered a strong asset.
An analytical and methodical mind-set with strong attention to detail is required.
Prior experience with reporting data and data management, and exposure to budgeting systems such as Oracle Hyperion Essbase is a strong asset
Strong mathematical skills and problem solving ability & a high degree of comfort with navigating and resolving ambiguous issues
Strong interpersonal and communication skills, combined with a passion for delivering exceptional customer service experience to both internal team members and business clients
Proven ability to multi-task in a fast paced environment
Proven ability to perform effectively in a team-oriented environment, under pressure and with time sensitive deadlines.
Ability (and desire) to work in a high-performance culture, with an openness to constantly evolving and changing priorities, and new challenges.