Data Engineer

Press Tab to Move to Skip to Content Link

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

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

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 possible so 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 an acceptable 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 Microsoft Azure 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, Data Stage, 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: US…