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.

Must-have skills
• 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