Position Title: Budget and Financial Analyst

Position # BDGT98

Page 1

Position Description

A. Information:

Position Title: / Budget and Financial Analyst
Position #: / BDGT98
Category: / Budget and Financial Analyst
Instruction/Support Area: / Financial Services
Division/Department: / Bursar
Reports to: / Manager, Budget Analysis and Planning
Positions Supervised: / None
Affiliation: / CUPE, Local 15 – VMECW
Pay Grade: / 22
Date Prepared: / February 1st, 2006
  1. Position Summary:

The Budget and Financial Analyst supports the budget administration process and participates in the development of the annual budget according to established College and Departmental policies and procedures. This position also performs complex analyses of financial and budgetary data, including reconciliation and variance analyses; and ensures necessary documentation is maintained. The position is responsible for preparing various financial and budgetary reports.

C. Duties & Responsibilities:

  1. Supports the budget administration process and participates in the development of the annual budget:(40%)
  • Reviews, verifies, and analyzes budget submissions from departments to ensure completeness, accuracyand authorization and updates budget datain the Banner system in anaccurate and timely manner. Ensures all changes are in conformance with established procedures, regulations and organizational objectives; and appropriate documentation is assembled for audit trail.
  • Updates budgeted sections and salary data into faculty workload database and Banner; evaluates database for completeness and accuracy, and determines the annual sectional charge.
  • Identifies, analyzes, and monitors positions over budgets by examining the faculty workload database, payroll records, and Banner;and provides corrective recommendations and/or explanations to the Manager, Budget Analysis and Planning.
  • Maintains Banner chart of accounts based on departmental needs and/or requests, by updating existing or creating new codes.
  • Transfersbfunds udgets between accounts, cost centers, and positions as requested or needed by departments; to meet fiscal needs, cover shortfalls or for budget management.
  • Incorporates changes in forecasted salary expenses as a result of revised collective agreements as necessary.
  • Consolidates budgetary data received for use in preparing annual financial plans.
  1. Responsible for reporting, tracking and analyzingassigned faculty workloads for the purpose oftracking comparing to budgets, and allocating and recording charges to department using sectional rate:(25%)
  • ManagesResponsible for the Faculty workload confirmation process.
  • Ensures that Faculty workloads are reported to, confirmed and reconciled with, the Dean’s officeand Registrar’s office offices records in student system, in an accurate and timely manner.
  • Determines and records departmental charges into Banner using the sectional rate; and ensures data in Banner and database are congruentconsistent.
  • Investigates and provides explanations for all variances and anomalies.
  • Reconciles assigned Faculty workloads to salaries paid each semester to determine under/overload accruals for the year.
  1. Prepares the Annual FTE Enrolment report, GRE Quarterly reports and various ad hoc and cyclical financial, budget, and statistical reports, as required: (15%)
  • AResponsible for nalyzesing and auditsing the enrolment database and preparesing the FTE reports for the Members of the Board of Langara College and the Ministry of Advanced Education; ensuring they are complete and accurate, This includes: liaisoning with Institutional Research, Continuing Studies and Registrar’s office; following up on investigating discrepancies; explaining FTEs, variances, and errors to the appropriate manager; liaisoning with Information and Computing Services to investigate anomalies in enrolment database; liaisoning with auditors; checking for data integrity, verifying and auditing program divisors (credits) etc.
  • Compiles, analyzes financial data and prepares quarterly balance sheets and income statements for the Government Reporting Entity (GRE); ensuring they adhere to the GRE guidelines, as approved by the Manager, Budget Analysis and Planning.
  1. CResponsible for conductsing analyses of budgetary and financial information: (10%)
  • Conducts analyses of budgetary and financial information by applying budgetary methods and techniques, statistical methods and formulas; compares and contrasts current with historicalbudget and program data using the Banner system and other computerized software.

Performs budget execution and administration work involving the monitoring of incurred and actual expenditures of funds.

  • Reconciles actual and budgeted data of salary or expenditures; works with various departments in investigating and researching variances, errors, and other discrepancies as needed; and provides appropriate documentation including explanations of variances and recommendations.
  • Reviews historical data and/or matches funding requests or projected costs with past records to determine trends in spending and forecasts annual funding needsbudgetary requirements.
  • Prepares cost benefit analyses and provides recommendations for other departments related to projects and/or programs as requested.

4.Prepares various ad hoc and cyclical financial, budget, and statistical reports, as required: (%)

Responsible for analyzing and auditing the FTE data and preparing the FTE reports for the Members of the Board of Langara College and the Ministry of Advanced Education and Minister Responsible for Research and Technology, Province of British Columbia; ensuring they are complete, accurate, and authorized. This includes: liaising with Institutional Research; following up on discrepancies; explaining FTEs, variances, and errors to the appropriate manager; liaising with ICS to fix errors in the Data Warehouse; liaising with auditors; checking for data integrity and verifying and auditing divisors (credits) etc.

Compiles and analyzes financial data and prepares quarterly balance sheets and income statements for the Government Reporting Entity (GRE); ensuring they adhere to the GRE guidelines, as approved by the Manager, Budget Analysis and Planning.

Prepares cost benefit analyses and provides recommendations for other departments related to projects and/or programs as requested.

5.Performs various duties in the absence of the Manager, Budget Analysis and Planning(5%):

  • Handles general budget enquiries and refers more complex problems and matters of policy to the Director of Finance.

6.Performs other duties and/or projects as required(5%):

  • Assists in testing changes to the financial data base system, including assisting with analysis of data integrity.
  • Updates the Budget procedure manual and assists with the development of budgetary guidelines, instructions and templates.

D. Organization Chart

E. Qualifications Required

Education & Experience

  • Completion of Grade 12 plus accounting diploma or equivalent in the CGA or CMA program (equivalency determined as CGA Level 3 or CMA Level 4).
  • 3 years of recent related experience working in a Windows environment using spreadsheet software and integrated financial database, preferably in a post-secondary institution.
  • An equivalent combination of education, training and experience will be accepted.
  • Knowledge of budget, finance,accounting and control procedures, principles and practices.
  • Intermediate to advanced knowledge and experience in developing and maintaining spreadsheets in Excel.
  • Intermediate knowledge in the use of other computer applications such as Word, MS Access, Internet, and email.
  • Knowledge of Oracle Discoverer is preferred.

Skills and Abilities

  • Ability to create, develop and maintain complex spreadsheets and prepare related analyses.
  • Strong research, analytical and problem solving skills.
  • Ability to maintain a high degree of accuracy and confidentiality in managing and reporting salary, budget, and other financial information.
  • Ability to work independently with minimum guidance and in accordance with relevant policies and procedures.

Ability to work under pressure and manage work priorities within multiple and competing deadlines.

  • Ability to communicate effectively in a clear and concise manner, both orally and in writing.

Ability to maintain a high degree of accuracy and confidentiality in managing and reporting salary, budget, and other financial information.

  • Ability to work under strict time constraints and ability to prepare accurate and timely budget and financial information within targeted deadlines.
  • Ability to work effectively with a variety of individuals and groups, including all members of the College.
  • Ability to assess user needs and respond as required, i.e. budget setup, account setup/advice on how to record financial data.

Ability to work independently with minimum guidance and in accordance with relevant policies and procedures.

  • Ability to apply a variety of policies, procedures, and guidelines.

F. Supervisor’s Review:

I agree that the above accurately describes the duties and responsibilities of this position.

Signature:______Date:______

(Supervisor/Administrator of position)

G. Human Resources Approval:

Signature:______Date:______

(Human Resources Advisor)

POSITION # BDGT98