Senior Financial Analyst

university british columbia; Vancouver; On-site; CAD 70,000 - 95,000; Full time

Job summary

University of British Columbia seeks a Finance Analyst to support campus budgeting and forecasting. The role provides data analysis, preliminary hypotheses, and insights to assist budgeting decisions and planning across units.

You will train users on university financial systems for the Okanagan campus and collaborate with senior managers to ensure accurate reporting. The position emphasizes data warehousing, BI tools, and creating financial models for scenario analysis and cost review.

Qualifications

• Undergraduate degree required; CPA-PEP enrollment preferred.
• Experience with budgeting, forecasting, and financial reporting is expected.
• Ability to develop financial models and analyze data for decisions.
• Knowledge of Workday, Adaptive Planning, and Calumo is advantageous.

Responsibilities

• Supports campus budgeting and forecasting with data collection and reporting.
• Prepares forecast and budget information for monthly/quarterly/annual reporting.
• Investigates variances and documents root causes for finance managers.
• Posts journal entries and updates forecasts in financial systems.
• Produces funding calculations and allocates entries in planning tools.
• Supports unit-level budgeting through data analysis and reporting.
• Contributes to financial model development for sensitivity and trend analyses.
• Performs ad-hoc financial reports and reconciliations as required.

Skills

Data analysis

Budgeting

Forecasting

Financial modeling

Education

Undergraduate degree in a relevant discipline

Enrolled in CPA PEP

Tools

Workday

Adaptive Planning

Calumo

Job description

This position is responsible for performing general accounting functions, budgetary, systems and related financial activities for the UBC Okanagan Finance department. This role provides support to the Senior Manager, Budget and Financial Planning by proving data analysis, preliminary hypothesis and insights to support budgeting and decision making. This position also supports training of university financial systems for the Okanagan campus.

Organizational Status

Reporting to the Senior Manager, Budget and Financial Planning, this role works closely with the Finance Managers that serve portfolio areas across the entire campus.

Work Performed:

Supports the campus-wide budgeting and forecasting process:

Develops templates and collects data for unit / portfolio level quarterly and annual reporting.

Prepares forecast and budget information for consolidated reporting on a monthly, quarterly, and annual basis, as required.

Investigates variances, identifies root causes, and follows up with relevant Finance Manager to ensure accuracy.

Posts TAM adjusting journal entries in Workday and updates corresponding forecasts in Adaptive.

Prepares GWI and MSP funding calculations for all units and posts entries in Adaptive and Workday.

Processes one-time and recurring funding transfer entries in both Workday and Adaptive Planning as required.

Prepares and posts accrual journals, including Administrative Leave, on a quarterly basis

Reconciles transactions posted to central accounts, including Central Revenue and all Campus Wide Expense workbooks

Prepares funding transfers for Adaptive and Calumo quarterly updates, budget submissions and 5-year planning.

Assists Finance Managers with unit-level budgeting and forecasting through data analysis, data entry, and preparation of reports.

Provides data and system technical expertise:

Utilizes data warehousing, business intelligence tools and software applications to support the Senior Manager, Budget and Financial Planning with analysis, reporting and decision-making.

Collaborates with Finance team members to develop financial models for sensitivity analysis, trend and cost analysis, impact assessments, unit or program profitability evaluations, and "what-if" scenarios to inform strategic and operational decision making. Analyzes financial results for accuracy, investigates anomalies and makes necessary adjustments.

Participates in financial and unit testing of Workday business process improvements. Performs reconciliations between financial management systems during system implementations or modifications to ensure data accuracy and integrity.

Supports financial process analysis and contributes to documenting workflows and training on new systems and procedures.

Provides general accounting and internal control support to campus:

Assists Finance Managers with the preparation and posting of miscellaneous journal entries as required.

Ensures financial data integrity by monitoring cost center transactions and reconciling general ledger accounts. Identifies and corrects miscoded entries to support timely, accurate, and compliant financial reporting in collaboration with Finance Managers

Prepares the monthly Research Funding Report for distribution to campus stakeholders and responds to ad-hoc research reporting requests.

Prepares the semi-annual Indirect Cost Recovery (ICR) report for the School of Engineering by extracting relevant research revenue data and calculating ICR amounts. Posts related journal entries to allocate Faculty ICR to appropriate worktags in accordance with funding guidelines.

Provides ad-hoc financial reports and analysis as requested by the Finance team.

Receives and processes invoices from external vendors and organizations for services supported by the Finance Department and/or AVPFO. Maintains organized records of invoices and related payments.

Performs other related duties as required.

Consequence of Error/Judgement

Must exercise judgment based on a thorough knowledge of procedures, guidelines and regulations. Actions and decisions are critical in ensuring the operational health of the unit. This position has access to sensitive information, the untimely release of which could cause acute embarrassment to the University, as well as litigation. Incorrect decision/judgement will directly affect the University s reputation. Information from budget and forecast models and reports are used for making significant management decision on the allocation/reallocation of resources. Financial errors and negative operation impacts (service and costs) could result if financial position of this department is inaccurate. The analyst, given initial parameters, would be expected to obtain the necessary data and create the analysis without supervision. The supervisor will review data and analyses produced by the incumbent. Mistakes discovered at this stage could result in lost time, and perhaps the wholesale revision of the analysis.

Supervision Received

Under the supervision of the Senior Manager, Budget and Financial Planning, this position is expected to work independently and keep supervisor informed of workload status. Analyses and reports produced by this position will be reviewed for content, structure and adherence to

university policy

Supervision Given

This position has no direct reports.

Qualifications

Minimum

Undergraduate degree in a relevant discipline. Enrolled in the CPA Professional Education Program (PEP). Minimum of three years’ experience or the equivalent combination of education and experience.

Willingness to respect diverse perspectives, including perspectives in conflict with one's own.

Demonstrates a commitment to enhancing one's own awareness, knowledge, and skills related to equity, diversity, and inclusion.

Preferred

Experience with ERP implementation is an asset.

Experience with Workday is an asset.

Knowledge of UBC s institutional accounting processes (includes chart of accounts, technical accounting, reporting) and fixed assets (asset tracking, capitalization and capital projects) is highly recommended.

Demonstrated advanced knowledge and skill in the use of financial software applications, databases, spreadsheets, and word processing.

Ability to apply generally accepted accounting principles in an appropriate manner.

Ability to analyze problems, identify key information and issues, and effectively resolve.

Ability to prioritize and work effectively under pressure to meet deadlines.

Ability to effectively manage multiple tasks and priorities.

Ability to prepare financial reports.

Ability to perform complex analyses.

Ability to maintain accuracy and attention to detail.

Ability to exercise judgement, tact, discretion and confidentiality in all matters and to maintain effective working relationships.

Ability to communicate effectively verbally and in writing.