Location & Travel CanadaTravel: Up to 40-50%, depending on engagement. The Opportunity As an Associate Manager – Power BI Architect, you will play a key role in designing and delivering enterprise‑scale analytics solutions for Avanade clients using Microsoft Power BI and Microsoft Fabric–based analytics architectures, along with Azure data platforms. You will work closely with client stakeholders and delivery teams to translate business needs into well‑architected, performant, and governable analytics solutions. At this level, the role is hands‑on and client‑facing, balancing solution architecture responsibilities with delivery execution, technical leadership, and collaboration across multidisciplinary teams. What You’ll Do Design and deliver end‑to‑end Power BI and Fabric-enabled analytics solutions, including semantic models, datasets, reports, and dashboards aligned to client business objectives. Define Power BI and Microsoft Fabric architectural patterns that support scalability, performance, security, and self‑service analytics. Serve as the Power BI technical lead within a project workstream, contributing to solution quality and delivery success. Design optimized data models using Power BI, Fabric semantic models, DAX, SQL, and dimensional modeling best practices. Integrate Power BI with Microsoft Fabric components (e.G., Lakehouse, Data Warehouse, Data Pipelines) and collaborate with data engineering teams on ingestion, transformation, and refresh strategies. Implement governance, security (including row‑level security), deployment,



and lifecycle management practices aligned with enterprise and Fabric tenant standards. Communicate architecture decisions and trade‑offs clearly to technical and non‑technical stakeholders. Mentor and support Power BI developers and analysts through design guidance, reviews, and knowledge sharing. What You Bring 5+ years of experience in business intelligence or analytics roles, with strong hands‑on Power BI experience. Proven experience designing and delivering enterprise Power BI solutions, ideally within consulting or client‑facing environments. Advanced knowledge of Power BI, DAX, Power Query (M), and data modeling concepts. Hands‑on experience with Microsoft Fabric, including semantic models, Lakehouse or Warehouse workloads, and integration with Power BI. Solid SQL skills and solid understanding of data warehousing and analytics architecture principles. Experience working with Azure and/or Fabric data services (e.G., Azure SQL, Synapse, Data Lake, Fabric Lakehouse/Warehouse). Ability to collaborate effectively with clients and cross‑functional delivery teams. Nice to have: Consulting or client‑facing delivery experience. Nice to have: Experience with Power BI Embedded, Fabric CI/CD, or analytics deployment pipelines. Nice to have: Microsoft certifications, such as Microsoft Fabric Analytics Engineer Associate or Power BI / Azure Data certifications. Compensation British Columbia / Ontario - $114,400 - $135,850. Compensation at Avanade varies depending on office location, role, skill set, and level of experience. #J-18808-Ljbffr

📌 Associate Manager – Power Bi Architect - C$114,400 - C$135,850 A Year (Toronto)
🏢 Avanade
📍 Toronto