Talent.com
Cynet Systems
Technical Lead MS BI StackCynet Systems • Mississauga, ON
Technical Lead MS BI Stack

Technical Lead MS BI Stack

Cynet Systems • Mississauga, ON
30+ days ago
Job type
  • Full-time
Job description

Job Description:

Requirement/Must Have:
  • Extensive experience with Microsoft BI stack including SSIS, SSAS, SSRS, and Power BI.
  • Strong hands-on development experience.
  • Expertise in ETL/ELT pipeline design and optimization.
  • Experience with data modeling, DAX, MDX, KPIs, and hierarchies.
  • Experience implementing Row-Level Security and role-based access.
  • Strong SQL Server and Azure data platform experience.
  • Ability to lead technical design and decision-making.
Experience:
  • Senior-level experience delivering enterprise BI solutions.
  • Experience integrating data from relational, flat file, API, cloud, and third-party sources.
  • Experience with Star and Snowflake schemas.
  • Experience supporting hybrid BI environments (on-prem and cloud).
  • Experience mentoring developers and conducting code reviews.
Responsibilities:
  • Lead technical decisions 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 ETL/ELT pipelines using SSIS.
  • Implement incremental loads, CDC, SCD, error handling, logging, auditing, and environment-based configurations.
  • Optimize SSIS packages for high-volume and near-real-time data loads.
  • Build and optimize semantic models with complex DAX and MDX calculations.
  • Tune aggregations, partitions, and processing strategies.
  • Design and develop parameter-driven reports with drill-down and drill-through functionality.
  • Optimize report execution and dataset performance.
  • Develop Power BI dashboards and analytical reports using Power Query.
  • Implement incremental refresh and dataset performance tuning.
  • Manage deployment pipelines and version control.
  • Collaborate with data engineers, DBAs, and application teams.
  • Translate business requirements into scalable BI solutions.
  • Lead technical discussions, design reviews, and solution walkthroughs.
  • Mentor BI developers and conduct performance tuning sessions.
  • Own delivery timelines, risk mitigation, and technical quality.
Skills:
  • Microsoft BI stack (SSIS, SSAS, SSRS, Power BI).
  • Data modeling and ETL development.
  • Azure data services and cloud integrations.
  • Performance tuning and optimization.
  • Strong communication and leadership skills.
  • Stakeholder collaboration and mentoring.
Qualification And Education:
  • Degree in Computer Science, Information Technology, or related field preferred.

Create a job alert for this search

Technical Lead MS BI Stack • Mississauga, ON

Similar jobs

Data Team Lead

REDPATH MININGVaughan
Full-time

This role provides day‑to‑day guidance to Data Engineers and Power BI Developers, ensuring work is aligned to project priorities, timelines, and delivery milestones.The Data Team Lead contributes h... Show more

 • Promoted

Power BI Data Engineer — Azure Data & Dashboards Lead

Lakefield Veterinary GroupBurlington, Halton Region, CA
Full-time

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... Show more

 • Promoted

Lead Full-Stack Data Engineer — ETL & Insights

Chord StrategyMississauga, Peel Region, CA
Full-time

A dynamic growth strategy consultancy in Metro Vancouver is seeking a Data Engineer to improve and maintain ETL processes.The ideal candidate is a leader comfortable with ambiguity and able to work... Show more

 • Promoted

Senior ETL Developer - Hybrid Data Pipeline Lead

Randstad DigitalOakville, ON, CA
Full-time

A leading insurance firm in Canada is seeking a Senior ETL Developer to join their hybrid team.The role involves building efficient data pipelines and operationalizing high-quality data solutions.C... Show more

 • Promoted

Senior Azure Cloud Architect - Migration Lead

Huntel GlobalMississauga, Peel Region, CA
Full-time

A leading IT staffing firm in Ontario is seeking a Senior Azure Cloud Specialist to lead cloud migration projects and engage stakeholders.Candidates should be proficient in enterprise cloud strateg... Show more

 • Promoted

Senior Power BI Developer: PowerShell, DevOps & Azure

SynechronMississauga, Ontario, Canada
Full-time

