Senior Consultant – Power BI Architect
Job Description
Location: Canada
Travel: Up to 40-50%, depending on engagement
About Avanade
Avanade is the world’s leading expert on Microsoft. Our professionals bring bold thinking, deep industry knowledge, and advanced technology expertise to help organizations realize the full potential of their people and data. Together, we do what matters for our clients, our communities, and one another.
The Opportunity
As a Senior Consultant – 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.
Why Avanade
Work for Microsoft’s Global Systems Integrator Partner of the Year, with direct access to Microsoft technologies, training, and certifications.
Grow your career through meaningful client work, continuous learning, and clear progression opportunities.
Join an inclusive, people‑first culture that values curiosity, collaboration, and innovation.
.
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.
Strong 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.
Experience with Power BI Embedded, Fabric CI/CD, or analytics deployment pipelines.
Microsoft certifications, such as Microsoft Fabric Analytics Engineer Associate or Power BI / Azure Data certifications.
Compensation at Avanade varies depending on a wide array of factors, which may include but are not limited to the specific office location, role, skill set, and level of experience. As required by local law, Avanade provides a reasonable range of compensation, based on full-time employment, for roles that may be hired as set forth below. The recruiting efforts for this position are intended to fill a brand new position. The recruiting efforts for this position are intended to fill a brand new position.
British Columbia / Ontario - $114,400 - $135,850
We anticipate this job posting will be posted on 05/01/2026 and open for at least 30 days.
.