Data Engineer

at  University of Toronto

Date Posted: 11/13/2024
Req ID: 40656
Faculty/Division: Faculty of Arts & Science
Department: Office of Budget, Planning and Finance
Campus: St. George (Downtown Toronto)

ABOUT US:

The Faculty of Arts & Science is the heart of Canada’s leading university and one of the most comprehensive and diverse academic divisions in the world. The strength of Arts & Science derives from our combined teaching and research excellence in the humanities, sciences and social sciences across 29 departments, seven colleges and 46 interdisciplinary centres, institutes and programs.
We can only realize our mission with the dedication and excellence of engaged staff and faculty. The diversity of opportunities and perspectives within the Faculty reflect the local and global landscape and the need for curiosity, innovative thinking and collaboration. At Arts & Science, we take pride in our legacy of innovation and discovery that has changed the way we think about the world.

ESSENTIAL QUALIFICATIONS:

• Bachelor’s Degree with a background in statistics, mathematics, computer science or an acceptable equivalent combination of education and experience.
• Minimum four (4) years of relevant experience supporting data-driven decision making by conducting detailed data analysis and using large datasets, preferably in a post-secondary education or research-intensive institution.
• Advanced knowledge and experience writing complex SQL queries and procedures.
• Experience in the creation and debugging of databases.
• Strong working and conceptual knowledge and experience of building and maintaining physical and logical data models.
• Experience in automating workflows and monitoring data processes. Demonstrated skills in automating workflows and monitoring data processes.
• Experience with data transformation tools and techniques (e.g., mapping data flows)
• Demonstrate expertise in data modelling and query performance tuning on SQL Server, MySQL, Azure Plate forms. Experience in building and managing data pipelines using AzureData Factory.
• Experience with Business Intelligence tools such as Tableau or Power BI. Experience working with Azure Data Studio and Power BI.
• Excellent knowledge of student information systems or other relational databases.
• Experience supporting machine learning projects, by creating custom training dataset, automating data refresh pipelines and implementing modeling scripts.
• Strong technical skills in understanding of relational databases and ability to create scripts for performing batch uploads and in creating scripted procedures utilizing programming skills in Python, Shell, Java, PHP, and SQL.
• Strong oral and written communications skills to probe for information to establish needs and respond to request, and communicate data query requirements to other data users or Data Analyst.
• Ability to design, build, and maintain the business’s ETL pipeline for data warehouse.
• Ability to resolve performance and data flow issues efficiently.
• Ability to work with subject matter experts to develop new datasets and database schemas
• Ability to work independently and as part of a team.
• Ability to make meaningful stories from data.
• Excellent analytical and problem solving skills.
• Ability to work well under pressure and meet competing priorities with the highest level of accuracy.
• Demonstrate a commitment to equity, diversity, inclusion and the promotion of a respectful and collegial learning and working environment.

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

YOUR RESPONSIBILITIES WILL INCLUDE:

• Developing and implementing database testing plans, scenarios and environments
• Assessing and determining methodologies for data retrieval and manipulation
• Analyzing and writing program scripts to extract, reformat and analyze data
• Conducting detailed analysis of system performance to inform management decision making
• Developing database conversion and migration strategies and plans
• Creating complex and technical documentation and user support guides
• Delivering presentations on financial data and models to clients and/or senior management
• Serving as a resource on specific issues to a group of specialists

TO BE SUCCESSFUL IN THIS ROLE YOU WILL BE:

• Accountable
• Articulate
• Efficient
• Meticulous
• Proactive
• Problem solver
  Closing Date: 11/21/2024, 11:59PM ET
  Employee Group: USW
  Appointment Type: Budget - Continuing
  Schedule: Full-Time