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.
