Technology Adoption Consultant, Systems and Data Integration

Date Posted: 12/02/2024
Req ID:40938
Faculty/Division: Ontario Institute for Studies in Education
Department: Education Commons
Campus: St. George (Downtown Toronto)

Description:

About us:

OISE is recognized as a global leader in graduate programs in teaching and learning, continuing teacher education, and education research. As one of the largest and most research-intensive faculties of education in North America, OISE is an integral part of the University of Toronto - Canada’s most dynamic and comprehensive institution of higher learning.

OISE is committed to enhancing the social, economic, political and cultural well-being of individuals and communities locally, nationally and globally through leadership in teaching, research and advocacy. A unique place to work, learn and grow, OISE addresses current and emerging challenges with the scale, academic excellence and collaborativeenergy that few institutions in the world can claim.

At the heart of OISE's commitment to fostering innovation and excellence is the Education Commons. The Education Commons is integral to the success of the institute's academic and research programs, providing cutting-edge technological environments and information systems. Through collaboration with major research and development initiatives, the Education Commons designs, implements, and evaluates transformative digital tools and spaces that empower faculty, students, and researchers. By integrating advanced technologies with educational practices, the Education Commons ensures that OISE remains at the forefront of educational innovation and leadership.

The Education Commons will provide, in collaboration with major research and development initiatives where appropriate, the iterative design, implementation and evaluation of technological environments and information space in which the academic and research programs of OISE are carried out.
 

Your opportunity:

Under the direction of the Director, Education Commons and in collaboration with Education Commons team members and University’s Data Architect, the Technology Adoption Consultant, Data and Systems Integration will lead initiatives to design and implement robust data models, tools, and processes that support OISE’s strategic goals. This role ensures seamless data integration, maintaining high data quality standards, and empowering the OISE community with actionable insights through interactive dashboards and self-service tools.

This role will work with modern cloud environments, such as Azure, and leveraging tools like Power Query, DAX, PowerBI and Power Appsto build insightful PowerBI dashboards and reports. The incumbent will design efficient ETL processes, ensure seamless data integration across platforms, and optimize databases to provide high-quality, consistent data for analysis and decision-making. The role also involves maintaining a comprehensive data dictionary and managing data models, architectures, and classifications, ensuring the OISE community has the tools and information needed for data-driven success.

The incumbent will work collaboratively to create and maintain an OISE-specific “data mart,” enabling self-service reporting for power users. They will act as a bridge between data infrastructure, analytics, and technology, ensuring all solutions align with OISE’s academic and operational priorities.

In this role, you will also be responsible for managing data assets, developing integration frameworks, and providing technical leadership for technology-driven projects. A key part of this role will involve the development and maintenance of a comprehensive data dictionary to improve data understanding and usability across the OISE community.
 

Your responsibilities will include:

• Analyzing the effectiveness and efficiencyof existing systems such as ETL [Extract, transform, load] and develop technical solutions for system improvements.
• Liaise with clients to ensure designs reflect operational requirements
• Analyze and Interpret highly complex and technical data
• Planning the implementation of new business system processes
• Conducting data analysis for business system analysis and improvement
• Evaluating and identifying new technologies or new modified business processes to determine enhancement requirements
• Analyzing the security and Integrity of highly complex system problems and/or implications of any new or changed procedure or technology

Essential Qualifications:

• Bachelor’s degree in Data Analytics, Computer Science, Information Systems, or a related field (or equivalent experience)
• Minimum five years experience in providing solutions to business challenges or opportunities
• Proven experience with ETL tools and processes
• Strong proficiency in PowerBI, including DAX, Power Query, and report optimization
• Experience with Power Apps for application development and process automation
• Knowledge of data architecture, data modeling, and system integration principles
• Familiarity with database systems (e.g., SQL Server, Azure SQL)
• Hands-on experience with Azure cloud environments, including data storage and analytics tools
• Strong project management skills, with experience leading technical projects
• Excellent communication skills and ability to work collaboratively with the OISE community

Assets (Nonessential):

• Technical certifications related to project management, process improvement, and business analysis (e.g., PMP,ITL,CBAP,CSPO) are an asset

To be successful in this role you will be:

• Accountable
• Assertive
• Communicator
• Goal oriented
• Organized
• Team player

Closing Date: 12/10/2024,11:59PM ET
Employee Group: USW 
Appointment Type: Budget - Continuing 
Schedule: Full-Time
Pay Scale Group & Hiring Zone: USW Pay Band 16 -- $101,539. with an annual step progression to a maximum of $129,851. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation/Pay Equity Maintenance Protocol.
Job Category: Information Technology (IT)