Business System Analyst

InsideHigherEd; London; On-site; CAD 91,000 - 118,000; Full time

Job summary

A leading educational institution in Canada seeks a Business System Analyst to support data integrity and reporting services. The ideal candidate will possess a Bachelor's Degree and a minimum of 5 years of experience in business analysis. Responsibilities include advising clients on best practices, analyzing business requirements, and collaborating with cross-functional teams to enhance reporting solutions. Benefits include a competitive salary and the opportunity to contribute to a transformative agenda in university advancement.

Qualifications

• 5+ years experience in business process and/or business analysis.
• Experience with business analysis management methodologies and techniques.
• Experience using Business Intelligence software.

Responsibilities

• Advising clients on documenting system requirements.
• Analyzing and documenting business requirements.
• Planning the implementation of new business system processes.

Skills

Business analysis management methodologies

Data analysis

Communication skills

Relational databases

PowerBI

Education

Bachelor's Degree

Certificate in Business Process Management

Tools

Microsoft PowerBI

MS SQL Server

Tableau

Job description

Overview

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 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.)

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

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

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.

Diversity Statement

The University of Toronto embraces Diversity and is building a culture of belonging that increases our capacity to effectively address and serve the interests of our global community. We strongly encourage applications from Indigenous Peoples, Black and racialized persons, women, persons with disabilities, and people of diverse sexual and gender identities. We value applicants who have demonstrated a commitment to equity, diversity and inclusion and recognize that diverse perspectives, experiences, and expertise are essential to strengthening our academic mission.

As part of your application, you will be asked to complete a brief Diversity Survey. This survey is voluntary. Any information directly related to you is confidential and cannot be accessed by search committees or human resources staff. Results will be aggregated for institutional planning purposes. For more information, please see http : / / uoft.me / UP .

Accessibility Statement

The University strives to be an equitable and inclusive community, and proactively seeks to increase diversity among its community members. Our values regarding equity and diversity are linked with our unwavering commitment to excellence in the pursuit of our academic mission.

The University is committed to the principles of the Accessibility for Ontarians with Disabilities Act (AODA). As such, we strive to make our recruitment, assessment and selection processes as accessible as possible and provide accommodations as required for applicants with disabilities.

If you require any accommodations at any point during the application and hiring process, please contact [e-mail] .

Job Segment: Business Analyst, Business Intelligence, Data Architect, Data Entry, Data Management, Technology, Data, Administrative