Solution Architect – Microsoft Power BI & Enterprise Analytics
Kamesh NagabelliRemoteSENIORPosted 6h ago
Power BIDAXMicrosoft FabricAzure data platformsSemantic modelingEnterprise data governancePower BI PremiumComposite ModelsDirectQueryImportHybrid ModelsStar schemasDimensional modelsBI governanceWorkspace strategiesAccess controlsSecurity standardsAzure SQLAzure DatabricksDataverseETL pipelinesDataflowsIncremental refreshQuery foldingCalculation groupsRow-Level Security (RLS)Object-Level Security (OLS)DAX StudioPerformance AnalyzerTabular EditorService principalsManaged identitiesService accountsAzure Data Factory (ADF)Azure SynapseLakehouse architectureData warehousingFinancial servicesInvestment BankingM&ACapital MarketsCommunicationStakeholder managementTechnical leadership
About the Role
We are looking for an experienced Solution Architect – Microsoft Power BI & Enterprise Analytics to design, optimize, and govern scalable enterprise BI solutions. The ideal candidate will have deep expertise in Power BI, advanced DAX, Microsoft Fabric, Azure data platforms, semantic modeling, and enterprise data governance.
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.