"Business System Analyst"

Job Details

Business System Analyst

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

Description:

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.

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 on cost 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 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 requirements 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 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

Closing Date: 09/16/2025, 11:59PM ET

Employee Group: USW

Appointment Type: Budget - Continuing

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: Information Technology (IT)

Recruiter: Fiona Chan