Treasury (35%)
• Contribute to the development and maintenance of cash flow forecasts, incorporating diverse funding sources such as tax revenue, grants, offsite levies, developer contributions, asset sales, and third-party agreements.
• Support the monitoring of reserve balances, investment activity, and long-term debt obligations (e.g., debentures), ensuring data accuracy and alignment with policies and legislative requirements.
• Prepare monthly and year-end bank reconciliations, including multi-account and multi-entity environments, reconciling across multiple third-party applications and financial systems.
• Coordinate with financial institutions to align treasury activities with strategic investment objectives, ensuring accurate and timely execution of transactions in compliance with internal controls and regulatory standards.
• Maintain accurate and timely reconciliation of reserve accounts, investment balances, debenture schedules, and related treasury transactions.
• Apply and help enforce strong internal control procedures over treasury-related activities, including cash handling, investment tracking, and debt administration.
• Support compliance with applicable legislation (e.g., the Municipal Government Act) and internal financial policies.
• Support the preparation and administration of borrowing bylaws, including facilitating the approval process through Council and ensuring compliance with legislation.
• Participate in the design and review of treasury-related controls, workflow improvements, and audit preparedness.
• Provide technical and reconciliation support for system integrations involving banking platforms, ERP systems, and third-party software (e.g., POS, grant systems, developer contributions).
• Respond to inquiries and provide assistance to internal departments and external stakeholders regarding treasury processes and reconciliations.
Operating and Capital Budgeting (20%)
• Support the annual operating and capital budget development process by coordinating timelines, facilitating data collection, and ensuring quality and consistency across department submissions.
• Collaborate with over 20 departments to review, analyze, and refine budget inputs, and help ensure alignment with financial policies and long-range plans.
• Support the development of the operating and capital budgets by identifying and applying appropriate funding sources in alignment with short- and long-term financial plans.
• Prepare clear and accessible budget documentation, including Council packages, presentations, charts, and summaries for internal and public use.
• Help facilitate the Council budget request process, ensuring operational and capital requests are documented and processed through appropriate systems and channels.
• Contribute to the development and refinement of budget policies, processes, and system functionality, including identifying opportunities for enhancement or clarification.
• Support the Capital Committee through data preparation, presentation materials, and budget system coordination.
• Assist with project financial planning, including developing projections, monitoring funding allocations, and tracking key milestones.
Financial Reporting & Analysis (25%)
• Prepare variance analysis, historical trend reviews, and financial summaries to support decision-making by Finance leadership and departments.
• Conduct benchmarking and comparability studies using data from peer municipalities and other relevant sources.
• Develop and maintain financial models, dashboards, working papers, and visual reporting tools to support operational and strategic decision making.
• Provide input into multi-year financial planning processes, including assumptions, modeling, and scenario testing.
• Research and interpret financial legislation, trends, and practices to help inform internal recommendations and reporting.
• Collaborate with colleagues to improve the quality, clarity, and usefulness of financial reporting packages for both internal and external audiences.
• Support the annual audit by preparing thorough and well-documented audit work papers related to treasury transactions and controls.
Other Related Duties (20%)
• Maintains various financial controls, processes, procedures, policies, directives, and bylaws.
• Assists with financial reporting and audits as required.
• Assists with achieving corporate initiatives, department goals, and special projects as required.
• Performs and reviews complex financial calculations, analytical procedures, and reconciliations, and provide evidence-based recommendations if necessary and applicable.
• Works closely with Corporate Finance and Treasury management and financial operations and reporting team to ensure cohesion exists between program responsibilities and organizational understanding.
• Adheres to applicable responsibilities and accountabilities as outlined in the Sturgeon County Health and Safety Management System.
