- Provide financial analysis and strategic recommendations for the City of Brampton's annual budget development, ($913M annual operating budget and $545M annual capital budget).Prepare short, mid-term and long-term analysis on capital funding sources, in order to recommend annual capital envelopes, includes identifying risks and opportunities. Support the development of annual budget guidelines by conducting analysis and researching best practices, with a focus on continuous improvement. Review and consolidate operating and capital budget submissions from all departments to ensure accuracy and adherence to budget guidelines, legislation, corporate policies and procedures, by-laws and best practices. Prepare budget submission materials in a format conducive for Corporate Leadership Team review, consisting of over 900 cost centres and 15,000 budget lines as well as over 2,000 forecasted capital projectsPrepare budget related materials for Council Workshops, Council Budget Deliberations and Final Budget Approval. Prepare, review and consolidate commentary and financial information for inclusion in the City's Business Plan and Budget binder.Coordinate, communicate, educate, advise and train departmental Business Services Offices and Financial Planning Analysts in all City Departments on budget development processes, timelines and requirementsPrepare financial templates and complex financial models for Operating and Capital budgetsAttend Council Budget Deliberations, track changes from decision points and update Property Tax models in real time, in order to provide Council with timely understanding of the tax impact of decisions.Prepare, as requested by Corporate Leadership Team or Council, comparative analyses of Brampton versus other Municipalities/Regions, using FIR data, other municipal/regional budget reports, and provide in a manner that is easily understood (tables, graphs, Maintain relationships with other municipalities'/regions' Finance and Budget staff to facilitate inquiries of results identified from comparative analyses of Brampton with other Municipalities/Regions, enabling clear and accurate explanations for those resultsUpdate all budget materials to reflect the final approved budget, including the City's annual budget binder.Implement approved budget by loading all Capital Projects and account level budgets in the City's financial system (PeopleSoft), ensuring 100% accuracy of all budgets and funding sources.
- Establish budget appropriations limits in PeopleSoft to ensure expenditures cannot exceed approved budgets. Investigate and analyse budget appropriation failures, obtain variance explanations and approvals from department heads and process appropriation increases with 100% accuracy. Prepare financial analysis of the City's fiscal position for the Quarterly Operating and Reserve status reports to Council, including identifying risks and opportunities. Implement budget transfers resulting from re-organizations, new cost centres and accounts and cost centre transfers. Review financial implications of all Council and Procurement reports to ensure proposed initiatives have been approved by Council, sufficient funds exist and appropriate funding sources are used. Analyse Budget Amendment requests to ensure all funding options are identified, appropriate funding sources are used and communicate impact on associated reserves.Coordinate, communicate, educate, advise and train departmental Business Services Offices and Financial Planning Analysts in all City departments on budget administration processes and requirements.
- Lead functional user for budget systems including liaising with corporate IT, managing and implementing system changes, upgrades and customizations to optimize business processesPrepare policies and procedures to ensure that data management in Questica is accurate, consistent and adheres to budget guidelines.Communicate, train, educate and advise departmental Business Services offices on system procedures and requirements, to ensure Questica is used consistently and appropriately.Administer Questica system procedures, such as annual fiscal rollovers, quarterly forecasting processes and importing/exporting data to/from PeopleSoft.Administer security in Questica, such as locking/unlocking user access.Ensure budget transfers are processed accurately in Questica Ensure re-organizations are reflected timely and accurately in QuesticaAdminister Questica system back-ups to ensure annual forecast data is available and maintained.
- Provide Financial Modelling, Analysis and Advice Prepare complex financial modelling, analysis, templates and reporting to support CLT and management decisions.Formulate strategic financial recommendations and provide constructive insight on financial-related mattersProvide financial modelling and support during collective bargaining processesAct as an influential mediator to resolve inter-Departmental financial issues.Provide guidance to Business Services Managers and Financial Planning Analysts in all City Departments on various financial-related mattersAct as a subject matter expert to handle and resolve analytical complex issues, prioritize requests to meet corporate service standards. Escalate complex issues to appropriate level.Build and maintain a relationship with internal and external stakeholders, departments and team members to achieve common goals and objectives.
- Present and convey complex concepts and conditions to stakeholders; develop reports, proposals and make recommendations to management for effective decision-making.Keep management informed of activities and initiatives; recommend solutions for effective decision-making.
- Conduct Research and DevelopmentFocus on continuous improvement by constantly evaluating processes, reporting, procedures, systems, resources and capacity. Conduct research and prepare ad hoc studies of, for example, external economic impacts, policy review, and comparative benchmarking of other municipalities and make recommendations for improved risk managementParticipate in Corporate budget teams as required, in order to investigate, research and develop new initiatives, such as alternative budget systems.Prepare and present recommendations to management.
- Use of effective resource and expense management at all times to meet corporate policies and guidelines.
- Lead and participate on project initiatives as a subject matter expert. Work well within diverse groups to achieve common goals and objectives that meet operational effectiveness and corporate service standards.Demonstrate corporate values at all times.Participate as a member of cross-functional team.
- University degree in Commerce, Economics, Finance, Accounting or Business Administration, or similar related program Professional designation (. CPA, CA, CGA, CMA, CFA)
- Minimum 3-5 years of progressive experience in a Finance related fieldExperience with municipal finance, budgeting and infrastructure funding considered an asset
- Knowledge of relevant municipal legislation considered an asset (. Development Charges Act, Municipal Act, Demonstrated analytical and conceptual thinking with strong reasoning and problem solving abilitiesAdvanced computer skills in MS Office including extensive knowledge of spreadsheet and database applications and PeopleSoft FinancialsExcellent interpersonal, customer service, and public relations skillsAbility to communicate (oral and written) at a high level of proficiencyAble to work independently and as part of a team Excellent performance and work recordStrong Organizational skills; Detail oriented, well organized and able to prioritize complex tasks and meet critical deadlines
Financial Planning Advisor - Brampton, Canada - Brampton
Description
Job Description
JOB TITLE: Advisor, Financial Planning
DEPARTMENT: Corporate Support Services
POSTING NUMBER: 105882
NUMBER OF POSITIONS: 3
JOB STATUS & DURATION: 1 Full Time Permanent
HOURS OF WORK: 35 hour workweek
LOCATION: Hybrid Model*– when working onsite, you will report to the location of City Hall.
SALARY GRADE: 6
HIRING SALARY RANGE: $ 97, $ 109,792.00 per annum
MAXIMUM OF SALARY RANGE: $ 121,991.00 per annum
JOB TYPE: Management and Administration
POSTING DATE: April 12, 2024
CLOSING DATE: April 26, 2024
AREA OF RESPONSIBILITY:
Reports to the Manager, Financial Planning, the primary purpose of this position is to provide financial analysis and strategic recommendations through the development, presentation, approval and implementation of the City's annual Budget. This includes preparing and reviewing budget submissions, Council reports and procurement reports, while ensuring that all legislative and Corporate standards are met and adequate financial controls are in place.
KEY RESPONSIBILITIES
OPERATION SUPPORT
Develop the Annual Corporate Budget
Administer the Annual Corporate Budget
Administer the Corporate Budget System (Questica)
CUSTOMER SERVICE
COMMUNICATION AND REPORTING
CORPORATE CONTRIBUTION
BUDGET SUPPORT
TEAMWORK AND COOPERATION
SELECTION CRITERIA:
EDUCATION:
REQUIRED EXPERIENCE:
OTHER SKILLS AND ASSETS:
**Various tests and/or exams may be administered as part of the selection criteria.
Interview: Our recruitment process may be completed with video conference technology.