-
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 recent and 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.
-
Experience working with student data in higher education environment.
-
Experience developing data visualizations using Tableau dashboards for higher education.
-
Working knowledge of University of Toronto systems (Student Information Systems (ROSI), Degree Explorer, eMarks, Web Scheduler, eService, Slate).
-
Accountable
-
Articulate
-
Efficient
-
Meticulous
-
Proactive
-
Problem solver
