Data Engineer, Lead

University of Toronto; Toronto; On-site; CAD 97,000 - 114,000; Full time

Job summary

University of Toronto is seeking a Lead role in Institutional Research and Data Governance to guide data engineering, ETL development, and platform migration from on-premises to a cloud-based environment.

The role oversees data pipelines, collaborates with HR, Research, Enrolment, and University Relations to extract information requirements, and ensures performance tracking and scalability of data services across the University.

Qualifications

• Undergraduate degree in computer science or equivalent combination of education and experience.
• Minimum five (5) years’ experience in database engineering and managing large-scale data warehouse environments.
• Experience developing data engineering pipelines with Informatica and Microsoft Azure Platform is highly desirable.

Responsibilities

• Lead development processes for institutional data sets and support university teams onboarding to the new cloud platform.
• Track performance of resources and scale services based on needs of the University.
• Collaborate with shared services and academic divisions to determine information requirements and develop ETL programs.
• Provide technical leadership for data engineering solutions and stay current with tools and technologies.

Skills

Informatica

Azure

ROSI

MS Excel

ETL pipelines

Education

Bachelor's degree in computer science

Tools

Azure Data Factory

Databricks

SQL Server

Job description

Description:

The University’s Institutional Research and Data Governance (IRDG) office was formally launched in 2020. In addition to providing leadership and administrative support for the institution’s data strategy, the IRDG office’s mandate is to:

• provide data, reporting and analytics services within our distributed institutional research model: lead institution-wide analysis projects, provide training opportunities for divisional analysts, implement new analytics tools and platforms, and improve access to curated institutional data sets
• implement an institution-wide Data Governance program to support the University in strategically harnessing data to achieve institutional goals
• support external reporting of institutional data (SMA metrics, key performance indicators for governance, international rankings, data exchanges with peer institutions)

The role will help implement new tools and technologies as the University undergoes its platform migration from on-premise to a cloud-based platform. The Lead will not only oversee development processes for institutional data sets but will support teams across the University as we onboard them to the new platform. This role will also track the performance of our resources and related capabilities, while seeking to evolve and scale this service based on the needs of the University.

The role will require general analysis skills, working with clients across shared services and academic divisions including the Compensation and Labour Relations units in Human Resources, Research Services, Enrolment Services, and University Relations to determine information requirements; developing ETL programs for analytics initiatives, leading small projects; and providing technical leadership for data engineering solutions.

The Lead must keep abreast of current tools/technologies including Informatica, SQL Service, Azure Data Factory, Databricks, Azure Databricks etc. The Lead will also have knowledge regarding data architecture, data modeling and data warehouse design. The incumbent will proactively gather material from appropriate web sites, technical publications, white papers, etc. of interest to the department. The incumbent will provide the “hands‑on” technical expertise required to implement and maintain data pipeline solutions. Although this expertise is primarily related to ETL, it is not limited to these technologies, and may extend to other development tool sets.

Qualifications Required

Education

Undergraduate degree in computer science or an equivalent combination of education and experience.

Experience

Minimum five (5) years’ experience in database engineering. Experience in managing large scale data warehouse environments. Demonstrable understanding of analysis and design methodologies using appropriate tools. Minimum two (2) years’ experience developing data engineering pipelines. Directexperience with Informatica and Microsoft Azure Platform is highly desirable. Experience in machine learning desirable.

Skills

• Proficiency with ETL tools including Informatica
• Familiarity with Microsoft Azure Knowledge of AMS systems: FIS and HRIS
• Knowledge of student system: ROSI
• Expert knowledge of MS Excel.

Other

Excellent writing, communication and presentation skills; Strong analytical, problem-solving and interpersonal skills; Understanding of University financial and enrolment matters; Ability to work to strict deadlines and pressure situations; Commitment to diversity and equity.

NOTE: This position is 70% onsite.

Closing Date:11/25/2026, 11:59PM ET
Employee Group: Salaried
Personnel Subarea:PM
Appointment Type: Budget - Continuing
Schedule: Full-Time
Pay Scale Group & Hiring Zone:PM 3 -- Hiring Zone: $97,336 - $113,558 -- Broadband Salary Range: $97,336 - $162,224
Job Category: Information Technology (IT)

Diversity Statement

The University of Toronto embraces Diversity and is building aculture of belonging that increases our capacity to effectivelyaddress and serve the interests of our global community. Westrongly encourage applications from Indigenous Peoples,Black and racialized persons, women, persons withdisabilities, and people of diverse sexual and gender identities.We value applicants who have demonstrated a commitment toequity, diversity and inclusion and recognize that diverseperspectives, experiences, and expertise are essential tostrengthening 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] .

The University of Toronto has implemented a process to substantiate Indigenous Membership/Citizenship/Enrolment for candidates who identify as Indigenous. For more information about this process, please refer to the Indigenous Substantiation Website .