Senior Data Engineer

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. If this speaks to you, apply for this role or connect with one of our recruiters to learn how we can support you throughout the process.

Design and maintain scalable data pipelines and models across bronze, silver, and gold layers to support BI and AI initiatives. Lead the migration of legacy Azure Synapse pipelines to Microsoft Fabric while ensuring data quality and governance.

Requires senior-level data engineering experience with deep expertise in Microsoft Fabric, Azure DevOps, and SQL. Proficiency in medallion architecture and data transformation is essential, with experience in Azure Synapse or dbt being a plus.

• RRSP With Up To 5% Employer Matching • Hybrid Work Model • Employee Stock Ownership Program • Career Growth Opportunities • Transit Pass Reimbursement • Minimum 4 Weeks Of Vacation

• SQLPreferred
• GitPreferred

Identified from the job description. Confirm important requirements above.

• Microsoft Fabric
• Azure DevOps
• Git
• SQL
• Medallion Architecture
• Data Modeling
• Azure Synapse
• Data Pipeline Engineering
• Data Transformation
• Semantic Modeling
• Microsoft Purview
• Dbt
• Airflow
• Dagster
• Data Governance
• ETL

• Data & Analytics
• Technology
• Engineering
• Construction
• Software

Minimum experience

5+ years

Apply by

Oct 2, 2026

Posting language

English

Working hours

40 hours per week

Seniority

Mid-Senior level