Senior Power BI Lead/ Solution Architect

JD: Senior Power BI Lead / Solution Architect Experience:10+ years in BI, with 6+ years of substantial Power BI delivery. Core responsibilities Translate business requirements and Excel/MIS reporting into a governed BI solution. Design star-schema / dimensional models and reusable Power BI semantic models. Define KPI logic, measures, calculation patterns and modelling standards. Lead DAX, Power Query and SQL design decisions and code reviews. Design for performance: VertiPaq, cardinality, query performance, aggregation, incremental refresh and storage modes. Define security, workspace structure, deployment/release practices and governance. Evaluate custom visuals and advanced Power BI capabilities where standard visuals are insufficient. Mentor the second developer and establish reusable development patterns. Work with client stakeholders to identify data gaps, source dependencies and delivery risks. • Advanced DAX • Strong dimensional modelling and semantic-model design • Power Query / M • Strong SQL • Power BI performance tuning and VertiPaq • RLS and enterprise security concepts • Import, DirectQuery and composite models • Incremental refresh • Power BI deployment/governance • Strong stakeholder communication • Microsoft Fabric / Azure • Power BI REST APIs • Custom visual development or integration • CI/CD and source control • Experience with large datasets • Enterprise/government BI experience