Technical Lead MS BI Stack (Mississauga)

Role Name: Technical Lead MS BI Stack

Location: Mississauga

Duration: Contract

Job Overview

We are looking for a hands‑on Technical Lead with solid expertise across the Microsoft BI stack (SSIS, SSAS (Tabular/Multidimensional), SSRS, and Power BI) to design, build, and optimize. This role requires deep technical contribution.

Responsibilities

• Years of experience in Microsoft BI stack – SSIS, SSAS, SSRS & Power BI.
• Lead technical decision‑making for scalability, performance, security, and maintainability.
• Perform hands‑on development while guiding junior and mid‑level developers.
• Define BI standards, deployment strategies, naming conventions, and performance best practices.
• Design and develop robust ETL/ELT pipelines using SSIS – implement incremental loads, CDC, and SCD (Type //). Include error handling, logging, auditing, parameterized packages, and environment‑based co...