Job Description

Date Posted: 04/02/2026
Req ID: 47555
Faculty/Division: VP - Division of University Advancement
Department: Advancement Services
Campus: St. George (Downtown Toronto)
Position Number: 00001174
Existing Vacancy: Yes

About us:

The Division of University Advancement (DUA) aims to sustain and enhance the University of Toronto’s academic mission, leadership, and worldwide impact, by engaging alumni and private sector constituents meaningfully in the mission of the University, building mutually beneficial relationships of increasing value and satisfaction over time.

DUA at the University of Toronto is engaged in a transformative agenda deeply rooted in the University’s vision for growth and innovation. We are focus on growing fundraising efforts; enhancing the effectiveness and satisfaction of alumni engagement and programs; building advancement talent capacity within and across divisions; creating an organization and culture that fosters diversity and inclusiveness.

Your opportunity:

Within DUA, Advancement Data & Reporting Services is responsible for divisional data quality, data acquisition practices and data entry standard. The Analyst is responsible for supporting all end-users of various advancement systems and reporting mechanisms as well as reviewing, analyzing, documenting and developing queries, exports, reports and lists that contribute to information management and data integrity at an enterprise level.

The incumbent works in an enterprise level, multi-stakeholder project structure, partnering as a member of a cross-functional team focused on delivering high impact data and reporting solutions involving information from various database systems. The incumbent contributes to improving current and future data integrity and reporting services deliverables that support advancement activities by utilizing business analysis methodologies to document and translate data and reporting requirements into technical specifications and creating data extracts, reports and lists to
support University advancement activities. The incumbent establishes close working relationships with team members, subject matter experts, and technical partners within and outside the immediate project structure.

The incumbent collaborates in the launch, support and maintenance of core operational data and reporting services and business processes. This includes responsibility for eliciting clear, concise, non-conflicting requirements from subject matter experts who may or may not understand how technology can be used to positively transform the business process.

Your responsibilities will include:

• Advising clients and technical subject matter experts on best practice for documenting system requirements
• Analyzing and documenting business requirements
• Assessing needs and contributing to the development of business systems
• Planning the implementation of new business system processes
• Writing complex specifications based on system requirements
• Training end-users on procedures and the use of supported IT systems
• Collaborating oncost estimates
• Scheduling and assigning work to a small group in a limited area

Essential Qualifications:

• Bachelor's Degree or acceptable combination of equivalent experience. A certificate in
  Business Process Management and/or Business Analysis are considered an asset.
• Minimum five (5) years experience working with business process and/or business analysis.
• Experience with business analysis management methodologies and techniques, including requirements analysis, flow charts, process modeling and process mapping, test design andexecution.
• Experience with use of business analysis practices and tools.
• Experience using Business Intelligence software and Data Visualization tools to createdashboards.
• Experience with data analysis, writing database queries using Structured Query Language,stored procedures, and triggers, preparing and presenting reports to internal stakeholdersand training users.
• Functional knowledge and experience in relational database management system concepts and associated reporting tools.
• Experience using Microsoft PowerBI
• Demonstrable skill in multiple technologies in Business Intelligence, data architecture, data modelling, design and implementation.
• Strong analytical skills, able to interpret business requirements and articulate them into models and concepts that plug into bigger scope projects.
• Strong communication skills, able to present requirements, concepts and procedures; ableto design and deliver training and support materials.
• Demonstrated knowledge and skills in the following categories:
• Relational databases (e.g. – MS SQL Server, Oracle, DB2, etc.)
• Data management tools (e.g. – MS SQL Server Management Studio, MS SQL Server Reporting Services, MS Visio)
• BI visualization tools (e.g. – Microsoft PowerPivot/PowerView/PowerMap, Tableau, BusinessObjects, etc.)
• Scripting languages (e.g., T-SQL, PL/SQL, etc.)
• BI/DW Methodologies (e.g. – Kimball DW, Theta ETL infrastructure, Theta Pragmatic Agile,etc.)

To be successful in this role you will be:

• Communicator
• Cooperative
• Multi-tasker
• Organized
• Problem solver
• Self-directed
• Tactful
• Team player

NOTE: This is a term position until December 2027.

Closing Date: 04/14/2026, 11:59PM ET
Employee Group: USW
Appointment Type Budget - Term
Schedule: Full-Time
Pay Scale Group & Hiring Zone:
USW Pay Band 14 -- $91,677. with an annual step progression to a maximum of $117,242. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation/Pay Equity Maintenance Protocol.
Job Category: Administrative / Managerial
Recruiter: Fiona Chan

Lived Experience Statement
Candidates who are members of Indigenous, Black, racialized and 2SLGBTQ+ communities, persons with disabilities, and other equity deserving groups are encouraged to apply, and their lived experience shall be taken into consideration as applicable to the posted position.

A job description is available upon request