Senior Data Engineer

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.