Business Systems Analyst

About this position

Date Posted: 03/21/2023
Req ID: 30381
Faculty/Division: Division of University Advancement
Department: Advancement Services
Campus: St. George (Downtown Toronto)
Position Number: 00001174

Description:

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 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 Serve rReporting 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
• Problem solver
• Self-directed
• Tactful
• Team player

Closing Date: 04/04/2023, 11:59PM ET
Employee Group: USW 
Appointment Type: Budget - Continuing 
Schedule: Full-Time
Pay Scale Group & Hiring Zone:  

USW Pay Band 14 -- $81,000 with an annual step progression to a maximum of $103,588. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation/Pay Equity Maintenance Protocol. 
Job Category: Administrative / Managerial
Recruiter: Blythe Campbell

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.

All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.

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 uoft.careers@utoronto.ca.