Power BI Solutions Architect

Job Description

Overview : We're seeking an exceptional Power BI Solutions Architect to lead client engagements and design enterprise-scale BI solutions. You'll translate business requirements into technical architectures while guiding a team of Power BI developers. This role requires deep Microsoft data platform expertise combined with outstanding client communication skills, with particular emphasis on embedded analytics and role-based access control (RBAC). Key Responsibilities: Lead client discovery sessions and translate business needs into technical solutions Design scalable, secure, and high-performance Power BI architectures Mentor and direct a team of Power BI developers Implement complex features including Power BI Embedded, row-level security, and enterprise deployments Architect data models and optimize DAX for maximum performance Design integrations between Power BI and diverse enterprise data sources Create migration strategies from legacy BI to modern cloud architectures Required Skills & Experience Leadership & Consulting Proven experience leading client-facing technical engagements Ability to communicate complex concepts to diverse stakeholders Experience managing technical teams on complex BI implementations Power BI Expertise (4+ years) Power BI Embedded : Advanced experience with multi-tenant implementations, app ownership, and JavaScript API integration Security Architecture : Implementing row-level security (RLS), object-level security, and Azure AD integration Advanced DAX : Complex calculation development and performance optimization Power BI Premium : Capacity management, large dataset handling, and deployment pipelines Role & responsibilities Fabric Integration : Experience with Microsoft Fabric components including Data Factory, Dataflows, and Synapse integration Composite Models : Implementation of mixed storage mode solutions for optimal performance Paginated Reports : Design and deployment within Power BI service Data Platform Skills : SQL Server : Performance tuning, high availability configurations, and clustering Cloud Services : Azure Synapse, Azure SQL DB, and Azure Data Factory implementation Data Modeling : Dimensional modeling for analytics workloads Technical Proficiencies Preferred candidate profile Required 1.Power BI Embedded application design and implementation 2.Complex DAX formula development with performance optimization 3.Row-level security (RLS) across organizational hierarchies 4.Reporting database setup and optimization for analytics workloads Highly Desirable 1.Microsoft Fabric experience 2.DirectQuery and Composite Model optimization 3.Power BI REST API integration 4.AI visual and metrics implementation What Sets You Apart Experience implementing Copilot for Power BI with advanced natural language query capabilities Experience with Power BI Premium capacity planning, autoscaling, and resource optimization for enterprise workloads