About the job
Join our dynamic team as a Business Intelligence Analyst at American Iron & Metal, where you will leverage your analytical skills to work collaboratively with various internal stakeholders. This role focuses on utilizing Microsoft Fabric expertise, particularly in Lakehouse architecture, data modeling, and end-to-end data pipeline development. The ideal candidate will excel in designing, creating, and maintaining semantic models, crafting efficient and optimized DAX queries, and implementing robust SQL-based data transformations. A strong understanding of data warehousing principles is crucial to deliver scalable and effective Fabric solutions that meet our analytical needs.
Your Responsibilities:
- Demonstrate expertise in Microsoft Fabric, including Fabric Lakehouse architecture
- Possess extensive experience in data modeling for analytical use cases and reporting
- Hands-on experience in building and orchestrating end-to-end data pipelines within Fabric
- Master the design, development, and maintenance of semantic models
- Deep knowledge of DAX, including performance optimization and complex calculations
- Strong SQL skills for data transformation, validation, and optimization
- Thorough understanding of data warehousing concepts, including fact and dimension modeling
- Experience in implementing scalable, high-performance, and well-governed analytical solutions
- Knowledge of best practices in governance, security, and data performance within Fabric
