Data Solutions Engineer

University of Toronto

Oct 19

Applications are closed

Job
Full-time
Senior Level
Data
IT & Cybersecurity
Toronto

Requirements

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 solutions
5+ years of experience in large scale technology architecture, operations and design-related disciplines
3+ 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 principles
Strong understanding and experience implementing Azure and AWS cloud computing concepts, architectures, and services. This includes but is not limited to AWS S3, AWS Lambda, AWS Glue, AWS Athena, AWS SQS, AWS Kinesis, AWS Redshift, AWS EMR, AWS ECS, Azure Data Factory, Azure Data Lake Analytics, Azure Databricks and Azure Synapse Analytics
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, Python
Business information requirement analysis experience with a strong understanding of project management principles
Solid experience with data privacy and security practices, metadata management, data governance and access controls within an enterprise data management framework
Expert level skill with SQL
Building ETL pipelines for large-scale data extraction, transformation and partitioning
Expert data modelling and database design skills (both dimensional and relational)
Proficient with business intelligence and reporting/analytics tools (e.g. Tableau, PowerBi) to analyze data
Techniques for detecting and addressing data quality issues
Interacting with middleware (API gateways)
Writing complex, highly-optimized SQL and Python to interact with large data sets as needed for data engineering, modeling and processing
Excellent analytical and problem resolution skills
Excellent written and verbal communications skills at both a technical and business level, able to build and foster positive relationships with highly dispersed and dynamic teams

Responsibilities

Developing and implementing architectural framework for highly complex and confidential university-wide IT system
Reconciling business requirements with information architecture needs for highly complex system integration
Conducting data modelling for business system analysis
Advising on data structure designs
Analyzing and configuring highly complex enterprise applications and services
Developing, testing, and modifying programming code
Planning, implementing and operating IT systems independently
Advising on cost, feasibility and impact of different implementation solutions

FAQs

What is the deadline for application submissions?

The closing date for applications is 11/01/2024, at 11:59 PM ET.

Where is the position located?

The position is located at the St. George campus in Downtown Toronto.

What is the pay scale for this position?

The pay scale for this position is USW Pay Band 18, starting at $114,486 with annual step progression up to a maximum of $146,408.

What qualifications are required for this role?

Essential qualifications include a Bachelor’s Degree or equivalent experience, 8+ years as a Data Architect/Data Engineer, experience with SQL and big data technologies, and knowledge of cloud computing concepts and services like Azure and AWS.

Is there an opportunity for professional certification support?

Yes, candidates with AWS/Azure Certified Solutions Architect Professional certification or other AWS/Azure professional certifications are considered assets, indicating support for professional development.

What kind of experience is necessary for this position?

The role requires 8+ years of experience in data architecture and engineering, along with experience in large-scale technology architecture, data modeling, ETL pipelines, and building CI/CD pipelines.

What are the primary responsibilities of the Data Solutions Engineer?

The responsibilities include developing architectural frameworks, conducting data modeling, advising on data structure designs, and planning and implementing IT systems.

Are there any preferred personal attributes for this role?

Preferred personal attributes include being a communicator, cooperative, motivated self-learner, procedural, resourceful, and a team player.

How does the university view diversity in the hiring process?

The university encourages candidates from Indigenous, Black, racialized and 2SLGBTQ+ communities, persons with disabilities, and other equity-deserving groups to apply, considering their lived experiences in the hiring process.

University of Toronto

1-10

Employees

Mission & Purpose

Founded in 1827, the University of Toronto is Canada’s top university with a long history of challenging the impossible and transforming society through the ingenuity and resolve of our faculty, students, alumni, and supporters. We are proud to be one of the world’s top research-intensive universities, bringing together top minds from every conceivable background and discipline to collaborate on the world’s most pressing challenges. As a catalyst for discovery, innovation, and progress, we prepare our students for success through an outstanding global education and commitment to inclusive excellence. The ideas, innovations, and actions of more than 660,000 graduates advance U of T’s impact on communities across the globe.