Data Engineer – University of Toronto

Title of the Job: Data Engineer

Location: Toronto, ON

Job Description: Date Posted: 10/01/2024
Req ID: 39910
Faculty/Division: Operations and Real Estate Partnerships
Department: Inst Research and Data Governance
Campus: St. George (Downtown Toronto)
Position Number: 00045540Description:About us:The University’s Institutional Research and Data Governance (IRDG) office provides leadership and administrative support for the institution’s data strategy. The IRDG office’s mandate is to:– Provide reporting and analytics services within our distributed institutional research model: lead institution-wide analysis projects, provide training opportunities for divisional analysts, implement new analytics tools and platforms, and improve access to curated institutional datasets.
– Support external reporting of institutional data (SMA metrics, key performance indicators for governance, international rankings, data exchanges with peer institutions).
– Implement an institution-wide data governance program to support the University in strategically harnessing data to achieve institutional goals.
– Provide leadership and administrative support for the institution’s data strategy.Your opportunity:Under the direct supervision of the Manager, Data Engineering and Business Intelligence, the incumbent will be responsible for designing and developing data pipelines, data marts, and reporting solutions using cloud platforms, such as Microsoft Azure Data Factory. Ongoing oversight and change management of pipelines, and the integration of appropriate governance and best practices is required. This role involves working on data migration projects, integrating various data sources, and developing solutions that align with data models. Strong expertise in SQL is essential for building and optimizing queries. Additionally, the incumbent will be expected to ensure efficient data integration and contribute to the overall success of data-driven initiatives.Your responsibilities will include:

• Writing complex technical code
• Designing, testing, and modifying programming code
• Analyzing and writing programming code structures based on user requirements
• Evaluating programming code to ensure it has validity, compatibility, and that it meets appropriate standards
• Developing technical application implementation plans
• Commenting on programming code for the purposes of standardization and consistency
• Creating complex and technical documentation and user support guides

Essential Qualifications:

• Bachelor’s Degree in Computer Science, Applied Mathematics, Engineering or acceptable combination of equivalent experience.
• Minimum four years working experience as a database ETL developer.
• Experience with data warehouse type projects.
• Demonstrate experience working with large and complex data sets as well as experience analysing volumes of data.
• 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 and familiarity with Microsoft Azure services like Azure Data Lake, Azure SQL, and Azure Data Lake
• Experience in in automating workflows and monitoring data processes.
• Experience in building and managing data pipelines using AzureData Factory.
• Experience with data transformation tools and techniques (e.g., mapping data flows)
• Exceptional analytical skills, showing fluency in the use of tools such as MySQL and strong Python, Shell, Java, PHP, Informatica ETL language SQL programming skills.
• Ability to design, build, and maintain the business’s ETL pipeline for data warehouse.
• Demonstrate expertise in data modelling and query performance tuning on SQL Server, MySQL, Azure Plate forms.
• Demonstrated skills in automating workflows and monitoring data processes.
• Ability to resolve performance and data flow issues efficiently.

Assets (Nonessential):

• Ideal understanding of machine learning capabilities and how implement.
• Experience with Tableau, Domo or other business intelligence tools such as Informatica ETL is an asset.
• Ability to learn fast and proven track of continuous applied learning.
• Knowledge of Informatica is an asset.

To be successful in this role you will be:

• Cooperative
• Insightful
• Intuitive
• Motivated self-learner
• Persuasive

Closing Date: 10/15/2024, 11:59PM ET
Employee Group: USW
Appointment Type: Ancillary Operations
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: Engineering / TechnicalLived 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 StatementThe 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 .Accessibility StatementThe 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 .

Company Name: University of Toronto

Salary: $79874 per year

Apply for the job!