Lead Data Engineer

freelance.ca; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

An innovative firm is seeking a Lead Data Engineer to drive data strategy and architecture decisions in the Pharmaceutical industry. This role involves providing technical leadership, implementing Snowflake-based data warehouses, and optimizing data processes through Python scripting. Join a passionate team dedicated to tackling major technological challenges and delivering impactful solutions. If you have a strong analytical mindset and extensive experience in data warehousing, this is a fantastic opportunity to make a significant impact in a collaborative environment.

Qualifications

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

Responsibilities

• Provide technical leadership and collaborate on data strategy.
• Consult, design, and implement Snowflake-based data warehouses.
• Automate workflows and optimize data processes using Python.

Skills

DBT

Python

Cloud Data Integration

Analytical Skills

Problem-Solving Skills

Education

10+ years of experience in data warehousing

Expertise in Snowflake development

Tools

Snowflake

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.