Financial Analyst 2 - Financial Planning

Summary

This position is responsible for financial planning and budgeting, project accounting, financial reporting, and supporting the Financial Planning section in meeting its budgeting and reporting requirements.

Key Duties & Responsibilities

• Coordinates and facilitates the complete financial planning process for designated services areas.
• Guides and trains budget users and provides support and guidance to all budget managers.
• Calculates and balances internal budget allocations, prepares supporting working papers and provides guidance to budget managers on key allocations drivers.
• Loads allocations, labour activities, and debt servicing estimates into SAP budgets.
• Reviews, analyzes and verifies budget data and financial reports for completeness, accuracy, revenue calculation and compliance with corporate guidelines and policies.
• Updates and enters annual program budgets and sets up capital projects in SAP.
• Sets up budget document control to organize supporting documents on budget changes.
• Creates and monitors budget master data in SAP and Excel for designated departments.
• Trains and provides SAP support and guidance to budget users and managers.
• Compiles and sets up periodic variance reports with supporting details for analysis.
• Prepares quarter and year-end adjusting entries.
• Maintains projects through their entire cycle including capitalization to the SAP asset module.
• Prepares funding journal entries based on the approved financial plan.
• Prepares working papers and reconciliations to support capital fund transactions and year-end capital fund statements.
• Researches and analyzes capital bylaws for capital projects by identifying funding sources, eligible grants, and planned expenditures.
• Assists the capital managers to determine which capital projects are to be closed at year end.
• Determines the equity recorded on capitalized projects and returns unspent funds to source.
• Analyzes and prepares year-end financial working papers and supporting documents.
• Provides ongoing support to budget and project managers and staff.
• Researches, analyzes, reconciles, and prepares reports on labour recovery.
• Assists managers with project design in SAP Project System and analyzing and understanding their project reports.
• Assists project managers with grant applications, completes grant claims and assists with associated ad-hoc billing and cost recovery as required.
• Monitors and analyzes Equipment Replacement funds to ensure sufficient funds for future needs and verifies fund balances.
• Assists in managing CATS time entry process.
• Researches and tests possible solutions/improvements and tests the integrity of the SAP programs after program updates on a regular basis.
• Follows all policies, procedures and standards of the CRD.
• Performs other related duties as required.

Additional Information

• None

Key Skills & Abilities

• Excellent communication (verbal and written), interpersonal and customer service skills.
• Advanced data manipulation skills using MS Excel tools such as Vlookup and Pivot Table.
• Substantial experience with and understanding of Enterprise Resource Planning (ERP) systems such as SAP.
• Working knowledge of financial accounting, planning, budgeting, cost allocation and accounting principles and practices.
• Thorough knowledge of budget preparation and reconciliation procedures.
• Substantial experience with preparation of year-end working papers, financial statements and consolidations, account reconciliations.
• Strong MS Word, Excel, PowerPoint and Outlook and SharePoint skills.
• Strong accurate keyboarding and data entry skills.
• Strong ability to take initiative, use independent judgement and show discretion.
• Strong analytical and problem solving skills.
• Strong organizational skills, including the ability to work under pressure, prioritize work and to set and meet deadlines.
• Strong ability to work independently in a fast paced and constantly changing environment.
• Strong ability to take initiative, use independent judgement and show discretion.
• Strong ability to establish and maintain effective and collaborative working relationships.

Qualifications

Certifications