Data Engineering Consultant

We are Canada's largest independent information technology services firm, and after 45+ years, we're still growing! Join Canada's largest IT Company as a Data Engineering Consultant, in our Financial Services Sector in Toronto.

This role is hybrid and requires you to be at our downtown Toronto office at a minimum 2 - 3 days per week - subject to change at any time.

We are seeking a highly skilled Data Engineer with strong experience in building and optimizing large-scale data platforms on cloud environments. The ideal candidate will design, develop, and maintain high-volume data pipelines and analytics solutions that support both operational and analytical workloads. This role requires deep expertise in modern data engineering practices, cloud-native data services, and scalable data architecture.

Your future duties and responsibilities • Design, build, and optimize high-volume data pipelines capable of processing millions of records daily across OLTP and OLAP environments. • Develop and maintain ETL/ELT workflows to support enterprise data integration and analytics use cases. • Architect and implement scalable cloud data solutions leveraging managed services within Google Cloud Platform (GCP). • Work with stakeholders across business and technology teams to translate requirements into efficient data solutions. • Optimize data models, query performance, and processing pipelines to ensure high performance and reliability. • Implement and manage data infrastructure using Infrastructure as Code (IaC) frameworks such as Terraform. • Collaborate with cross-functional teams to support data governance, data quality, and performance optimization initiatives. • Contribute to the design and implementation of streaming and real-time data processing architectures where required.

Required qualifications to be successful in this role • 7+ years of experience in data engineering and performance optimization for large-scale OLTP / OLAP applications. • Strong experience designing high-volume data pipelines processing millions of records daily. • Advanced knowledge of Google Cloud Platform (GCP) managed data services including:

o DataProc

o Dataflow

o BigQuery / DBT

o Cloud SQL

• Hands-on experience with modern cloud data warehouses such as GCP BigQuery or AWS Redshift. • Proficiency in Python, data processing frameworks, and ETL/ELT pipeline development. • Experience with Infrastructure as Code (IaC) practices using tools such as Terraform. • Strong problem-solving skills and the ability to communicate technical concepts clearly to both business and technical stakeholders.

Preferred / Nice to Have

• Experience with Azure Data Factory (ADF). • Knowledge of data streaming technologies such as Kafka, Spark Streaming, or similar frameworks. • Experience building real-time data pipelines and event-driven architectures.

**CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level, geographic market, experience and training, and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $95,000–$145,000. This role is an existing vacancy.

#LI-BN Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

At CGI, we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter.

To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our team—one of the largest IT and business consulting services firms in the world.