Job Salary: $58,500 - $97,500 CAD
Reports To: Director, Financial Planning & Analysis
Department/Unit Name:Financial Planning & Analysis
As a technical Financial Planning & Analysis specialist, support all product lines with the implementation of project financial activities to improve financial related communication and tracking of project financial metrics. Provide support for the analysis and data collection associated with forecasting key deliverables (e.g. revenue, profitability, backlog, sales forecasting, expenses etc.) to aid reporting of current and future financial health.
Project Finance and Revenue Analysis Support
- In collaboration with Management in Financial Planning & Analysis, support the analysis and forecasting of revenue, profitability, costs, and backlog, expenses etc.
- As a liaison between Finance and project operational groups, supporting the development of systems to improve financial related communications and tracking of project financial metrics. This may include providing support for the collection and interpretation of data and the identification of cost saving opportunities at the product, department, and project level.
- Support the development of project and company level budget forecasts for internal and external stakeholders.
- Identify trends related to project cost overruns and opportunities to improve project budgeting by refining costing algorithms.
- In collaboration with Project Directors/Managers, support the coordination and administration of study related budget agreements including the development of change orders and vendor agreements. Support the development of statements of work as appropriate.
- Assist Project Management teams in reconciling project expenditures with budgeted amounts during, or at the conclusion of a project.
- Liaise with Business Development and support Project Directors/Managers with implementation of change orders and, where applicable, statements of work.
- Liaise with Legal to finalize statements of work, change orders and vendor agreements, where applicable.
- Update or recommend improvements to internal revenue management and expense forecasting analysis and change order processes.
- Support technologies and analytics that ensure fluid active revenue forecasting for the organization.
- Support Project Directors/Managers with data collection and forecasting related analysis of revenue and expenses for the product lines.
- Ensure the timely verification and processing of change orders and statements of work.
- Organize technical written materials for statements of work, change orders and vendor agreements including organization of sections, tables, exhibits and attachments.
- Support development of changes to vendor bid packages to ensure accurate alignment with sponsor agreed upon project budgets.
- Support development of assumptions and finalization of vendor budget agreements.
- Support analysis of vendor proposals and budgets by composing comparative analysis.
- Provide mentorship and guidance to new coordinator team members.
- Actively seek and develop process improvements to create new efficiencies within the project team.
- Lead and/or contribute to special projects as assigned by Manager above.
- Applicants should have a minimum of a one-to-two-year post-secondary certification in a relevant field of study, or a minimum of one to three years of related work experience with ongoing training. An accounting or Office Administration specialty preferred. The successful candidate must exhibit the following skills: self-motivation with strong communication skills and a commitment to achieving positive results. Strong attention to detail and keenness to understand the importance of building collaborative relationships to achieve results. Ability to engage in continuous learning and self-development. Ability to continually foster teamwork.
- Skilled in use of spreadsheet, database and/or data-mining software. Advanced Excel proficiency. Literate in the concepts of data analytics. Visual Basic Applications (VBA) skills preferred.
- *Accommodations for job applicants with disabilities are available upon request