Business Intelligence Analyst

American Iron & Metal (AIM) is a family-owned company and recognized global leader in the metal recycling industry with more than 125 sites and 4000 employees worldwide. We have continued to prosper for the last eight decades thanks to the dedication of our employees and the ongoing trust and support of our customers. 
 
Become part of team AIM, a growing team with an entrepreneurial spirit who has over the years evolved into a successful and multifaceted company with business divisions that include metal recycling, decommissioning and demolition, auto-parts sales and recycling, manufacturing of solder assemblies, construction waste recycling, and production of customized industrial and mining products. 
 
We take pride in doing good things for the environment to help create a greener, more sustainable future for all. 

It’s simple; we do it right. We AIM for excellence.

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!