Talent.com
Financial Coordinator

Financial Coordinator

University of WaterlooWaterloo, ON, CA
30+ days ago
Salary
CA$58,286.00–CA$72,858.00 yearly
Job type
  • Temporary
Job description

Overview

The Financial Coordinator (Coordinator) administers post-award research funding and operating financial activities of an assigned group of faculty members and research groups in Electrical & Computer Engineering (ECE). The Coordinator provides guidance and financial support including reporting to reduce the liability to the department and University by proactive financial management of external research funding. The Coordinator ensures compliance with university and granting agency financial policies and procedures. The grants / contracts can include but are not limited to any federal, provincial, institutional, corporation / business, association / society, foundation, or any other agency / organization. The incumbent assists principal investigators (PI) to understand the constraints of specific granting guidelines, as well as recommend strategies to maximize the use or the leverage of research funding.

The Coordinator also supports the Financial Officer in managing the department’s operating budget, and ensures compliance with financial management policies required for effective and efficient operations.

Responsibilities

Research Financial Administration and Compliance

  • Responsible for the financial administration of all operating and research grants / contracts for assigned faculty members in accordance with relevant university policies, granting agency guidelines, and negotiated sponsor agreements
  • Provide advice to Principal Investigators (PIs) concerning University and / or granting agency’s policies and procedures (. eligibility of expenses, preparation of forms, and comprehension of financial reports
  • Provide guidance to faculty members on University financial rules and policies including overhead allocation, release time stipend allocation, etc.
  • Ensure researchers and relevant research personnel are complaint with UW research finance policies and procedures, and those set forth by external granting agencies
  • Monitor, review and reconcile accounts monthly, and advise PIs of discrepancies
  • Review expenses and ensure budget allocations are appropriate and adequate
  • Confirm eligibility of expenditures against agency guidelines and University policies and procedures
  • Provide guidance on policies and procedures regarding research equipment and furniture purchases, and asset disposal associated with research funds
  • Review purchase of equipment and supplies for research groups, including the sourcing and procurement of major equipment and is compliant with Policy 17
  • Ensure compliance with policies and procedures concerning determination of independent contractor status for services
  • Review cover sheets and research proposal budgets to ensure overhead allocation, identify in-kind, financial and space commitments affecting departmental operating funds, or specification for research consulting payment
  • Monitor spending levels on research project grants and provide PIs with budget and financial information enabling them to manage their accounts
  • Ensure funds have been collected or returned, overspent balances have been transferred and expired grants / contracts have been inactivated
  • Identify overspends and work with the PI to resolve through re-allocation of expenses
  • Make recommendations regarding deficit resolution strategies to respective faculty members, and reviews them with the Financial Officer and Office of Research
  • Prepare custom financial reports based on researcher needs and interprets financial data to answer queries from PIs, identifying potential issues and anomalies
  • Recommend strategies to maximize the use of research funding within the constraints of specific granting programs
  • Answer uncommon and complex inquiries that may require working with the Office of Research to obtain clarification from sponsors
  • Responsible for financial reporting as required including data analysis and create detailed and summary reports as appropriate to the funding agency, industry contract or auditors
  • Forwards financial reports . form 300’s received from Office of Research to PIs and obtains approval signatures by stipulated deadline date

Financial Administration

  • Review and process out-of-pocket expense and faculty professional expense reimbursement claims in reimbursement system (Concur)
  • Assist client groups with understanding various financial reports, financial policies / procedures, financial terminology, and standard accounting practices
  • Advise on budget and cost-recovery requirements
  • Assist the Financial Officer to administer department operating budget
  • Prepare internal lab billings ensuring compliance with internal policies, external funding agency requirements, and accounting standards
  • Process all financial transactions including purchasing, payables, and both internal and external invoicing
  • Create and review journal entry transactions, including interdepartmental billings and ensure transaction is in compliance with the University’s policies on fund transfers, applicable tax rules and expense transfer approvals
  • Reconcile assigned general ledger accounts including accounts receivable, advances, etc.
  • Analyze details of budget, actual expenditures, encumbrances, and prepare variance analysis reports
  • Provide guidance to others on the use of systems including Concur, Unit4 and Workday
  • Assist students (undergraduate and graduate) with the preparation of expense claims for travel and out-of-pocket expenses

    • Human Resources Administration

  • Review requests for non-faculty appointments (post-doctoral fellows, research associates), temporary employment authorizations, casual payments, and change of salary allocations for eligibility and available funds
  • Ensure that contract end dates do not exceed the grant end date and prepare salary allocation forms as required
  • Complete compliance review for Graduate Research Studentship and Graduate Research Assistants payments
  • Coordinate hiring documentation for temporary staff, USRA, URA, casual employees and process hires in Workday
  • Liaise between PIs, the department and Human Resources on issues relating to research personnel
  • Update database for casual, URA and URSA appointments

    • Other

  • Act as backup to other Coordinators during absences or provide additional support as required
  • Assist with internal and external audits as required
  • Attend all meetings and training on new systems and procedures as required
  • Stay current on changes in granting agency regulations, University policies and procedures, research administration best practices, and new technology or programs
  • Special projects analysis, reporting, or other duties as assigned by the Financial Officer or Administrative Officer to meet the research goals and strategic objectives of the department

    • Qualifications

  • University degree in accounting, post-secondary accounting diploma, or equivalent combination of education and experience
  • Accounting designation an asset
  • 3 years related accounting experience including financial monitoring and analysis, preferably in a university environment
  • Research finance experience working with grants / contract administration an asset
  • An understanding of the academic environment, in particular research environment is preferred
  • Experience in financial reporting, internal control, financial analysis, budgeting, forecasting and accounting
  • Experience with reconciliation, troubleshooting and resolving variances, and reporting on the same
  • Strong computer skills with advanced experience with MS Excel including pivot tables, look-ups, macros, scenario analysis, etc.
  • Experience with online enterprise financial reimbursement, procurement systems, human resource management, payroll systems, and databases
  • Previous experience using University internal systems (Concur, Unit4, Workday, FileMaker) are assets
  • Sound knowledge of accounting principles and financial judgement
  • Strong decision- making and critical thinking skills, and well-developed judgment are essential
  • Demonstrated ability to interpret policies, financial statements and apply guidelines and procedures
  • Demonstrated problem-solving skills with the ability to identify issues, investigate and find creative solutions
  • Ability to analyze financial data and present it in a pertinent format
  • Strong client-service orientation with a focus on providing exceptional customer service in a team environment
  • Excellent interpersonal skills and ability to interact professionally and effectively with diverse constituencies of the university and external partners
  • Strong verbal and written communication skills are essential
  • Excellent organizational and time-management skills required to manage a high volume of work and multiple demands
  • Ability to work accurately with excellent attention to detail, efficiently and effectively both independently and as part of a team
  • Flexibility and initiative is necessary to work in a dynamic and challenging work environment
  • Demonstrated ability to handle confidential information with discretion and tact
  • Ability to adapt to changing administrative and financial systems
  • Knowledge of federal and provincial funding sources and related guidelines for institutional awards preferred