Senior Data Engineer

Pomerleau; Montreal (administrative region); Hybrid; CAD 110,000 - 140,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 — get to go

Minimum 4 weeks of vacation from day 1

Job summary

Pomerleau is seeking a Senior Data Engineer to own the data foundation end to end, from ingestion to canonical data objects, serving analytics and BI teams. The role emphasizes hands-on work, delivering reliable data assets and applying governance standards.

The candidate will work across Bronze to Gold data layers, migrate pipelines to Fabric, and collaborate with analytics to enable semantic models and dashboards while maintaining quality and structure in a ramping data practice.

Qualifications

• Senior-level data engineering experience with a generalist mindset.
• Hands-on expertise with Microsoft Fabric and the medallion architecture.
• Strong SQL and data transformation skills.
• Experience with Azure DevOps and Git for source control and deployment pipelines.

Responsibilities

• Design, build, and maintain scalable data pipelines and models across Bronze, Silver, and Gold layers for BI/AI teams.
• Provide cleaned and transformed data and curated tables for semantic models and dashboards.
• Engineer source data into canonical objects for reuse and reduce duplication across projects.
• Develop and deploy Fabric artifacts (lakehouses, warehouses, notebooks, pipelines, semantic models) using Azure DevOps and Git.
• Migrate legacy Azure Synapse pipelines to Fabric and monitor pipeline quality, performance, and reliability.
• Populate metadata and lineage in the data catalog per governance standards.

Skills

Data engineering

SQL

Microsoft Fabric

Azure DevOps

Git

Data governance

Analytical mindset

Tools

Azure DevOps

Git

dbt

Airflow

Dagster

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.

This role could be for you if you have

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