Revenue Analyst

At theUniversity of Waterloo we create and promote a culture where everyone can reach their full potential. As an employee you get support & opportunities that empower you to advance your career. Explore how we can bring big ideas to life together. The University is a welcoming workplace for those of all abilities interests and expertise. As part of our workforce you can do what you do best every day.

Learn more about our recruitment process.

Job Requisition ID:

Time Type:

Employee Group:

Job Category:

Employment Type:

Department:

Hiring Range:

Posting Information:
This posting is for an existing vacancy.

Term 2 years

Internal posting expires Thursday April 16th at 11:59 PM

Job Description:

Primary Purpose

The Revenue Analyst is accountable to the Manager Revenue Accounting for processing complex transactions reporting on and reconciling accounts related to the Universitys non-tuition revenue.

The Revenue Analyst provides input to establish and draft policies and procedures related to revenue to ensure efficient and standardized processing of transactions. This role monitors the Accounts Receivable module to maintain accurate and active customer information while ensuring that customer accounts accurately reflect transactions including invoices and related payment activity.

In addition this role will support the implementation of a new Financial Enterprise Resource Planning (ERP) system from a revenue perspective by providing input into process design configuration testing documentation reporting and user training.

Key Accountabilities

Produce accurate financial transactions and timely financial analysis reports

Use judgment in applying knowledge of University policies and procedures and other published guidelines in recording revenue and accounts receivable transactions

Must be familiar with generally accepted accounting principles as it applies to the University

Monitor and reconcile customer account balances and follow-up on any discrepancies; make recommendations and action for customer data integrity/consistency issues

Propose development maintenance and expansion of revenue-related reporting using reporting tools such as PowerBI Excel etc.

Present monthly Revenue statistics for discussion; highlight areas for follow up based on statistics

Participate in the month-end close process including reconciliations and preparation of journal entries and receivable aging reports to balance the Account Receivable subledger to the general ledger

Prepare narratives working papers and respond to external auditor inquiries providing backup as needed

Review and process invoice and payment receipt adjustments

Process foreign exchange transactions related to multi-currency invoices and payments

Provide/generates payment receipts when requested by customers

Manage bankruptcy notification process; coordinate communication and documentation with legal and affected department

Provide advice training and direction on revenue policies procedures and best practices

Interact with client group representatives across campus to ensure that University policies and procedures are followed in recording complex revenue and tax transactions

Develop and recommend improvements to processes in place to record revenue through the accounts receivable system or directly to the general ledger as appropriate for the sales activity; work with the Financial Systems team as the Revenue lead to implement improvements

Develop customized deposit solutions for departments to record revenue in the ERP system as funds are received. Maintain database of master deposit templates as backup to files posted for departmental use

Respond to inquiries and communicate financial information to client groups who often have little/no accounting experience

Apply a strong understanding of GST/HST as it relates to University revenue to respond to inquiries from client groups and to review revenue activity for compliance in order to identify and resolve GST/HST issues associated with revenue transactions

Provide ongoing training and support to the University community to ensure relevant revenue and internal control procedures use of financial systems and forms are well understood and followed

Oversee collection of outstanding invoices

Investigate overdue accounts and ensure they are followed up in a timely manner

Develop maintain and oversee generation of collection notices within the ERP system

Develop payment plans with customers to resolve overdue accounts as required

Respond to high level customer invoice/collection inquiries

E-commerce

Act as the primary operator of the Universitys central e-commerce solution

Investigating and resolve discrepancies between the e-commerce solution and payment gateway

Participate in the ongoing review of services offered through the Universitys central e-commerce solution as a member of the central e-commerce committee

Review University department e-commerce item requests for appropriateness and build online products as necessary

Review refund requests and process refund transactions for a variety of e-commerce solutions across the University; follow up on refund requests requiring additional backup for audit purposes or that are out of alignment with the stated refund policy

ERP System Implementation

Participate as functional expert representative for Revenue in financial system upgrades including testing and ongoing maintenance

Lead training for Revenue Associates relating to the new ERP system as required

Provide input into process design and configuration

Complete system testing and documentation for required Revenue functionality

Other

Provide backup to other revenue functions as required

Participate and support other department projects as required

Required Qualifications

Education

Post-secondary education with a focus on accounting courses or equivalent combination of education and work experience.

Experience

Experience in an analyst role in an accounts receivable/revenue related environment required

Experience in an enterprise-wide computerized accounting environment

Experience in a not-for-profit environment preferred

Experience in a multi-currency environment is considered an asset.

Experience with an ERP implementation is considered an asset

Knowledge/Skills/Abilities

Demonstrated ability to prioritize and manage concurrent assignments effectively and efficiently

Strong analytical technical and problem-solving skills with attention to detail

Conceptual thinker with strategic planning skills and initiative

Demonstrated ability to work independently as well as in team settings

Superb organizational planning interpersonal and communication skills are required to address and resolve issues of procedure policy and compliance.

Tact judgement and diplomacy are essential

MS Office skills required include Advanced Excel Intermediate Word and Intermediate SharePoint. Familiarity with Unit4 Concur PowerAutomate PowerApps and PowerBI is considered an asset

Advanced understanding of Generally Accepted Accounting Principles internal controls and tax-related issues preferred.

Equity Statement

The University of Waterloo acknowledges that much of our work takes place on the traditional territory of the Neutral Anishinaabeg and Haudenosaunee peoples. Our main campus is situated on the Haldimand Tract the land granted to the Six Nations that includes six miles on each side of the Grand River. Our active work toward reconciliation takes place across our campuses through research learning teaching and community building and is coordinated within the Office of Indigenous Relations.

The University values the diverse and intersectional identities of its students faculty and staff. The University regards equity and diversity as an integral part of academic excellence and is committed to accessibility for all employees. The University of Waterloo seeks applicants who embrace our values of equity anti-racism and inclusion. As such we encourage applications from candidates who have been historically disadvantaged and marginalized including applicants who identify as First Nations Métis and/or Inuk (Inuit) Black racialized a person with a disability women and/or 2SLGBTQ.

Positions are open to qualified candidates who are legally entitled to work in Canada.

The University of Waterloo is committed to accessibility for persons with disabilities. If you have any application interview or workplace accommodation requests please contact Human Resources or ext. 45935.