At Stantec, we have some of the world’s leading professionals passionate about enabling our business to be its best. Our business teams include finance, procurement, human resources, information technology, marketing, corporate development, HSSE, real estate, legal, and practice services. We bring diverse backgrounds, skills, and expertise and create a caring culture where everyone can thrive. Through teamwork and collaboration, we’re building a stronger, more resilient Stantec every day.    

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.

Primary Location: Canada |
Organization: 1196 Marketing & Communications-CA Corporate-Edmonton AB
Employee Status: Regular
Travel: No
Schedule: Full time
Job Posting: 18/07/2025 04:07:22
Req ID: 1001502