Business Intelligence Analyst

We are seeking a detail-oriented and analytical Business Intelligence (BI) Analyst who will work closely with internal stakeholders from various departments to gain a deep understanding of the business needs processes and challenges. This role is centered on Microsoft Fabric expertise with strong hands-on experience in Lakehouse architecture data modeling and the development of end-to-end data pipelines. The position requires proficiency in designing building and maintaining semantic models writing efficient and optimized DAX and implementing robust SQL-based data transformations. A solid understanding of data warehousing principles is essential to ensure scalable performant and well-governed Fabric solutions that support enterprise analytics needs.

What youre responsible for:

• Expertise in Microsoft Fabric including Fabric Lakehouse architecture
• Strong experience with data modeling for analytical and reporting use cases
• Hands-on experience building and orchestrating end-to-end data pipelines in Fabric
• Proficiency in designing developing and maintaining semantic models
• Advanced knowledge of DAX including performance optimization and complex calculations
• Strong SQL skills for data transformation validation and optimization
• Solid understanding of data warehousing concepts including fact/dimension modeling
• Experience implementing scalable performant and well-governed analytics solutions
• Familiarity with data governance security and performance best practices within Fabric

Qualifications :

To join our team: 

• Minimum 5 years of hands-on experience working with Microsoft Fabric and its core components
• At least 5 years of experience with Power BI including dataset and semantic model development
• Strong expertise in DAX including complex calculations and performance optimization
• Advanced SQL skills with experience in data transformation and query optimization
• Proven experience designing and implementing Lakehouse architecture
• Strong background in data modeling including star schema and analytical models
• Hands-on experience building and managing data pipelines for ingestion and transformation
• Solid understanding of data warehousing principles and analytical data structures
• Experience working with enterprise-scale analytics platforms and governed data environments

Additional Information :

What we offer :

• Competitive salary other benefits;
• Group insurance coverage from day one and group RRSP with employer matching contributions;
• Telemedicine (Unlimited access to a doctor 24/7);
• Eligible for paid vacation from day one; **
• AIM tuition assistance grants.
• Company-wide events throughout the year (BBQ Christmas party etc.);
• Free on-site gym;
• Two on-site cafeterias (subsidized meal program available);
• Dynamic and rewarding work environment - work on high-impact and meaningful projects while having fun!

Remote Work :

No

Employment Type :

Full-time