Full-Time

Senior Data Engineer

Posted on 5/12/2026

Stantec

Stantec

10,001+ employees

Global design and engineering consulting services

No salary listed

Pune, Maharashtra, India

In Person

Category
Data & Analytics (1)
Required Skills
Power BI
Microsoft Azure
Python
Apache Spark
SQL
Role-based Access Control
Data Governance
Databricks
Requirements
  • Bachelor’s degree in Computer Science, IT, Data Science, or related field
  • 10+ years of data engineering experience
  • 5+ years working on cloud-native data platforms (Azure preferred)
  • Expert-level proficiency in Python and SQL; Spark/PySpark experience essential
  • Deep, hands-on experience with Databricks, Delta Live Tables, Unity Catalog, job orchestration, and performance optimization
  • Proficiency in Power BI data modelling including DirectQuery, semantic model design, and M/DAX
  • Familiarity with Azure SQL Database and SQL Server environments
  • Experience with ADLS Gen2 and cross-landing-zone data movement patterns
  • Exposure to data governance frameworks and enterprise RLS/security patterns
  • Working understanding of Azure infrastructure concepts related to data platform services (networking, RBAC, private endpoints, managed identities)
  • Hands-on exposure to Microsoft Fabric including Fabric Lakehouse, Data Pipelines, Dataflow Gen2, and Fabric-native semantic models (Direct Lake)
  • Experience managing Fabric capacity sizing and workspace governance in a production or near-production environment
  • Databricks Certified Data Engineer Professional or Azure Data Engineer Associate (DP-203) highly regarded
  • Familiarity with OneLake, Fabric shortcuts, and cross-workspace data sharing patterns
  • Experience working in regulated or governance-heavy environments (e.g., engineering, environmental consulting, or similar)
Responsibilities
  • 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 architectureincluding 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
  • Design, build, and maintain scalable ETL/ELT pipelines using Databricks (PySpark, Delta Live Tables), Fabric Data Pipelines and Python
  • Develop and maintain Delta Lake / Unity Catalog structures including managed tables, materialized views, and row-level security (RLS) using UDF row filters
  • Implement and maintain data ingestion patterns using Databricks Autoloader and Fabric Eventstream / Dataflow Gen 2 for structured (CSV, Parquet) and semi-structured (JSON, XML) data sources
  • Build and maintain Power BI / Fabric semantic models including DirectQuery configurations, dimension tables, and time intelligence, ensuring performance and governance
  • Implement data governance controls including Unity Catalog permissions, Fabric item-level security, column-level security, and audit logging
  • Build and maintain CI/CD pipelines for data workloads via Azure DevOps including deployment automation for both Databricks and Fabric workspace items where supported
  • Coordinate with the Azure Infrastructure Specialist on shared integration services including Azure Functions, Logic Apps, and potentially ADF to ensure consistent deployment, access control, and operational standards
  • Monitor and optimize Databricks pipeline performance including instance pool configuration, serverless vs. classic compute trade-offs, and job orchestration efficiency
  • Monitor Fabric capacity utilization including CU consumption, throttling behaviors, and workspace sizing to ensure cost-effective and performant operations
  • Troubleshoot data quality issues, pipeline failures, and schema drift across the data platform
  • Escalate and collaborate with the Azure Infrastructure Specialist on platform-level issues including networking failures, identity/access errors, and infrastructure capacity constraints
  • Provide technical mentorship to other members within the Digital Practice team
  • Maintain thorough documentation of data models, pipeline logic, and platform configurations - consistent with infrastructure documentation standards across the team
  • Stay current with Databricks, Azure data platform, Microsoft Fabric and analytics engineering best practices, particularly as Fabric capabilities rapidly evolve
  • Evaluate and pilot new Fabric features where possible for applicability to Stantec's environmental data platform
  • Recommend and implement improvements to data pipeline reliability, performance, and platform scalability
  • Contribute to cross-team knowledge sharing alongside the Azure Infrastructure Specialist, ensuring the Digital Practice maintains a unified, well-documented technical foundation
  • Deep technical ownership - you care about data quality, pipeline reliability, and platform health
  • The ability to balance strategic architecture thinking with day-to-day hands-on delivery
  • A collaborative, team-first approach - particularly in working alongside Azure Infrastructure Specialist to ensure the data and infrastructure layers are tightly aligned and mutually supportive
  • An adaptive mindset that is comfortable navigating a platform that is actively evolving, with a clear path toward Microsoft Fabric adoption alongside an established Databricks foundation
  • Experience working in large, cross-functional enterprise environments
  • Strong analytical mindset and a passion for clean, well-documented, maintainable data systems
  • Confidence raising platform concerns and engaging with infrastructure peers to resolve them quickly
