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 you’re 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

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

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!