Data Engineer Lead Developer

CG Consulting Group; Toronto; Hybrid; CAD 100,000 - 125,000; Full time

Job summary

A leading consulting firm in Toronto is looking for a collaborative and resourceful Data Engineer Lead Developer. You will drive the design and delivery of scalable data solutions, mentor junior engineers, and play a pivotal role in modernizing the data platform. The ideal candidate has over 10 years of experience in data engineering and strong skills in SQL, Python, and Snowflake. This role offers a hybrid work model with a competitive rewards package.

Benefits

Base compensation

Annual bonus eligibility

Health benefits

Competitive vacation package

Career development opportunities

Qualifications

• 10+ years of professional experience in data engineering with a proven track record.
• Deep expertise in relational, big data, and NoSQL databases.
• Expert level coding skills in SQL, Python, Shell, and Terraform.

Responsibilities

• Drive the design, development, and delivery of scalable data solutions.
• Lead the development of complex, high-performance data pipelines.
• Mentor and support Data Engineers and Associate Data Engineers.

Skills

Data engineering

SQL

Python

Terraform

Data modeling

Data visualization

Tools

Snowflake

PostgreSQL

MongoDB

AWS Managed Airflow

dbt

Job description

Overview

Data Engineer Lead Developer: Our client is looking for a collaborative and resourceful Data Engineer Lead for their IT Data Engineering Delivery team. You are dedicated, naturally inquisitive and comfortable in a fast-paced environment. This role will be part of the Information Technology Enterprise Data Services Group. You will be responsible for leading the architecture, design, analysis, and implementation in a successful, experienced team. You’ll apply your depth of knowledge and expertise with both modern and legacy data platforms to develop data ecosystems that meet business requirements and align with the enterprise architecture goals and standards. The team has embarked on an exciting journey to modernize, craft, and build a next generation data platform Snowflake to support the growing data needs of the business and to enable the capabilities of AI and GenAI to drive business value. This role reports to the Senior Data Engineering Manager.

Location: Markham; Work Model: Hybrid – 3 days/week onsite. Perm / FT - Salary + bonus and benefits.

What You Will Do

• As a Data Engineer Lead, you will play a pivotal role in driving the design, development, and delivery of scalable data solutions across the enterprise.
• Advocate for engineering standards and process efficiencies to ensure high-quality, timely delivery.
• Lead the development of complex, high-performance data pipelines using tools like dbt Core/Cloud.
• Help design, and review data models (conceptual, logical, physical) that meet business and technical requirements.
• Own and maintain robust, reusable code in SQL, Python, Shell, and Terraform scripts.
• Develop detailed low-level engineering solution design documents to guide implementation and ensure alignment with technical standards.
• Create and review data test plans to ensure alignment with solution requirements.
• Advocate importance of data catalogs, data governance and data quality practices.
• Conduct root cause analysis and implement effective solutions for technical data issues.
• Lead scrum ceremonies and foster an agile mindset across the team.
• Mentor and support Data Engineers and Associate Data Engineers, elevating engineering standards and practices.
• Collaborate cross-functionally to deliver high-quality data products with strong customer-centric focus.
• Drive technical presentations and provide constructive feedback on data designs and processes.
• Plan and execute data release activities to ensure smooth and high-performance delivery.
• Support talent acquisition by designing interview challenges, conducting interviews, and contributing to hiring decisions.

What you’ll bring

• 10+ years of professional experience in data engineering, with a proven track record of delivering 5+ high-impact data projects from inception to warranty.
• Deep expertise in relational databases (Snowflake, PostgreSQL, Amazon Aurora), big data platforms (Hadoop), and NoSQL databases (MongoDB).
• Advanced proficiency in data visualization tools such as Snow sight, Streamlit, Qlik, and SAP Business Objects.
• Expert level coding skills in SQL, Python, Shell, and Terraform, with a focus on maintainability and performance.
• Experience with data orchestration and pipeline tools, including Zena and AWS Managed Airflow.
• High resilience and adaptability in ambiguous or high-pressure environments.
• A customer-first mindset, using data-driven insights to deliver impactful solutions.
• Strong collaboration and communication skills, with the ability to lead teams and influence stakeholders.
• Insurance knowledge is an asset — ability to foundationally understand complex business processes driving technical systems.
• Prior experience in AI/ML model operationalization is an asset.

Nice to Have Certifications

• SnowPRO Core
• SnowPRO Advanced Data Engineer (DEA-C01)
• SnowPRO Advanced Data Engineer (DEA-C02)
• dbt Developer
• AWS Cloud Practitioner

What you’ll get

• Compelling rewards package including base compensation, eligibility for annual bonus, retirement savings, share plan, health benefits, personal wellness, and volunteer opportunities.
• Outstanding Career Development opportunities.
• We’ll support your professional development education.
• Competitive vacation package with the option to purchase 5 extra days off per year.
• Corporate wellness programs to support our employees’ physical and mental health.