Data Engineer

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.
• 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 - 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. 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 a culture of belonging that increases our capacity to effectively address and serve the interests of our global community. We strongly encourage applications from Indigenous Peoples, Black and racialized persons, women, persons with disabilities, and people of diverse sexual and gender identities. We value applicants who have demonstrated a commitment to equity, diversity and inclusion and recognize that diverse perspectives, experiences, and expertise are essential to strengthening our academic mission.

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 uoft.careers@utoronto.ca.