Senior Data Engineer

Grow with the best. Join a smart, creative, and inspired team that works behind the scenes to support operational excellence. As part of the Innovation Office, the Digital Technology & Innovation team is composed of digital experts who conduct research and development to keep our teams and our client’s projects ahead of the technological curve. They implement established technologies and find emerging solutions for all business lines (Buildings, Energy & Resources, Environmental Services, Infrastructure, and Water), bridging existing knowledge domains and facilitating the integration of powerful tools and methods. The team’s goal is to make projects more efficient and help provide higher-quality results to our clients. The ideal candidate will be a self-starter, a critical thinker, and highly interested in the application of new technologies and methods. The candidate will become a member of the Innovation Office, however, he or she will also be accessible to Stantec’s project teams to support project work as needed.

Your Opportunity

The Innovation Office’s Digital Technology & Innovation (DTI) team has an opportunity for a Senior Data Engineer. This position requires a person who is technically savvy, experienced in data engineering, and enjoys working with data to solve business problems, shaping & creating solutions, and helping to champion implementation. As a member of the Innovation Office, the Digital Technology Development group, as part of the DTI team, also engages in research & development and provides guidance and oversight as a center of excellence for the business. This group also engages in new product research and testing and the incubation of new ideas. The candidate will be responsible for the delivery of professional services and will recommend solutions to achieve complex strategic objectives across our large global team spanning Stantec IT, Business Lines, and the Office of Innovation.

Your Key Responsibilities

• Take ownership of the project, work independently in a team environment, and mentor others as needed.
• A passion for solving problems and providing workable solutions, flexible to learn new technologies to meet the business needs.
• Translate complex functional and technical requirements into detailed designs.
• Design, develop, adapt, and maintain data warehouse architecture and relational databases that support data mining.
• Implement access governance of production data systems to ensure compliance with our privacy and security policies.
• Oversee, design, and develop algorithms for real-time data processing within the business units and to create the frameworks that enable quick and efficient data acquisition.
• Build and maintain best practices to support the Continuous Integration and Delivery (CI/CD) of data engineering solutions.
• Build, test and operate stable, scalable data pipelines that cleanse, structure and integrate disparate data sets (batch and stream data) into a readable and accessible format for end-user facing reports, data science, and ad-hoc analyses.
• Build and maintain reliable and scalable ETL on big data platforms as well as work with varied forms of data infrastructure inclusive of relational databases and NoSQL databases.
• Work collaboratively with DTI’s Data & Analytics group, Stantec’s internal business units, and clients to define problem statements, collect data and define solution approaches.
• Deliver highly reliable software and data pipelines using Software Engineering best practices like automation, version control, continuous integration/continuous delivery, testing, security, etc.
• Possess excellent time-management skills, a thorough understanding of task assignments and schedules, and efficient use of time and available resources.
• Perform other miscellaneous tasks associated with being a member of the Digital Technology & Innovation team and those typical of a data engineer.