Talent.com
Technical Lead MS BI Stack
Technical Lead MS BI StackE-Solutions • Mississauga, ON
Technical Lead MS BI Stack

Technical Lead MS BI Stack

E-Solutions • Mississauga, ON
Il y a plus de 30 jours
Type de contrat
  • Temps plein
Description de poste

Role Name : Technical Lead MS BI Stack

Location : Mississauga

Duration : Contract

JOB DESCRIPTION :

Title : Technical Lead MS BI Stack (SSIS, SSAS, SSRS & Power BI)

Job Overview : We are looking for a hands-on Technical Lead with strong expertise across the Microsoft BI stack—SSIS, SSAS (Tabular / Multi-Dimensional), SSRS, and Power BI—to design, build, optimize. This role requires deep technical contribution.

Skills, Experience, and 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 / / ), Error handling, logging, auditing, Parameterized packages and environment-based configurations
  • Optimize SSIS packages for high-volume and near-real-time data loads.
  • Integrate data from relational, flat file, API, cloud, and third-party sources.
  • Implement Star and Snowflake schemas, Complex DAX and MDX calculations, Measures, KPIs, hierarchies, perspectives, and translations
  • Optimize models for query performance and memory efficiency.
  • Implement Row-Level Security (RLS) and role-based access.
  • Tune aggregations, partitions, and processing strategies.
  • Design and develop pixel-perfect, parameter-driven reports.
  • Build Drill-down, drill-through, sub-reports, Scheduled subscriptions and data-driven alerts
  • Optimize report execution and dataset performance.
  • Support operational, regulatory, and executive reporting needs.
  • Develop advanced Power BI solutions, Data modeling and transformation using Power Query, Interactive dashboards and analytical reports
  • Implement Incremental refresh and Dataset optimization and performance tuning
  • Manage deployment pipelines (Dev / Test / Prod) and version control.
  • Work with SQL Server, Azure SQL, Azure Data Factory, Azure Synapse, and cloud data sources.
  • Support hybrid BI solutions (on-prem + cloud).
  • Collaborate with data engineers, DBAs, and application teams.
  • Translate business requirements into scalable BI solutions.
  • Partner with product owners, business analysts, and leadership.
  • Lead technical discussions, design reviews, and solution walkthroughs.
  • Mentor BI developers and reviewers on best practices.
  • Conduct code reviews and performance tuning sessions.
  • Own delivery timelines, risk mitigation, and technical quality."
Créer une alerte emploi pour cette recherche

Technical Lead MS BI Stack • Mississauga, ON

Offres similaires

Power BI Data Engineer — Azure Data & Dashboards Lead

Lakefield Veterinary GroupBurlington, Halton Region, CA
Temps plein

A veterinary services provider seeks a Data Analyst responsible for collecting and analyzing data to support strategic initiatives.The role involves creating PowerBI dashboards, working closely wit...Voir plus

 • Offre sponsorisée

Analytics & Reporting Developer: Power BI Dashboards

Dexterra GroupMississauga, Peel Region, CA
Temps plein

A leading infrastructure firm in Peel Region, Mississauga is seeking a Developer, Analytics & Reporting.This role will develop high-quality Power BI dashboards and create Python scripts for data au...Voir plus

 • Offre sponsorisée

Technology Lead, FASTech

Chartwell Retirement ResidencesMississauga, Peel Region, CA
Temps plein

The Technology Lead, FASTech is a hands-on delivery role responsible for building, configuring, testing, and deploying small-scope, high-impact solutions delivered through Chartwell’s FASTech rapid...Voir plus

 • Offre sponsorisée

Senior Power BI Developer Specializing in SQL and Analytics

SynechronMississauga, Ontario, Canada
Temps plein

Drive data transformation as a Senior Power BI Developer.Focus on developing sophisticated analytics solutions with powerful dashboards, data models, and REST API integrations in a dynamic environm...Voir plus

 • Offre sponsorisée

Senior BI & Analytics Leader — Executive Dashboards

Partners Community HealthMississauga, Peel region, Canada
Temps plein

A healthcare organization in Mississauga is seeking a Senior Business Intelligence Specialist to lead analytics, data modeling, and enterprise reporting.The successful candidate will design scalabl...Voir plus

 • Offre sponsorisée

