Date Posted: 09/05/2025
Req ID: 45084
Faculty/Division: VP - Division of University Advancement
Department: Advancement Services
Campus: St. George (Downtown Toronto)
Position Number: 00048631

ABOUT US:

The Division of University Advancement (DUA) promotes and supports the University of Toronto by engaging a worldwide community of more than 600,000 alumni, plus many donors and friends. DUA encompasses a highly skilled team of staff focused in the areas of development (fundraising), alumni and volunteer engagement, advancement services, and advancement marketing and communications. The uniquely integrated structure encourages each division to bring its particular strengths and expertise to the common cause of advancing U of T’s relations with alumni, donors, and friends.
DUA at the University of Toronto is engaged in a transformative agenda deeply rooted in the University’s vision for growth and innovation. DUA is focused on doubling fundraising performance on a sustainable basis; enhancing the effectiveness and satisfaction of alumni participation and programs; building advancement capacity within and across divisions; creating an organization and culture that fosters leadership, initiative, effectiveness, and community; and contributing to the creation of an external relations strategy for a transforming image, reputation and standing of U of T along an axis of differentiation and excellence.

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 and execution.
• Experience with use of business analysis practices and tools.
• Experience using Business Intelligence software and Data Visualization tools to create dashboards.
• Experience with data analysis, writing database queries using Structured Query Language, stored procedures, and triggers, preparing and presenting reports to internal stakeholders and 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 modeling, design and implementation.
• Strong analytical skills, able to interpret business requriements and articulate them into models and concepts that plug into bigger scope projects.
• Strong communication skills, able to present requirements, concepts and procedures; able to 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 PowePivot/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.)

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

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 on cost estimates
• Scheduling and assigning work to a small group in a limited area

TO BE SUCCESSFUL IN THIS ROLE YOU WILL BE:

• Communicator
• Cooperative
• Multi-tasker
• Organized
• Problemsolver
• Self-directed
• Tactful
• Team player
  Closing Date: 09/16/2025, 11:59PM ET
  Employee Group: USW
  Appointment Type: Budget - Continuing
  Schedule: Full-Time