University of Toronto
Data Engineer (2-year term)
Old Toronto
Shift, Voluntary
1 month ago
Job Description
Date Posted: 10/25/2024
Req ID: 40336
Faculty/Division: Faculty of Arts & Science
Department: Acceleration Consortium
Campus: St. George (Downtown Toronto)
Position Number: 00057089Description: 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.The Acceleration Consortium (AC) at the University of Toronto (U of T) is leading a transformative shift in scientific discovery that will accelerate technology development and commercialization. The AC is a global community of academia, industry, and government that leverages the power of artificial intelligence (AI), robotics, materials sciences, and high-throughput chemistry to create self-driving laboratories (SDLs), also called materials acceleration platforms (MAPs). These autonomous labs rapidly design materials and molecules needed for a sustainable, healthy, and resilient future, with applications ranging from renewable energy and consumer electronics to drugs. AC Staff Scientists will advance the infield of AI-driven autonomous discovery and develop the materials and molecules required to address society's largest challenges, such as climate change, water pollution, and future pandemics.The Acceleration Consortium received a $200M Canadian First Research Excellence Grant for seven years to develop self-driving labs for chemistry and materials, the largest ever grant to a Canadian University.Your opportunity: Reporting to the Executive Director, Acceleration Consortium and working closely with the (Senior) Research Associates, the Data Engineer plays a pivotal role in managing and optimizing our data infrastructure to support these high-impact research projects. The Data Engineer will be responsible for designing, implementing, and maintaining robust ETL/ELT pipelines that ensure the efficient flow of data from various sources to data warehouses and research databases.Your responsibilities will include:
- Reconciling business requirements with information architecture needs for highly complex system integration
- Analyzing and optimizing database software
- Developing and maintaining quality control procedures
- Analyzing, recommending, and designing highly complex software architecture
- Designing, testing, and modifying programming code
- Leading and planning IT projects
- Analyzing, recommending and designing technical solutions for highly complex IT problems
- Serving as a resource to others by providing (non-supervisory) job-related guidance
Essential Qualifications:
- Bachelor's Degree (Master's Degree preferred) in Computer Science, Information Technology, Data Engineering, or a related field or acceptable combination of equivalent experience.
- Minimum five years recent and relevant Data Engineer experience with strong background in ETL/ELT processes.
- Experience with data pipeline tools and platforms (e.g., Apache Airflow, AWS Glue, Talend, etc.).
- Proficiency in SQL, Python, and/or other programming languages commonly used in data engineering as well as data transformation tools (e.g. DBT).
- Solid understanding of database management systems (RDBMS, NoSQL, etc.) and data warehousing solutions (e.g., AWS Redshift, Google BigQuery, Snowflake, Databricks).
- Familiarity with cloud computing platforms (e.g. AWS, Azure, GCP) and containerization technologies (Docker, Kubernetes).
- Strong problem-solving skills and the ability to work in a fast-paced, research-driven environment.
- Excellent communication skills, with the ability to collaborate effectively with cross-functional teams.
Assets (Nonessential):
- Experience in a research or academic environment, particularly in handling large and complex scientific datasets.
- Knowledge of data modeling, schema design, and data architecture best practices.
- Familiarity with data visualization tools (e.g., Tableau, Power BI) is a plus.
To be successful in this role you will be:
- Accountable
- Communicator
- Efficient
- Insightful
- Problem solver
- Team player
Closing Date: 11/15/2024, 11:59PM ET
Employee Group: USW
Appointment Type: Grant - Term
Schedule: Full-Time
Pay Scale Group & Hiring Zone:
USW Pay Band 16 -- $101,539. with an annual step progression to a maximum of $129,851. 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: Ann YangLived 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 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 .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 .
University of Toronto