As a Data Engineer, you will help develop a product that is part of the City’s Road Safety Plan. You’ll make it easier to discover and act on traffic and collision data, making Toronto’s streets safer for all road users.The existing product was built on assumptions and user needs. The team continues to incorporate enhancements to build a robust platform while integrating existing legacy systemsThis project consists of two main components:•a data platform built on Apache Airflow and PostgreSQL, which automates intake and processing of transportation-related data from both internal and external data sources;•a web application built on node.js, Vue, and Mapbox GL, which helps users more easily access, analyze, and manage that data.This project aims to reimagine the way Transportation Services manages data about road usage and safety across the City. We're successful when we help our users reduce manual overhead, see all the data in one place, and build a shared understanding of definitions and processes.AdvantagesIf you love to collaborate with product managers, developers and product owners then this is the right role for you!ResponsibilitiesYou will be responsible for:-Conceive and design product features and flow-Collaborate with product manager, product owner, designer and stakeholders-Conduct generative research to guide evolution of product enhancements•working with the team to align data platform development with product goals and vision, and to offer technical feedback on designs;•working with the Web Application Developer to tailor our database schema to application needs;•learning about the types of collision and traffic volume data used at the City, and helping make decisions on how best to represent and manage that data;•deciding what, how, and when to automate data management tasks;•coordinating with Technology Services to evolve our AWS infrastructure as needed;•planning migrations and upgrades as needed;•working with Data & Analytics to turn experimental models, analyses, and processes into data products;•working with Open Data to build data products that meet broader organizational and public needs.QualificationsWhat do you bring to this role?Technical•You have designed, built, and maintained production data infrastructure.•You have experience using relational databases (e.g. PostgreSQL, MySQL, etc.)•You're comfortable writing scripts to work with data (e.g. in bash, Python, SQL, etc.)•You've automated and managed data pipelines / workflows (e.g. using Airflow, Luigi, etc.)•You've dealt with data migrations, and can safely and confidently update data models as product needs evolve.•You have at least some exposure to DevOps tools and concepts (e.g. CI/CD, infrastructure-as-code, AWS / other cloud platforms, etc.)Experience on many projects with varying team compositions is valuable, probably spanning 5- 10yearsYou’re a highly collaborative, skilled communicatorWorking with technical and non technical usersYou’re adaptable and resilientYou’re motivated to use you skills to make life better for Toronto residentsExperience working with transportation and/or spatial data is an asset.Experience working in government is not necessarySummaryOur client values an environment that is not only free from discrimination, but that is also proactively inclusive. We encourage individuals from under-represented groups to apply.If you are passionate about data, apply now to be considered!Randstad Canada is committed to building a diverse workforce reflective of the diversity of Canada. As a result, we promote employment equity and encourage candidates, especially those who identify as a woman, an Aboriginal person, a person with a disability or a member of a visible minority group, and any others who may contribute to the diversification of our workforce, to apply.Randstad Canada is also committed to developing an inclusive, barrier-free selection processes and work environments.If contacted in relation to a job opportunity, you should advise your Randstad Representative or your local Randstad branch in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner.Information received relating to accommodation measures will be addressed confidentially.For all feedback on equity and accommodation needs, please contact your local Randstad Canada Branch.