Sightspectrum
Senior Power BI Lead/ Solution Architect
- Compensation
- Not disclosed
- Location
- Dubai
- Work setup
- Onsite
- Seniority
- Lead
- Employment
- Full time
- Experience
- 10+ years
- Category
- Architecture
- Posted
Skills
Full description
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