Data Solutions Engineer

Date Posted: 10/18/2024
Req ID: 40196
Faculty/Division: Ofc of the Chief Information Officer
Department: Academic, Research & Collaborative Tech
Campus: St. George (Downtown Toronto)
Position Number: 00051928
About us:
The Enterprise Academic, Research & Collaborative Technologies (ARC) group is a partnership between the Chief Information Officer's (CIO) division and the Centre for Teaching Support & Innovation (CTSI).
ARC is a central department responsible for all matters pertaining to the development, operation, maintenance and effectiveness of core teaching and learning systems, research systems, and enterprise collaborative technologies at U of T. Included within these responsibilities are the academic toolbox (the learning management system and associated applications), web hosting services (CMS), collaborative applications (i.e., MS Teams), enterprise video-mediated applications (i.e. Zoom), and generative artificial intelligence solutions (i.e. Copilot). This responsibility includes vendor relationship management with both for-profit suppliers as well as non-profit and consortium partners. ARC also serves as the main connector between the CIO's portfolio and library technology services.
Your opportunity:
The Data Solutions Engineer reports to the Senior Manager, Academic Applications & Analytics within the Academic Research & Collaborative Technologies unit. The primary focus of this position is to serve as the technical lead for the design and implementation of enterprise-level data solutions that enable data extraction, transformation and modelling in support of a variety of academic, operations and research initiatives. This role will ensure that technical solutions and architectures are built reliably, are optimized for scale and meet enterprise security standards. The successful incumbent will act as an important contributor to strategies for managing the University's growing learning records store, enriching the institutional data repository and powering the development of new learning analytics dashboards.
Your responsibilities will include: Developing and implementing architectural framework for highly complex and confidential university-wide IT systemReconciling business requirements with information architecture needs for highly complex system integrationConducting data modelling for business system analysisAnalyzing and configuring highly complex enterprise applications and servicesDeveloping, testing, and modifying programming codePlanning, implementing and operating IT systems independentlyAdvising on cost, feasibility and impact of different implementation solutionsEssential Qualifications: Bachelor's Degree or acceptable combination of equivalent experience.8+ years of experience as a Data Architect/Data Engineer with a demonstrated ability in data modelling, ETL pipelines, data integration and data architecture to design, develop and implement enterprise big data solutions5+ years of experience in large scale technology architecture, operations and design-related disciplines3+ years of experience with SQL and managing large data sets using relational databases (MySQL, SQL Server, PostgreSQL, etc.)3+ years of concrete programming and scripting language experience (e.g. Python, Java) with understanding of SDLC principlesStrong understanding and experience implementing Azure and AWS cloud computing concepts, architectures, and services.Knowledge and experience building CI/CD pipelines using tools such as Jenkins, AWS Developer Tools and Azure DevOps to automate testing, building, and deploying infrastructure and application code using IaC practices.Hands on experience with big data technologies including Spark, Hadoop, Hive, HDFS, PythonBusiness information requirement analysis experience with a strong understanding of project management principlesSolid experience with data privacy and security practices, metadata management, data governance and access controls within an enterprise data management frameworkExpert level skill with SQLBuilding ETL pipelines for large-scale data extraction, transformation and partitioningExpert data modelling and database design skills (both dimensional and relational)Proficient with business intelligence and reporting/analytics tools (e.g. Tableau, PowerBi) to analyze dataTechniques for detecting and addressing data quality issuesInteracting with middleware (API gateways)Writing complex, highly-optimized SQL and Python to interact with large data sets as needed for data engineering, modeling and processingExcellent analytical and problem resolution skillsExcellent written and verbal communications skills at both a technical and business level, able to build and foster positive relationships with highly dispersed and dynamic teamsAssets (Nonessential): AWS/Azure Certified Solutions Architect Professional certification and/or other AWS/Azure professional certificationsTo be successful in this role you will be: CooperativeMotivated self-learnerProceduralResourcefulTeam playerClosing Date: 11/01/2024, 11:59PM ET
Employee Group: USW
Appointment Type: Budget - Continuing
Schedule: Full-Time
Pay Scale Group & Hiring Zone: USW Pay Band 18 -- $114,486. with an annual step progression to a maximum of $146,408. Pay scale and job class assignment is subject to determination pursuant to the Job Evaluation/Pay Equity Maintenance Protocol.
Job Category: Information Technology (IT)
Recruiter: Khristen Sivaramalingam
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 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.
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.

#J-18808-Ljbffr