Desired Qualifications
  • Databricks Certified Data Engineer Professional or Azure Data Engineer Associate (DP-203) highly regarded
  • Familiarity with OneLake, Fabric shortcuts, and cross-workspace data sharing patterns
  • Experience working in regulated or governance-heavy environments (e.g., engineering, environmental consulting, or similar)
  • Microsoft Fabric knowledge including Fabric Lakehouse, Data Pipelines, Dataflow Gen2, and Fabric-native semantic models (Direct Lake) considered advantageous
  • Azure Data Factory experience considered beneficial

Stantec is a global design and consulting firm that delivers professional services in multiple sectors, including buildings, energy and resources, environmental services, infrastructure, and water. It helps municipalities, governments, and private clients plan, design, engineer, and manage projects by offering planning, architecture, engineering, environmental, and project management services for a fee. The company differentiates itself through its global reach and multi-disciplinary teams that provide integrated solutions across many sectors, enabling end-to-end project delivery. Its goal is to help clients design and implement infrastructure, facilities, and environmental solutions that meet their objectives, operate efficiently, and serve communities over the long term.

Company Size

10,001+

Company Stage

IPO

Headquarters

Edmonton, Canada

Founded

1954

Simplify Jobs

Simplify's Take

What believers are saying

  • European Investment Bank partnership expands climate adaptation advisory under InvestEU through 2050.
  • AI-driven wastewater operations framework with WSSC Water and Prince William Water scales.
  • Arliss Szysky's 25-year transportation expertise accelerates infrastructure growth and project delivery.

What critics are saying

  • AECOM's $8.7B market cap and defense expertise erode Stantec's federal infrastructure contracts.
  • EAOS launches competing standalone AI tools, commoditizing Stantec's wastewater operational guidance.
  • Post-2026 election federal funding cuts terminate Safe Streets for All grant programs.

What makes Stantec unique

  • 68% of C$5.5B revenue from UN Sustainable Development Goals work as of 2025.
  • Operational carbon neutrality achieved four consecutive years; A- CDP score eight years.
  • Infrastructure business leads North America at 26% regional revenue with 4,800 professionals.

Help us improve and share your feedback! Did you find this helpful?

Your Connections

People at Stantec who can refer or advise you

Benefits

Professional Development Budget

Flexible Work Hours

Company News

Sheridan Wyoming Travel Guide
Apr 9th, 2026
City to move forward with Safe Streets for All Comprehensive Safety Action Plan.

