Description

The position supports Parks, Forestry & Recreation by providing decision‑makers with reliable evidence through the design and optimization of scalable data pipelines. The lead data engineer will transform raw data into actionable insights while ensuring robust governance across the data lifecycle.

Reporting to the Manager, Research and Analytics in the Policy and Strategic Planning Branch, the incumbent will supervise junior staff and champion best practices in coding, testing, and documentation. Work will be performed in a matrixed environment alongside domain experts in data enablement, analytics, program evaluation, operations, capital construction, technology transformation, and public engagement.

Key data‑engineering duties include implementing AWS‑based infrastructure (S3, Redshift, Kinesis, EMR, Glue, Lake Formation, CloudFormation), developing ETL/ELT pipelines with AWS Glue, DBT and Apache Spark, and using Python for large‑scale data processing. The role also involves designing efficient data models, building batch and real‑time streaming solutions, and applying data‑governance policies to maintain quality, privacy, and regulatory compliance.

People‑leadership responsibilities encompass supervising, motivating, and training the data‑engineering team, managing daily operations, scheduling, performance reviews, and handling grievances or disciplinary actions. The manager will also coordinate contracts with consultants, oversee external partnerships, and facilitate collaboration with internal and private‑sector stakeholders to collect and analyze data.

The senior engineer will contribute to long‑range planning, develop prototypes and proof‑of‑concept pipelines for predictive models, and establish procedures for scalable pipeline maintenance and governance. Additional duties include researching best practices, preparing briefing notes, managing the assigned budget, and delivering presentations and reports to City Council, committees, and the public.

• Design, build, and maintain scalable AWS data infrastructure (S3, Redshift, Kinesis, EMR, Glue, Lake Formation, CloudFormation).
• Develop and support ETL/ELT pipelines using AWS Glue, DBT, and Apache Spark.
• Write Python code for large‑scale data processing, transformation, and analysis.
• Create efficient data models to support analytics, machine learning, and reporting.
• Implement batch and real‑time streaming solutions with AWS Kinesis.
• Enforce data governance policies to ensure quality, privacy, and regulatory compliance.
• Lead, mentor, and evaluate a team of junior data engineers, managing performance and development.
• Oversee contracts and manage relationships with consultants, contractors, and external partners.
• Produce prototypes and proof‑of‑concept pipelines for predictive models and custom analyses.
• Manage the assigned budget, prepare reports, and present findings to Council and stakeholders.

Requirements

Candidates must hold a bachelor’s degree in Computer Science, Data Science, IT or a related field (master’s preferred) and possess extensive experience leading data‑engineering projects that support analytics, BI, data science, geospatial analysis, and machine learning. Required expertise includes AWS data services, Python, Apache Spark, ETL tools (Glue, DBT), and strong people‑leadership, communication, and strategic‑thinking skills.

Benefits

The City of Toronto is hiring a Senior Data Solutions Integrator (Data Engineering) on a 14‑month temporary contract (Job ID 61188) located at 55 John St. The role offers a salary between $113,683 and $155,216, with an ideal hiring zone of $126,856‑$137,539, Monday‑Friday, 35 hours per week, and non‑union status.

Training + Development

Interview process

Visa Sponsorship

Security clearance