Data Engineer

Data Engineer

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)

Description : About us :

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.

Your opportunity :

Under the Director of Planning, Data & Analysis, the incumbent will be responsible for the advancement and maintenance of the Faculty’s data infrastructure.

This will include but not be limited to design, development and optimizing of databases by developing programming communication protocols between systems to automate ETL and data refresh pipelinesand analyzing problems and applying fixes to the non-production and production environments.

The incumbent will also be involved in support the Faculty’s machine learning efforts by supporting the creation of training datasets and implementation of models.

The incumbent will utilize a variety of coding languages such as python, SQL and java to conduct complex database development, migration and maintenance.

The incumbent will utilize software like MS Azure Data Studio, PostgreSQL, MS Azure Data Factory and SPSS to support the Faculty’s data infrastructure.

The position will work closely with a number of team members to develop data-driven insights and visualizations in support of Faculty of Arts and Science's strategic and operational objectives.

Key focus areas will include scoping and requirements gathering, data management, data analysis, dashboard development and report generation for a variety of audiences, as well as contributions to the database structure, designs, schemas and documentation.

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

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.

Assets (Nonessential) :

• 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).

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

Pay Scale Group & Hiring Zone :

USW Pay Band 12 $79,874. with an annual step progression to a maximum of $102,147. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation / Pay Equity Maintenance Protocol.

Job Category : Finance / Budget / Planning / Audit

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.

buttontext00b26598368a4abe a border : 1px solid transparent; .buttontext00b26598368a4abe a : focus border : 1px dashed #25355a !important; outline : none !important;

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.

As part of your application, you will be asked to complete a brief Diversity Survey. This survey is voluntary. Any information directly related to you is confidential and cannot be accessed by search committees or human resources staff.

Results will be aggregated for institutional planning purposes. For more information, please see http : / / uoft.me / UP .

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 [email protected] .

Job Segment : Database, Data Analyst, Information Systems, Data Management, Data Warehouse, Technology, Data