Senior Full-Stack Tech Lead: APIs & Microservices

PowerToFlyMississauga
Temps plein

A leading technology firm in Mississauga is seeking an experienced Applications Development Technology Lead Analyst to establish and implement application systems.This senior-level role demands lea...Voir plus

 • Offre sponsorisée

TMS Blue Yonder Technology Lead

Metro Supply ChainMississauga, Peel region, Canada
Temps plein

The Technology Lead – TMS is a strategic, hands-on leadership role that blends deep business analysis expertise, advanced Blue Yonder TMS functional knowledge, and the technical leadership capabili...Voir plus

 • Offre sponsorisée

Sp Citi Velociti Full Stack Development Lead

Citibank (Switzerland) AGMississauga, Canada
Temps plein

For additional information, please review.This is a senior level position responsible for implementing new features with the Spread Product Citi Velociti Technology team.The overall objective of th...Voir plus

 • Offre sponsorisée

Data Analytics Leader: Power BI & Data Platform

PACTMississauga, Peel Region, CA
Temps plein

A leading construction analytics company in Mississauga is seeking a Data Analytics Manager to oversee the management and delivery of enterprise analytics.This role includes responsibilities for da...Voir plus

 • Offre sponsorisée

Cloud Billing Tech Lead – Automation & Growth

OpenTextMississauga, Peel Region, CA
Temps plein

A leading information management company is seeking a Lead Systems Analyst to ensure the stability and continuous improvement of enterprise billing platforms.This role is vital for translating busi...Voir plus

 • Offre sponsorisée

Senior Backend Application Development Technical Lead Analyst Vice President

CitiMississauga
Temps plein

Citi, the leading global bank, has approximately 200 million customer accounts and does business in more than 160 countries and jurisdictions.Our mission is to serve as a trusted partner to our cli...Voir plus

 • Offre sponsorisée

Lead BI & Reporting Developer

Husky Injection Molding Systems Ltd.Bolton, ON, CA
Temps plein

An innovative company in Bolton is seeking a Business Intelligence & Reporting Developer to enhance its data-driven decision-making capabilities.This role offers the chance to lead the design and s...Voir plus

 • Offre sponsorisée

Technical Leader for Data Integration Projects

Element Fleet ManagementMississauga
Temps plein

Oversee the delivery of data integration strategies as a Manager of ETL/Data Services.Your leadership will drive the transition of legacy systems to cloud-native frameworks while ensuring high-qual...Voir plus

 • Offre sponsorisée

Team Lead, GenAI Engineering Data & Analytics Oakville, Ontario - Canada; Toronto, Ontario - Ca[...]

Geotab Inc.Oakville, Ontario, Canada
Temps plein +1

Who we are: Geotab ® is a global leader in IoT and connected transportation and certified “Great Place to Work™.We are a company of diverse and talented individuals who work together to help busine...Voir plus

 • Offre sponsorisée

Technology Lead, FASTech

Chartwell Master Care LPMississauga, Peel Region, CA
Temps plein

The Technology Lead, FASTech is a hands-on delivery role responsible for building, configuring, testing, and deploying small-scope, high-impact solutions delivered through Chartwell’s FASTech rapid...Voir plus

 • Offre sponsorisée

SAP Development Team Lead for Innovative Cloud Solutions

SyntaxVaughan, York Region, CA
Temps plein

Become an influential SAP Team Lead focused on innovative cloud solutions.Manage a talented team, ensuring high standards in technical delivery across complex projects and diverse implementations.T...Voir plus

 • Offre sponsorisée

Tableau - PowerBI Developer OR Lead (2 Roles) - mississauga

Q1 Technologies, Inc.mississauga, on, ca
Temporaire

Tableau - PowerBI Developer OR Lead (2 Roles).Months Contract with possibility of extension based on customer requirement.Toronto, ON- 3 days a week Onsite.Primary Skills: PowerBI dash model, Dahsb...Voir plus

 • Offre sponsorisée

Remote Data Analytics Developer: SQL, Power BI & Azure

Cpus Engineering Staffing Solutions Inc.Mississauga, Peel region, Canada
Télétravail
Temps plein

A staffing solutions company in Toronto is seeking a skilled Data Analytics Developer for a fully remote position.The successful candidate will design and deploy advanced analytics solutions using ...Voir plus