Senior Data Engineer

ACI Worldwide; Montreal (administrative region); Hybrid; CAD 90,000 - 135,000; Full time

Benefits offered by this job

RRSP with up to 5% employer matching

Hybrid work model for corporate roles

Employee stock ownership program

Career growth through real development

Transit pass reimbursement

Minimum 4 weeks of vacation from day 1

Job summary

Pomerleau is building a modern data platform in Montreal to support BI, AI, and analytics. As a Senior Data Engineer, you will own the data foundation end to end—from ingesting source data to producing clean, canonical datasets used by analysts and dashboards.

You will work hands‑on with Microsoft Fabric, manage pipelines across bronze, silver, and gold, and partner with analytics teams to deliver reliable data assets in a hybrid work environment.

Qualifications

• Senior-level data engineering experience across heterogeneous systems.
• Hands-on with Microsoft Fabric (lakehouses, warehouses, notebooks, pipelines, semantic models).
• Strong SQL and data transformation skills (cleaning, incremental loads, curated tables).
• Experience collaborating with analytics and BI developers.

Responsibilities

• Design, build, and maintain scalable data pipelines and models across bronze, silver, and gold layers.
• Provide cleaned, transformed data and curated tables for semantic models and dashboards.
• Migrate legacy pipelines to Fabric and manage DevOps deployments.
• Monitor pipelines for quality, performance, and reliability; apply governance standards.
• Populate metadata and lineage in the data catalog.

Skills

Senior‑level data engineering

Generalist mindset

Tools

Microsoft Fabric

Azure DevOps

Git

dbt

Airflow

Job description

Ready to build your career? We want to hear from you.

We are building a modern data platform to power our Business Intelligence, AI, and analytics initiatives. As a Senior Data Engineer, you will own the data foundation end to end: ingesting from source systems, transforming data into clean and canonical layers, and delivering the reliable, reusable data assets our analysts and BI developers depend on. This is a hands‑on, delivery‑focused role for someone who enjoys bringing structure and standards to a data practice that is ramping up.

What you will do

• Design, build, and maintain scalable pipelines and data models across the bronze, silver, and gold layers, used by our BI, AI, and analytics teams.
• Provide the cleaned and transformed data and curated tables that analysts and BI developers use to build their semantic models and dashboards.
• Engineer source data once into canonical objects that downstream teams reuse, eliminating duplicated per-project loads.
• Develop and deploy Fabric artifacts (lakehouses, warehouses, notebooks, pipelines, semantic models) across dev, UAT, and prod using Azure DevOps and Git.
• Maintain legacy Azure Synapse pipelines and lead their migration to Fabric.
• Apply pragmatic engineering standards for ingestion, transformation, naming, versioning, and documentation, and monitor pipelines for quality, performance, and reliability.
• Populate technical metadata and lineage in the data catalog in line with our governance standards.

Requirements

• Senior‑level data engineering experience with a strong generalist mindset, comfortable working across heterogeneous systems and evolving environments.
• Hands‑on expertise with Microsoft Fabric (lakehouses, warehouses, notebooks, pipelines, semantic models) and the medallion architecture.
• Strong proficiency with Azure DevOps and Git for source control and deployment pipelines.
• Solid SQL and data transformation skills (data cleaning, incremental/delta loads, curated table design).
• A good working understanding of downstream analytics, including semantic models and dashboards in Fabric, since you will partner closely with our analytics and BI developers.
• A practical, flexible approach: you choose the solution that fits the problem, and you bring organization and structure to a data practice that is ramping up.

Nice to have

• Experience with Azure Synapse for maintaining legacy pipelines and supporting migration.
• Experience with data governance and Microsoft Purview (classification, lineage, cataloguing).
• Background in construction or construction software.
• Experience with dbt, and to a lesser extent orchestration tools such as Airflow or Dagster.

Benefits

• RRSP with up to 5% employer matching
• Hybrid work model for corporate roles
• Employee stock ownership program
• Career growth through real development opportunities
• Transit pass reimbursement — get to work for free
• Minimum 4 weeks of vacation from day one

For the past six years, we've proudly held the distinction of being one of Canada's Top 100 Employers.

Pomerleau is a national leader in construction, delivering major projects across Canada. We believe in creating a workplace where people feel respected, supported, and empowered to grow. Our culture is built on collaboration, trust, and a shared commitment to doing great work.