Lead Data Engineer

Integrated Resources, Inc.; Mississauga; On-site; CAD 90,000 - 150,000; Full time

Job summary

A forward-thinking company is looking for a Lead Data Engineer to spearhead cloud data warehouse solutions and drive data strategy. This pivotal role involves overseeing the end-to-end data architecture while ensuring scalable and secure operations across various platforms including AWS and Snowflake. With a focus on enhancing system performance and implementing governance policies, the ideal candidate will lead transformative data initiatives in a dynamic environment. If you are passionate about shaping enterprise data architecture and driving data-driven transformations, this opportunity is perfect for you.

Qualifications

• 10+ years of experience in data warehousing and cloud platforms.
• Expertise in Snowflake development and optimization.
• Strong analytical and problem-solving skills.

Responsibilities

• Provide technical leadership for data strategy and architecture.
• Design and implement Snowflake-based data warehouses.
• Automate workflows and optimize data processes with Python.

Skills

Snowflake

Python

DBT

Data Architecture

Cloud Platforms

Data Governance

Data Quality

Analytical Skills

Job description

Job Summary:

• We are seeking a Lead Data Engineer with deep expertise in Snowflake and development to drive cloud data warehouse solutions and shape data strategy, integration, and governance.
• This role will oversee end-to-end data architecture, ensuring scalable, secure, and high-performance data operations across AWS, Snowflake, and other Client ecosystems.

Key Responsibilities:

• Provide technical leadership and collaborate with cross-functional teams to drive data strategy and architecture decisions.
• Consult, design, and implement Snowflake-based data warehouses with a focus on scalability, security, and performance.
• Enforce data architecture and governance policies for commercial toolchains.
• Support query performance tuning, data quality frameworks, and governance controls (e.g., masking, row-level security).
• Automate workflows and optimize data processes using Python scripting.

Required Skills & Experience:

• 10+ years of experience in data warehousing, cloud platforms, and data architecture.
• Expertise in Snowflake development, optimization, and administration.
• Proficiency in DBT, Python, and cloud data integration.
• Strong analytical and problem-solving skills with a business-driven approach.
• Experience in designing and leading enterprise-scale data solutions.

Note: This role offers an opportunity to lead data-driven transformations, enhance system performance, and shape enterprise data architecture in a dynamic environment.