Lead Data Engineer - Temporary Assignment up to 18 months

Municipal Property Assessment Corporation; Pickering; Hybrid; CAD 111,000 - 132,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

Municipal Property Assessment Corporation (MPAC) is seeking a Lead Data Engineer for a temporary assignment up to 18 months in Pickering, ON. You will lead the architecture, design and delivery of AWS-based data solutions, mentor Data Engineers, and drive scalable data pipelines across batch and real-time analytics. Competitive salary and a collaborative, inclusive environment.

Hybrid work options available, with a focus on performance, security and data governance. Closing date: Oct 22, 2026.

Qualifications

• Diploma or Degree in Computer Science, Engineering or related field.
• 7+ years of progressive development experience in a senior technical capacity.
• 3+ years of experience in an IT Team Lead capacity.
• Experience with AWS services (Lambda, Glue, S3, Redshift).
• Proficiency in Python, SQL, Groovy, PostgreSQL.
• Knowledge of Kubernetes, OpenSearch, Iceberg or Hudi.
• Experience with Apache Spark and Kafka.
• Strong communication, leadership and stakeholder management.

Responsibilities

• Lead architecture, design and delivery of AWS-based data solutions for reporting and analytics.
• Provide technical leadership and mentorship to Data Engineers.
• Design and optimize scalable AWS-native data pipelines (Redshift, Glue, Lambda, S3).
• Lead modern cloud data platforms ensuring scalability, security and cost efficiency.
• Establish data quality, governance, lineage and metadata standards.
• Oversee investigations, POCs and production issue resolution; monitor platform performance.

Skills

Leadership

Team leadership

Communication

Problem solving

Conflict resolution

Analytical thinking

Stakeholder management

Education

Diploma or Degree in Computer Science, Engineering or related field

Tools

AWS

Python

SQL

Groovy

PostgreSQL

Kubernetes

OpenSearch

Iceberg/Hudi

Spark

Kafka

Job description

Location: Pickering, ON, CA

Date: Oct 8, 2026

Type of Position: Temporary

Number of Positions: 1

Salary Min: $110,783.00

Salary Max: $132,157.00

Description: Do you want to be part of a team helping to strengthen every community across Ontario? Are you interested in seeing the importance of your work firsthand? Do you have a passion for big data and cloud computing – and know the benefit of using data to improve business practices?

Become a Lead Data Engineer - Temporary Assignment up to 18 months with MPAC

The Municipal Property Assessment Corporation (MPAC) is made up of a team of experts who understand local communities and assess every property in Ontario. What we do provides the very foundation that municipalities use to base the property taxes needed to pay for the services we use every day.

Equity, Diversity, Inclusion and Anti-Racism

MPAC is committed to Equity, Diversity, Inclusion and Anti-Racism. We are taking important steps towards ensuring that all voices are respected, valued and being heard. MPAC is dedicated to fostering an environment where employees can bring their full, unique and authentic selves and are inspired to do their best work.

Our Information Technology team works closely with each department across the business to design, build and deliver innovative solutions that help make MPAC an international leader in the property assessment industry. The way we think about technology is different, and our teams are proud to share their knowledge and contribute to meaningful, technology-enabled success stories that enhance operational intelligence and customer service delivery. We tackle complex problems collaboratively in an agile environment, and are committed to ensuring MPAC technology is consistently available, scalable, performance-based and secure. We’re a group of forward-thinking and talented professionals who stay ahead of the game by using open source technology, cutting-edge cloud computing, advanced analytics and predictive and machine learning models.

Job Description

What makes you great for this role?

You provide overall project coordination, team leadership and control of activities related to the elaboration, construction and transition of a diverse range of IT solutions. You are able to convey technical expertise and advice to management and stakeholders to leverage IT solutions and applications that will meet program/service goals and objectives.

We have:

• A team of highly skilled, dedicated and collaborative staff to work with
• Leadership that supports you
• An enterprise that embraces change
• A work environment that has flexible work locations (including hybrid), hours of work and overall employee wellness support

You have:

• Diploma or Degree in Computer Science, Engineering or related field
• 7+ years of progressive development experience in a senior technical capacity
  • Amazon Web Services (AWS) including Lambda, Glue, S3, Redshift and related cloud-native services
  • Python, SQL, Groovy, PostgreSQL
  • Kubernetes, OpenSearch, Apache Iceberg or Apache Hudi
  • Apache Spark, Kafka or similar streaming technologies
• Advanced knowledge of IT technology, tools, skills, techniques and methods
• 3+ years of experience in an IT Team Lead capacity
• Computer science and data engineering principles, including programming, data structures, algorithms, data modelling, data architecture and scalable data pipeline design.
• Modern software engineering and DataOps practices, including CI/CD, version control, automated testing, infrastructure as code, observability, monitoring and data quality.
• Designing cloud-native applications and modern data platforms using distributed processing, data lake/lakehouse architectures, APIs, event-driven design and messaging technologies.
• Core data engineering practices, including data ingestion, transformation, orchestration, storage, metadata management, data lineage and data governance.
• Effective conflict resolution, team building and client relationship management skills
• Analytical and interpretative reasoning skills to assess client needs and develop cost effective and efficient IT solutions
• Strong interpersonal and communication skills to communicate effectively to a wide variety of audiences

Nice to have:

• AWS, Data Engineering, Analytics, or Data Architecture certifications (or actively pursuing certification)
• Expertise in cloud computing architecture

What you will do:

• Lead the architecture, design, and delivery of AWS-based OLAP, data warehouse, and lakehouse solutions that enable enterprise reporting, advanced analytics, AI, and business intelligence capabilities.
• Provide technical leadership and mentorship to Data Engineers, establishing best practices for AWS cloud architecture, data modeling, performance optimization, and DataOps.
• Design, develop, and optimize scalable AWS-native data pipelines using services such as Redshift, Glue, Lambda, and S3 to support batch, streaming, and near real-time analytics workloads.
• Lead the implementation of modern cloud data platforms and analytical environments, ensuring scalability, reliability, security, and cost efficiency.
• Establish and govern enterprise standards for data quality, governance, lineage, metadata management, and security to deliver trusted and business-ready data assets.
• Lead technical investigations, proof-of-concepts, and the resolution of complex production issues while overseeing monitoring, observability, platform performance.

Additional Information:

• Requisition ID: 3189
• Job Type: Union
• Closing Date: October 22, 2026

Successful candidates will be required to undergo a background verification with Mintz Global Screening. By applying to this job posting, you are providing your consent to MPAC to share your name, email address and phone number with Mintz, to conduct the criminal and driver abstract check and for Mintz to disclose the results to MPAC, should you be the successful incumbent.

MPAC is committed to fostering an inclusive, accessible environment where all employees and members of the public feel valued, respected and supported. We are dedicated to building a workforce that reflect the diversity of the public and communities we serve.

Persons with disability who need accommodation in the application process or those needing job postings in an alternative format may email their request to [e-mail] .

We may use technology and automated tools to support recruitment and selection processes. All artificial intelligence (AI) outputs are reviewed and validated by our recruitment team.

We thank all applicants for their interest, however, only those selected for further consideration will be contacted.

Please note that MPAC prohibits employees from holding a current/valid real estate license and successful applicants must at least suspend their real estate licenses during their period of employment at MPAC as outlined in our Employee Code of Conduct.

Job advertisements for positions that have been designated bilingual will be posted in both English and French on our website. Positions that are not designated bilingual are not translated and are only posted in English on the English version of our website.