Data Engineer

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
• Communicator
• Discerning
• Team player

Closing Date: 05/29/2025, 11:59PM ET
Employee Group: USW 
Appointment Type: Budget - Term This 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.