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.

Desired Candidate Profile

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