A global consulting firm is seeking a skilled Power BI Developer in Mississauga to create advanced business intelligence solutions.This role involves designing immersive dashboards, automating depl... Show more

 • Promoted

Remote Data Team Lead & Architect: MongoDB to Redshift

Confidential CompanyMississauga, Peel Region, CA
Remote
Full-time

A growing technology firm in Toronto, Ontario is seeking a Lead Data Engineer to spearhead the migration of its data infrastructure from a monolithic to a microservices-based architecture.This is a... Show more

 • Promoted

Machine Learning Lead, Edge AI Inferencing

BlumindVaughan
Full-time

Blumind is a deep-tech startup at the forefront of the AI revolution.We are building a new class of semiconductor: ultra-low-power analog AI processors (AMPL™) designed for the extreme edge.Our tec... Show more

 • Promoted

Lead BI & Reporting Developer

Husky Injection Molding Systems Ltd.Bolton, ON, CA
Full-time

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... Show more

 • Promoted

Remote Data Analytics Developer: SQL, Power BI & Azure

Cpus Engineering Staffing Solutions Inc.Mississauga, Peel Region, CA
Remote
Full-time

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 ... Show more

 • Promoted

Senior MicroStrategy BI Architect & Developer (Contract)

IT TrailBlazersMississauga, Peel Region, CA
Full-time

A leading BI consultancy in Canada is seeking a seasoned professional with over 6 years of experience in BI development and architecture, particularly in financial environments.The ideal candidate ... Show more

 • Promoted

Technical Leader for Growth Initiatives

Jane AppMississauga, Peel Region, CA
Full-time

Elevate user onboarding as a Staff Developer dedicated to driving growth.Utilize experimentation and a data-driven approach to foster successful clinic integrations.As part of the Sign Up and Demo ... Show more

 • Promoted

Oracle Solution Architect / Technical Lead (Onshore)

Jade GlobalMississauga
Full-time

Oracle Solution Architect / Technical Lead (Onshore).Lead Oracle Cloud (SaaS/PaaS) implementations, integrations, and support.Design and develop integrations using Oracle Integration Cloud (OIC), R... Show more

 • Promoted

Data Science Lead: Strategy, Scale & Impact

Aarorn Technologies IncVaughan
Full-time

A data solutions company in Vaughan is seeking a Data Science Lead to manage multiple teams, oversee data-driven solutions, and align analytics with business objectives.This role requires 11+ years... Show more

 • Promoted

Mid-Senior BI Engineer - Data Analytics & Dashboards

Charger Logistics Inc.Brampton
Full-time

A leading logistics provider in Brampton is seeking an experienced BI Engineer to join their IT Analytics team.This role focuses on transforming data into actionable insights and requires advanced ... Show more

 • Promoted

Citi Applications Development Technology Lead

Citigroup Inc.Mississauga
Full-time

Citi is looking for a Technology Lead Analyst to oversee Applications Development initiatives.This role is crucial for leveraging Java skills and enhancing the client onboarding experience with mod... Show more

 • Promoted

Senior Technology Consulting Manager - Data Analytics & Cloud

Tiger AnalyticsMississauga, Peel Region, CA
Full-time

A data analytics firm in Toronto is seeking an experienced professional to manage large-scale data analytics client engagements.Ideal candidates have over 8 years in the P&C domain, with strong ski... Show more

 • Promoted

Data Architecture Lead - Cloud, Governance & Analytics

PathlionMississauga, Peel Region, CA
Full-time

A leading technology consulting firm is looking for a Data Architect in Edmonton, Canada, to lead the design and implementation of data architectures for a public trustee solution.The ideal candida... Show more

 • Promoted

Digital Solutions Lead: Cloud, Data & Integrations

Plan Group Inc.Vaughan
Full-time

A leading Canadian contractor is seeking a Digital Solutions Manager to drive the design and delivery of integrated cloud-based systems.This role focuses on modernizing business processes and impro... Show more

 • Promoted

Microsoft Power BI Tutor

Varsity Tutors, a Nerdy CompanyVaughan
Full-time

The Varsity Tutors Live Learning Platform has thousands of students looking for online Microsoft Power BI tutors nationally.As a tutor on the Varsity Tutors Platform, you'll have the flexibility to... Show more