Jobs → Data & Analytics → Power BI & Enterprise Analytics Architect

About the Role We are looking for an experienced Solution Architect specializing in Microsoft Power BI and Enterprise Analytics to design, optimize, and govern scalable enterprise BI solutions. This role requires deep expertise in Power BI, advanced DAX, Microsoft Fabric, and Azure data platforms. Key Responsibilities • Design enterprise semantic models using Power BI Premium, Microsoft Fabric, Composite Models, DirectQuery, Import, and Hybrid Models. • Develop star schemas, dimensional models, and certified enterprise datasets. • Establish BI governance, workspace strategies, access controls, and security standards. • Integrate Power BI with Azure SQL, Azure Databricks, Dataverse, and Microsoft Fabric. • Build and optimize ETL pipelines, Dataflows, incremental refresh, and query folding. • Develop advanced DAX calculations, calculation groups, Row-Level Security (RLS), and Object-Level Security (OLS). • Perform performance tuning using DAX Studio, Performance Analyzer, and Tabular Editor. • Design secure access models using service principals, managed identities, and service accounts. • Optimize large-scale datasets, refresh performance, memory utilization, and concurrency. • Collaborate with Finance, M&A, and Capital Markets teams to define KPIs and reporting standards. • Mentor BI developers and establish enterprise modeling and documentation standards. Requirements • 7+ years of BI/Analytics Architecture experience. • 5+ years of hands-on Microsoft Power BI development. • Advanced DAX, SQL, data modeling, and performance optimization expertise. • Strong experience with Azure Data Factory (ADF), Azure Synapse, and Azure Databricks. • Hands-on experience with Microsoft Fabric and Lakehouse architecture. • Expertise in enterprise BI governance and data warehousing principles. • Financial services experience, preferably in Investment Banking, M&A, or Capital Markets. • Strong communication, stakeholder management, and technical leadership skills.