Senior Data Engineer at Stantec

Pune, maharashtra, India -

Full Time

Start Date

Immediate

Expiry Date

10 Aug, 26

Salary

0.0

Posted On

12 May, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Engineering, Cloud-Native Platforms, Python, SQL, Databricks, Delta Live Tables, Power BI, Data Governance, Azure, ETL, Data Modeling, Semantic Models, Data Pipelines, Azure DevOps, Data Quality, Performance Optimization

Industry

Industrial Machinery Manufacturing

Description

Senior Data Engineer Digital Practice Group | Environmental Services | Stantec About the Role Stantec's Digital Practice is building a modern, cloud-native data platform to power environmental project delivery, reporting, and analytics across the organization. As a Senior Data Engineer, you will play a central role in architecting, building, and maintaining the data infrastructure and solutions that enable the Environmental Services team to derive insight from large and complex project datasets. You will work in close partnership with other Digital Practice resources who manage the underlying cloud platform, networking, security, and infrastructure, allowing you to focus on what sits above it: data architecture, pipeline engineering, semantic modelling, and data product delivery. Together, these roles form part of the technical core of the Digital Practice's data and cloud capability. You will help lead data engineering architecture decisions while remaining deeply hands-on in pipeline development, data modelling, and platform optimization working in close partnership with data scientists, BI developers, business stakeholders, and the broader technology teams. As Stantec's data platform evolves, this role will play a key part in evaluating and adopting Microsoft Fabric capabilities including Fabric Lakehouses, Data Pipelines, and Fabric-native semantic models, alongside the existing Databricks and Azure landing zone resources. Key Responsibilities Architecture & Design * Help lead the design and evolution of Stantec's environmental data platform including medallion architecture (Bronze / Silver / Gold) in Databricks / ADLS Gen2, semantic layer design, data product definitions and evaluate equivalent patterns within Microsoft Fabric as the platform matures * Define data engineering standards, coding conventions, pipeline design patterns, and data quality frameworks for the Digital Practice - covering both the current Databricks-led stack and emerging Fabric capabilities * Architect end-to-end data flows across source systems (SharePoint, SQL, ESRI, EQuIS, OpenGround, cloud sources and other external feeds), the lakehouse, and consumption layers (Power BI, Fabric semantic models, APIs) * Collaborate with the Azure Infrastructure Specialists to ensure data platform infrastructure is secure, scalable, and aligned with Stantec's landing zone architecture including ADLS Gen2 provisioning, private endpoint configuration, Databricks/Fabric setup, and cross-landing-zone data movement patterns. * Align on shared governance concerns including RBAC, network segmentation, Unity Catalog permissions, Fabric workspace and item-level permissions, and Azure Policy compliance * Contribute to Stantec's Fabric adoption strategy, assessing where Fabric capabilities (Lakehouse, Warehouse, Data Pipelines, Eventstream, etc) can complement or progressively replace existing tooling Stantec is a global leader in sustainable engineering, architecture, and environmental consulting. The diverse perspectives of our partners and interested parties drive us to think beyond what’s previously been done on critical issues like climate change, digital transformation, and future-proofing our cities and infrastructure. We innovate at the intersection of community, creativity, and client relationships to advance communities everywhere, so that together we can redefine what’s possible. The Stantec community unites approximately 32,000 employees working in over 450 locations across 6 continents.

Responsibilities

The Senior Data Engineer will architect, build, and maintain the data infrastructure for the Environmental Services team, focusing on data architecture, pipeline engineering, and data product delivery. This role involves collaboration with various teams to ensure the data platform is secure, scalable, and optimized for performance.