Senior Power BI Lead​/Solution Architect

Target experience: 6-10 years in BI, with 4-6+ years of substantial Power BI delivery.

• 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:
  Verti Paq, 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 Verti Paq
• RLS and enterprise security concepts
• Import, Direct Query 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