Microsoft Power BI Senior Technical Lead
Canada
Job Description
Microsoft Power BI Senior Technical Lead
Ottawa, Ontario

Job Summary

Required Skills

Technical Skills

Microsoft Power BI Desktop and Power BI Service

Advanced DAX and Power Query (M Language)

SQL Server, Azure SQL Database

Data Modeling and Data Warehousing Concepts

Microsoft Fabric (Preferred)

Power BI Gateway Administration

REST APIs Integration

SharePoint Online Integration

Performance Tuning and Troubleshooting

 

Database Skills

Advanced SQL Query Writing

Views and Functions

Query Optimization

Data Warehousing Concepts

Preferred Qualifications

Bachelor’s degree in computer science, Information Technology, Data Analytics, or a related field.

6+ years of BI development experience.

4+ years of hands-on Power BI development experience.

Experience working in Azure and Microsoft Fabric environments.

Experience supporting large-scale enterprise BI solutions.

Key Responsibilities

1. Lead and manage technical teams to deliver high-quality microsoft powerbi solutions within specified timelines.
2. Develop and implement powerbi dashboards, reports, and data visualizations to meet business requirements.
3. Collaborate with stakeholders to gather and analyze requirements for powerbi projects.
4. Optimize sql databases and queries to ensure efficient data retrieval and storage.
5. Provide technical guidance and mentorship to team members on powerbi best practices and sql optimization techniques.
6. Troubleshoot and debug powerbi solutions and sql databases as needed.
7. Stay updated on latest trends in powerbi and sql to recommend and implement innovative solutions.

Skill Requirements

1. Proficient in microsoft powerbi for data analysis, reporting, and dashboard development.
2. Strong expertise in sql for database design, optimization, and querying.
3. Experience in leading technical teams and managing project deliveries.
4. Excellent communication skills to collaborate with stakeholders and present technical solutions effectively.
5. Problem-solving aptitude with a keen attention to detail.
6. Ability to work in a fast paced environment and adapt to changing priorities efficiently.

Other Requirements

1.Microsoft Certified Solutions Expert (MCSE) in Data Management and Analytics is preferred but not mandatory.
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 227,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending March 2026 totaled $14.7 billion.