Data Engineer

University of Toronto; Greater Toronto Area; On-site; CAD 101,000 - 130,000; Full time

Job summary

The University of Toronto seeks a Data Engineer to advance its data strategy. This role involves designing data pipelines and ensuring efficient data integration across the university. Ideal candidates will have a strong background in SQL, data warehousing, and cloud platforms, particularly Azure.

Qualifications

• Minimum five years of experience as an ETL developer.
• Experience with data warehouse projects and handling large, complex data sets.

Responsibilities

• Designing and developing robust data pipelines and reporting solutions.
• Troubleshooting and resolving technical issues.
• Creating complex documentation and user support guides.

Skills

SQL

Python

Java

Scala

Data Modeling

Analytical Skills

Education

Bachelor's Degree in Computer Science

Applied Mathematics

Engineering

Tools

Azure Data Factory

Azure SQL

Azure Data Lake

Tableau Prep Builder

Informatica

DataStage

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

Date Posted: 05/13/2025
Req ID: 42772
Faculty/Division: VP - Research
Department: Ofc of Vice Pres, Research & Innovation
Campus:St. George (Downtown Toronto)
Position Number: 00057992

Description:

About us:

The Vice-President, Research & Innovation (VPRI) portfolio supports the University of Toronto as a top public research university in the world. Our mission is to create the most supportive environment possibleso that our researchers, innovators and learners can do what they do best — advance understanding and apply new knowledge. Our work supports, fosters and promotes the research and innovation culture and activities of our faculty, staff and students, along with our partner hospitals, funding sponsors, and partners in the public and private sector.

VPRI provides a full range of services including guidance to faculty, staff and students on funding opportunities, research agreement negotiation, oversight and accountability services including research accounting, environmental health and safety, innovation and entrepreneurship, partnerships, policies and procedures, and institutional awards and honours


Your opportunity:

As a Data Engineer within the Office of the Vice President, Research & Innovation, you will play a crucial role in advancing the university's data strategy. You will be responsible for designing and developing robust data pipelines, data marts, and reporting solutions using cloud platforms such as Microsoft Azure Data Factory. Your work will ensure efficient data integration and contribute to the success of data-driven initiatives across the university.

Your responsibilities will include:

• Planning and implementing components of IT related projects
• Developing task schedules in concert with project schedules
• Assessing and determining feasibility of programming requests and requirements
• Troubleshooting and resolving technical issues
• Writing complex technical code
• Designing, testing, and modifying programming code
• Designing and optimizing databases
• Creating complex and technical documentation and user support guides and training end-users on procedures and the use of supported IT systems

Essential Qualifications:

• Bachelor's Degree in Computer Science, Applied Mathematics, Engineering, or anacceptable combination of equivalent experience.
• Minimum five years of experience as an ETL developer.
• Experience with data warehouse projects and handling large, complex data sets.
• Proficiency in SQL and experience with MicrosoftAzure services (Azure Data Lake, Azure SQL, Azure Data Factory).
• Experience in automating workflows and monitoring data processes.
• Demonstrated expertise in data modeling and query performance tuning.
• Experience in building and managing data pipelines using Azure Data Factory.
• Experience with data transformation tools and techniques (e.g., mapping data flows)
• Experience analyzing results of data transformation outputs, conducting developer tests on transformations,and conducting UAT with stakeholders.
• Experience with data transformation tools and techniques.
• Ability to design, build, and maintain ETL pipelines for data warehouses.
• Exceptional analytical skills, showing fluency in SQL, Python, Java, or Scala.
• Knowledge of cloud platforms such as AWS, Azure, GCP.
• Ability to effectively communicate with both technical and non-technical audiences, as well as collaborate with cross-functional teams.

Assets (Nonessential):

• Understanding of machine learning capabilities.
• Experience with ETL applications such as Tableau Prep Builder, Informatica, DataStage, etc.
• Knowledge of Informatica is an asset.

To be successful in this role you will be:

• Adaptable
• Discerning
• Team player

Closing Date: 05/29/2025, 11:59PM ET
Employee Group: USW
Appointment Type: Budget - TermThis is a one (1) year Term role.
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: Administrative / Managerial
Recruiter: Anita Chooraman

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