Manager ETL

Main Functions

The Manager, on-prem and Cloud ETL (Azure Data Integration) leads the strategy, delivery, and operational reliability of enterprise ETL/ELT pipelines across the Azure data ecosystem. This role manages a team of ETL developers (data engineers) responsible for ingesting, transforming, and integrating data to support analytics, reporting, and data science workloads.

The role combines people leadership, technical oversight, and operational accountability, with a strong focus on modern, scalable, and secure Azure‑native data integration as well as traditional SQL database management for our on-premises legacy architecture.

This role is accountable for ETL platform outcomes and team performance, rather than serving as a primary individual contributor.

Leadership & Strategy:

• Lead, mentor, and develop a team of ETL and data engineering professionals, including performance management, workload planning, and skills development.
• Refine and define the ongoing ETL/ELT architecture and modernization roadmap, with a focus on Azure-native services.
• Establish development standards, code review processes, and engineering best practices.
• Partner with Enterprise Architecture, Cloud Infrastructure, and Data Governance teams to align ETL platforms with enterprise standards, while owning day‑to‑day ETL architecture and implementation decisions.

Azure-Focused ETL & Data Engineering:

• Architect and oversee ETL/ELT solutions using Azure Data Factory (ADF), Fabric Data Factory (FDF), Azure Synapse Pipelines, Fabric Pipelines, and other Azure data services.
• Modernize legacy ETL platforms (existing on-prem SSIS) into cloud-native pipelines.
• Implement ingestion frameworks for structured, semi-structured (JSON, XML, .csv ), and unstructured data.
• Work with the Analytics and Reporting team to optimize pipeline performance, reliability, and cost monitoring/management using Azure Monitor, Log Analytics, and cost management tools.
• Ensure pipelines follow cloud engineering best practices including parallelization, metadata-driven orchestration, and parameterization.

Data Quality, Governance & Security:

• Implement data validation, monitoring, and automated quality checks inside the ETL pipelines.
• Ensure ETL pipelines operationalize and comply with enterprise data governance, lineage, and metadata standards.
• Work with security to enforce Azure Role Based Access Control, managed identities, encryption, and network security principles.
• Maintain data privacy compliance (PII handling, data masking, retention policies).

Operational Excellence:

• Oversee daily operation of cloud ETL pipelines, including scheduling, monitoring, and incident management.
• Maintain and continuously improve SLAs for data availability, timeliness, and pipeline reliability, including proactive reduction of failures, reprocessing time, and operational incidents.
• Implement CI/CD for ETL code using Azure DevOps Repos and Pipelines.
• Drive automation to reduce manual operations and improve pipeline recoverability.

Cross-Functional Collaboration:

• Work with analytics, reporting, data science, and application teams to understand their data needs and design scalable solutions.
• Coordinate with business stakeholders to prioritize work based on enterprise value.
• Provide technical guidance on integrating new systems and onboarding new data sources.

 

Education:

• Bachelor’s degree in computer science, Information Systems, Data Engineering, or a related discipline.
• Master’s degree preferred (optional).

Technical skills

Required

• ETL/ELT design patterns, data modeling (dimensional and data vault), and database fundamentals
• Strong SQL knowledge.
• Familiarity with Delta Lake, Spark, and workflows
• Understanding of Azure networking, security, and identity principles
• Experience with monitoring and observability tools (Azure Monitor, Log Analytics)

An asset

• Project and delivery management experience, including backlog planning, dependency management, and coordination using tools such as Azure DevOps, MS Project, or MS Planner

Personal abilities

Required

• Excellent verbal and written communication skills
• Strong leadership, mentoring, and stakeholder management abilities
• Ability to manage multiple priorities, deadlines, and cross-team collaboration and dependencies
• Problem-solving mindset and very strong analytical skills

Organization

Lallemand is a privately held Canadian company founded in the late 19th century, which develops, produces, and markets microorganisms for various markets. The administrative offices of the parent company are in Montreal, Canada. Today, Lallemand employs more than 6,500 people working in more than 45 countries on 5 continents.

Lallemand's corporate division encompasses all of the support services offered to our branches. Its goal is to optimize internal processes, ensure that your operation is running smoothly, and that your strategy is well thought-out.

Our corporate branch's head office is located in Montreal, Canada, and relies on a team that specializes in: Management; Finance and accounting; Engineering; Research and Development (R&D); Human Resources (HR); and Information Technology (IT). If you want to help bring enthusiasm, collaboration and innovation to our workplace, we'd love to get to know you!

Please take note that accommodations will be provided in all parts of the hiring process. Applicants need to make their needs known in advance.