City to move forward with Safe Streets for All Comprehensive Safety Action Plan. News - Sheridan Media [[{"value":" The development of a Safe Streets for All Comprehensive Safety Action Plan was addressed by officials with the City of Sheridan this week. Sheridan Media's Ron Richter has more. Stantec Consulting Services, Inc. will develop a Safe Streets for All Comprehensive Safety Action Plan for the City after the Council awarded them the project during their recent business meeting. Stantec will receive $249,922 to develop the action plan, which is being funded by a $200,000 Safe Streets for All federal grant and a City match of 25 percent from Public Benefit. City Engineer Thomas Morneau. Morneau said the objective of the federal grant is to prepare a Comprehensive Safety Action Plan that will identify high-risk corridors and intersections, address systemic safety issues for all modes of transportation, incorporate community input, and establish a framework for future implementation actions.

Hive Projects
Apr 9th, 2026
Planning submitted: 240 affordable Homes for Warrington town centre.

Planning submitted: 240 affordable Homes for Warrington town centre. Hive Projects is acting as Project Manager for the first planning application submitted by Habiko; the affordable housing partnership between Muse, Pension Insurance Corporation (PIC), and Homes England. The proposal for Academy Way, Warrington, includes: * Scale: 240 one- and two-bedroom apartments across two six-storey blocks. * Affordability: The scheme targets 100% affordable housing for rent. * Sustainability: Designed as a low-carbon, car-free development featuring a central landscaped courtyard. Located south-east of the Time Square district, this project represents a significant step in the town center's ongoing regeneration. The Hive Projects team is working alongside AHR Architects, Stantec, and Gillespies to deliver the scheme. April 9, 2026 April 2, 2026

Canadian Consulting Engineer
Apr 6th, 2026
Stantec names new infrastructure leader for North America.

Stantec names new infrastructure leader for North America. Talking points. Stantec has named Arliss Szysky EVP of its North American infrastructure business. Szysky, who brings 25 years' experience in transportation engineering and business operations, succeeds Susan Walter, who will now focus on major projects, client relationships and mentoring. Szysky previously served as VP and regional leader for Alberta South, then as SVP and operations leader for buildings. She now leads Stantec's largest business segment, which generated 26% of North American revenue in 2025 and employs nearly 4,800 people. * Szysky's portfolio includes landscape architecture, residential and commercial developments, ports, roads, bridges, rail and airports * She is a graduate of the Schulich School of Engineering * Susan Reisbord, Stantec's COO for North America, praises Szysky's operational rigour and strategic vision This leadership change is significant as Stantec continues to expand its infrastructure business and deliver complex projects. Powered by: Stantec has promoted Arliss Szysky, P.Eng., to executive vice-president (EVP) of its infrastructure business for North America. Based in Calgary, she succeeds Susan Walter, who will now focus on leading major projects, growing key client relationships and mentoring young engineers. Szysky has 25 years' experience in transportation engineering, project leadership and business operations. After earning her B.Sc. in transportation at the University of Calgary's Schulich School of Engineering, she worked at Watt Consulting for five years as a transportation engineer, then joined Stantec, where she rose to vice-president (VP) and regional leader for Alberta South, then SVP and operations leader for buildings. In her new role, Szysky leads Stantec's largest business in North America, which accounted for 26% of regional revenue in 2025, and is supported by a team of nearly 4,800. Her mandate spans a diverse portfolio, from landscape architecture, residential and commercial developments to ports, roads, bridges, rail and airports. "We have powerful opportunities to collaborate across the company, expand our transportation business, strengthen our community development work and build on our experience delivering projects in some of the most challenging environments, including the Arctic," she says. "I'm looking forward to continuing to evolve how we operate." "Arliss brings a rare combination of operational rigour, strategic vision and genuine care for people," says Susan Reisbord, Stantec's chief operating officer (COO) for North America. "She champions continuous improvement while creating conditions for teams to do their best work. I'm looking forward to partnering closely with Arliss as we continue to grow our infrastructure business and advance our corporate strategic plan."

Stantec
Apr 6th, 2026
Stantec names Arliss Szysky to lead Infrastructure business.

Stantec names Arliss Szysky to lead Infrastructure business. Szysky brings 25 years of experience in transportation engineering, project leadership, and business operations 04/06/2026 CALGARY, AB TSX, NYSE:STN Stantec, a global leader in sustainable design and engineering, has appointed Arliss Szysky as executive vice president of its Infrastructure business in North America, marking a step forward for the firm's largest and one of its fastest-growing operating units. Szysky brings deep operational expertise and a people-first leadership approach to the role. Most recently, she served as operations leader for Stantec's North American Buildings business, where she strengthened business processes, advanced operational excellence, and supported sustained growth. She also played a key role in the successful acquisition and integration of Page, a 1,400-person architecture and engineering firm, further reinforcing Stantec's commitment to scale, collaboration, and design excellence. Infrastructure is Stantec's largest business in North America, accounting for 26 percent of regional revenue in 2025 and supported by nearly 4,800 professionals. The business spans a diverse portfolio across transportation and community development, including ports and marine, roadways and bridges, transit and rail, airports, residential and commercial development, and landscape architecture - delivering projects that connect communities and shape resilient, thriving places. "Arliss brings a rare combination of operational rigor, strategic vision, and genuine care for people," said Susan Reisbord, chief operating officer for North America. "She champions continuous improvement while creating the conditions for teams to do their best work. I'm looking forward to partnering closely with Arliss as we continue to grow our Infrastructure business and advance our corporate strategic plan." Leading growth and delivering complex projects Szysky joined Stantec in 2004 as a transportation engineer, contributing to major public and private sector projects across Western Canada. She went on to lead the Alberta South region for six years, guiding a diverse, multidisciplinary team and driving strong performance through collaboration and technical excellence. Her time serving as executive sponsor for the BMO Convention Centre Expansion in Calgary reflects her commitment to trusted client relationships and delivery of complex, high-profile projects. "It's an incredibly exciting time for our Infrastructure business," said Szysky. "We have powerful opportunities to collaborate across the Company, expand our transportation business, strengthen our community development work, and build on our experience delivering projects in some of the world's most challenging environments, including the Arctic. I'm looking forward to continuing to evolve how we operate - creating a strong, future-ready platform that supports safe, efficient, and high-quality project delivery for our clients and our people." Szysky succeeds Susan Walter, who led the Infrastructure business through six years of sustained growth and two corporate strategic plans. Under Walter's leadership, the business broadened its reach, successfully integrating Morrison Hershfield, and delivered signature projects including the Long Island Rail Road Expansion and the East Midtown Greenway. Walter will transition into a role focused on leading major projects, growing key client relationships, and mentoring the next generation of Stantec leaders. About Stantec Stantec empowers clients, people, and communities to rise to the world's greatest challenges at a time when the world faces more unprecedented concerns than ever before. Stantec is a global leader in sustainable engineering, architecture, and environmental consulting. Its professionals deliver the expertise, technology, and innovation communities need to manage aging infrastructure, demographic and population changes, the energy transition, and more. Today's communities transcend geographic borders. At Stantec, community means everyone with an interest in the work that Stantec do - from its project teams and industry colleagues to its clients and the people its work impacts. The diverse perspectives of its partners and interested parties drive Stantec to think beyond what's previously been done on critical issues like climate change, digital transformation, and future-proofing its cities and infrastructure. Stantec is designers, engineers, scientists, project managers, and strategic advisors. Stantec innovate at the intersection of community, creativity, and client relationships to advance communities everywhere, so that together Stantec can redefine what's possible. Stantec trades on the TSX and the NYSE under the symbol STN. Media Contact Colin Nekolaichuk Stantec Media Relations Ph: (437) 225-6384 [email protected]

Stantec
Mar 26th, 2026
Stantec partners with WSSC Water and Prince William Water on new Water Research Foundation AI initiative.

Stantec partners with WSSC Water and Prince William Water on new Water Research Foundation AI initiative. New AI framework aims to support wastewater operations 03/26/2026 WASHINGTON, DC TSX,NYSE:STN Stantec, a global leader in sustainable design and engineering, has been selected to lead a new Water Research Foundation (WRF) project focused on applying artificial intelligence (AI) to wastewater treatment operations. The 31-month initiative is co-funded through WRF's Tailored Collaboration Program, with the Washington Suburban Sanitary Commission (WSSC Water) in Maryland and Prince William Water in Virginia serving as coleading utility partners. Stantec will combine engineering and plant operations experience with advanced AI architecture to translate treatment data into actionable operational guidance. The firm will incorporate AI capabilities from EAOS, a wastewater-focused artificial intelligence firm, to advance digitally enabled treatment operations and support real-time operational decision-making. The Tailored Collaboration Program enables utilities to propose research topics and receive matching funds from the Foundation - an approach that directly links emerging technologies to utility needs and operational priorities. For this project, WRF will support 50 percent of the total funding, with WSSC Water and Prince William Water contributing the remaining share. A client-driven research partnership to solve operational challenges The project reflects a growing industry need for AI tools that directly support operational challenges. Rather than exploring speculative technologies, the effort is grounded in issues utilities face every day, including process stability, operator support, knowledge retention, and adapting to a changing workforce. The research is shaped and co-funded by the utilities themselves. The project introduces "Intelligent Assets" - embedded digital tools that translate engineering expertise into real-time operational guidance. Utilities can implement these tools step-by-step, maintaining ownership of their data while modernizing physical infrastructure without disruptive system replacements. Stantec and its utility partners will incorporate learnings at WSSC Water's Piscataway Water Resource Recovery Facility, and Prince William Water's H.L. Mooney Advanced Water Reclamation Facility - both of which are positioned to integrate digital intelligence during ongoing upgrades. Additional observer utilities from all regions in the US will be invited to participate throughout the project, helping insights and outcomes to be replicated more broadly. Utilities can reach out to Stantec if they'd like to play an observer role. "At its core, this project is about practical innovation grounded in operations," said Pusker Regmi, Stantec vice president and principal investigator. "By bringing together engineering, plant experience, and artificial intelligence, we're creating tools that operators can trust to manage increasingly complex facilities." The final deliverables will include a WRF research report and a Utility AI Implementation Playbook - providing technical guidance, case studies, return on investment methods, and templates to help utilities of all sizes chart a clear path for AI adoption. About Stantec Stantec empowers clients, people, and communities to rise to the world's greatest challenges at a time when the world faces more unprecedented concerns than ever before. Stantec is a global leader in sustainable engineering, architecture, and environmental consulting. Its professionals deliver the expertise, technology, and innovation communities need to manage aging infrastructure, demographic and population changes, the energy transition, and more. Today's communities transcend geographic borders. At Stantec, community means everyone with an interest in the work that Stantec do - from its project teams and industry colleagues to its clients and the people its work impacts. The diverse perspectives of its partners and interested parties drive Stantec to think beyond what's previously been done on critical issues like climate change, digital transformation, and future-proofing its cities and infrastructure. Stantec is designers, engineers, scientists, project managers, and strategic advisors. Stantec innovate at the intersection of community, creativity, and client relationships to advance communities everywhere, so that together Stantec can redefine what's possible. Stantec trades on the TSX and the NYSE under the symbol STN. Media Contact Sean Fitzgerald Stantec Media Relations Ph: (416) 598-5769 [email protected]