Top Benefits
About the role
Lead Solutions Architect and Engineer
Grow with the best. Join a smart, creative, and inspired team that works behind the scenes to support operational excellence. Our functional services teams (FSTs) provide services to 30,000 employees in over 350 locations worldwide. Bringing together individuals with diverse backgrounds, talents, and expertise, our FSTs are vital to making our Company stronger.
Your Opportunity
We are looking for a Lead Data and Analytics Engineer, BI on our Marketing Business Intelligence team.
Your Key Responsibilities
Strategy
- Lead the design, development, and evolution of our enterprise data warehouse solutions, ensuring scalability, performance, security, and data quality.
- Define and implement data modeling strategies (dimensional, Kimball, Inmon) optimized for analytical workloads and business intelligence reporting.
- Develop comprehensive ETL/ELT strategies and pipelines to ingest, transform, and load data from diverse sources, including our custom .NET CRM, custom proposal resource center, Oracle ERP, and other operational systems.
- Consult on BI capabilities and recommend and execute solutions to address business needs and performance requirements
- Extend the Data Warehouse with data from new sources, applying: data lineage analysis.
Technical
- Design, develop, and maintain robust and scalable data models (star/snowflake schemas) in Power BI using Power Query (M), DAX, and Dataflows.
- Develop comprehensive ETL/ELT strategies and pipelines to ingest, transform, and load data from diverse sources, including our custom CRM, custom proposal resource center, Oracle ERP, and other operational systems.
- Lead the development of data pipelines using Azure Data Factory, Synapse Analytics, and SQL Server to source, transform, and load data into BI environments.
- Implement granular row-level security (RLS) to accurately reflect our matrix organizational leadership structure and robust Role-Based Access Control (RBAC).
- Leverage SQL Server (on-premise or Azure SQL Managed Instance) for foundational data storage and data warehousing components.
- Utilize Azure DevOps / Git for version control, CI/CD pipelines, and collaborative development practices.
- Conduct peer reviews of models, reports, and DAX logic for performance and accuracy.
Ensure solutions align with enterprise architecture standards, including metadata management, source control, and documentation.
Communication
- Collaborate closely with marketing and sales teams to identify key data points that can inform winning strategies, and design data models that expose these insights.
- Effectively communicate highly technical information to functional, technical team members and management
- Act as a subject matter expert and technical leader, providing guidance and mentorship to other team members on data architecture and BI best practices.
- Maintain a positive attitude when dealing with others in a pressured environment
Education and Experience
- Bachelor's or Master's degree in Computer Science, Data Science, Information Systems, Engineering, or a related quantitative field.
- 8+ years of progressive experience in data warehousing, business intelligence, and data analytics roles, with at least 3+ years in a lead or architectural capacity.
- Demonstrated experience integrating complex data from Oracle ERP, CRM systems, and bespoke applications into the Microsoft BI stack is a strong advantage.
- Proven experience designing and implementing enterprise BI systems using the Microsoft Power Platform (Power BI, Power Query, DAX) and Azure Data Services (ADF, Synapse, SQL Server)
- Strong proficiency in data modeling techniques (dimensional modeling, star/snowflake schemas).
- Experience with enterprise BI governance, dataset certifications, naming conventions, and lifecycle management.
- Experience in data security, including row-level security, workspace roles, and deployment pipelines in Power BI.
- Familiarity with CI/CD pipelines and DevOps practices for Power BI and Azure data pipelines is an asset.
This description is not a comprehensive listing of activities, duties or responsibilities that may be required of the employee and other duties, responsibilities and activities may be assigned or may be changed at any time with or without notice.
Pay Transparency:
In compliance with pay transparency laws, pay ranges are provided for positions in locations where required. Please note, the final agreed upon compensation is based on individual education, qualifications, experience, and work location. At Stantec certain roles are bonus eligible.
Benefits Summary:
Regular full-time and part-time employees (working at least 20 hours per week) will have access to health, dental, and vision plans, a wellness program, health care spending account, wellness spending account, group registered retirement savings plan, employee stock purchase program, group tax-free savings account, life and accidental death & dismemberment (AD&D) insurance, short-term/long-term disability plans, emergency travel benefits, tuition reimbursement, professional membership fee coverage, and paid time off.
Temporary/casual employees will have access to group registered retirement savings plan, employee stock purchase program, and group tax-free savings account.
The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements.
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.
We are a global leader in sustainable engineering, architecture, and environmental consulting. Our 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 we do—from our project teams and industry colleagues to our clients and the people our work impacts. 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 are designers, engineers, scientists, project managers, and strategic advisors. We innovate at the intersection of community, creativity, and client relationships to advance communities everywhere, so that together we can redefine what’s possible.
Stantec trades on the TSX and the NYSE under the symbol STN.
Top Benefits
About the role
Lead Solutions Architect and Engineer
Grow with the best. Join a smart, creative, and inspired team that works behind the scenes to support operational excellence. Our functional services teams (FSTs) provide services to 30,000 employees in over 350 locations worldwide. Bringing together individuals with diverse backgrounds, talents, and expertise, our FSTs are vital to making our Company stronger.
Your Opportunity
We are looking for a Lead Data and Analytics Engineer, BI on our Marketing Business Intelligence team.
Your Key Responsibilities
Strategy
- Lead the design, development, and evolution of our enterprise data warehouse solutions, ensuring scalability, performance, security, and data quality.
- Define and implement data modeling strategies (dimensional, Kimball, Inmon) optimized for analytical workloads and business intelligence reporting.
- Develop comprehensive ETL/ELT strategies and pipelines to ingest, transform, and load data from diverse sources, including our custom .NET CRM, custom proposal resource center, Oracle ERP, and other operational systems.
- Consult on BI capabilities and recommend and execute solutions to address business needs and performance requirements
- Extend the Data Warehouse with data from new sources, applying: data lineage analysis.
Technical
- Design, develop, and maintain robust and scalable data models (star/snowflake schemas) in Power BI using Power Query (M), DAX, and Dataflows.
- Develop comprehensive ETL/ELT strategies and pipelines to ingest, transform, and load data from diverse sources, including our custom CRM, custom proposal resource center, Oracle ERP, and other operational systems.
- Lead the development of data pipelines using Azure Data Factory, Synapse Analytics, and SQL Server to source, transform, and load data into BI environments.
- Implement granular row-level security (RLS) to accurately reflect our matrix organizational leadership structure and robust Role-Based Access Control (RBAC).
- Leverage SQL Server (on-premise or Azure SQL Managed Instance) for foundational data storage and data warehousing components.
- Utilize Azure DevOps / Git for version control, CI/CD pipelines, and collaborative development practices.
- Conduct peer reviews of models, reports, and DAX logic for performance and accuracy.
Ensure solutions align with enterprise architecture standards, including metadata management, source control, and documentation.
Communication
- Collaborate closely with marketing and sales teams to identify key data points that can inform winning strategies, and design data models that expose these insights.
- Effectively communicate highly technical information to functional, technical team members and management
- Act as a subject matter expert and technical leader, providing guidance and mentorship to other team members on data architecture and BI best practices.
- Maintain a positive attitude when dealing with others in a pressured environment
Education and Experience
- Bachelor's or Master's degree in Computer Science, Data Science, Information Systems, Engineering, or a related quantitative field.
- 8+ years of progressive experience in data warehousing, business intelligence, and data analytics roles, with at least 3+ years in a lead or architectural capacity.
- Demonstrated experience integrating complex data from Oracle ERP, CRM systems, and bespoke applications into the Microsoft BI stack is a strong advantage.
- Proven experience designing and implementing enterprise BI systems using the Microsoft Power Platform (Power BI, Power Query, DAX) and Azure Data Services (ADF, Synapse, SQL Server)
- Strong proficiency in data modeling techniques (dimensional modeling, star/snowflake schemas).
- Experience with enterprise BI governance, dataset certifications, naming conventions, and lifecycle management.
- Experience in data security, including row-level security, workspace roles, and deployment pipelines in Power BI.
- Familiarity with CI/CD pipelines and DevOps practices for Power BI and Azure data pipelines is an asset.
This description is not a comprehensive listing of activities, duties or responsibilities that may be required of the employee and other duties, responsibilities and activities may be assigned or may be changed at any time with or without notice.
Pay Transparency:
In compliance with pay transparency laws, pay ranges are provided for positions in locations where required. Please note, the final agreed upon compensation is based on individual education, qualifications, experience, and work location. At Stantec certain roles are bonus eligible.
Benefits Summary:
Regular full-time and part-time employees (working at least 20 hours per week) will have access to health, dental, and vision plans, a wellness program, health care spending account, wellness spending account, group registered retirement savings plan, employee stock purchase program, group tax-free savings account, life and accidental death & dismemberment (AD&D) insurance, short-term/long-term disability plans, emergency travel benefits, tuition reimbursement, professional membership fee coverage, and paid time off.
Temporary/casual employees will have access to group registered retirement savings plan, employee stock purchase program, and group tax-free savings account.
The benefits information listed above may not apply to union positions because benefits for such positions are governed by applicable collective bargaining agreements.
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.
We are a global leader in sustainable engineering, architecture, and environmental consulting. Our 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 we do—from our project teams and industry colleagues to our clients and the people our work impacts. 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 are designers, engineers, scientists, project managers, and strategic advisors. We innovate at the intersection of community, creativity, and client relationships to advance communities everywhere, so that together we can redefine what’s possible.
Stantec trades on the TSX and the NYSE under the symbol STN.