Lead Data Engineer

freelance.ca; Toronto; Hybrid; CAD 110,000 - 150,000; Full time

Job summary

A global leader in technology consulting is seeking a Lead Data Engineer for a 6-month hybrid position based in Mississauga. The role involves providing technical leadership, implementing data strategies, and driving architectural decisions for cloud-based data solutions in the Pharmaceutical industry. Candidates should have over 10 years of experience with cloud platforms and expertise in Snowflake.

Qualifications

• 10+ years of experience in data warehousing and cloud platforms.
• Expertise in Snowflake development and optimization.

Responsibilities

• Provide technical leadership and drive data strategy.
• Implement Snowflake-based data warehouses with scalability and security.
• Automate workflows and optimize data processes using Python.

Skills

DBT

Python

Data integration

Analytical skills

Problem-solving skills

Job description

Job Offer : Lead Data Engineer

Location : Mississauga

Contract Duration : 6 months

Work Mode : Hybrid

Start Date : May 26th

Why Join Us?

The company is a global leader in technology consulting. With 9,600 experts worldwide, we guide our clients through digital transformation by developing innovative solutions. In Canada, we excel in IT and engineering. We collaborate with leading companies to tackle major technological challenges, putting innovation, collaboration, and excellence at the heart of our actions. Join a passionate and committed team ready to bring your ideas to life.

About the Role

On behalf of our client in the Pharmaceutical industry, Astek Canada is seeking a motivated Lead Data Engineer ready to take on new challenges.

Your 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.

Your Qualifications

Education / Experience :

• 10+ years of experience in data warehousing, cloud platforms, and data architecture.
• Expertise in Snowflake development, optimization, and administration.

Key Skills :

• 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.

Personal Qualities :

• Analytical and solution-oriented mindset.
• Team collaboration and teamwork skills.
• Autonomy and rigor in managing priorities.