Power BI Master Architect & Data Solutions Lead

Sightspectrum; Dubai; On-site; AED 350,000 - 550,000; Full time

Job summary

Sightspectrum in Dubai seeks a Senior Power BI Lead / Solution Architect to translate complex business requirements into governed BI solutions using Power BI at scale.

The ideal candidate will design star-schema models, lead DAX/SQL decisions, ensure performance, security, and governance, and mentor a junior developer while delivering enterprise BI for government/enterprise clients. You will collaborate with stakeholders to identify data gaps and drive analytics roadmap.

Qualifications

• Proficiency in DAX, data modelling, and semantic layer design.
• Experience delivering enterprise BI with Power BI and governance.
• Strong SQL, Power Query, and data integration skills.

Responsibilities

• Translate requirements into governed BI solutions.
• Design star schemas and semantic models for Power BI.
• Define KPI logic, measures, and modeling standards.
• Lead DAX, Power Query and SQL decisions and code reviews.
• Design for performance: VertiPaq, cardinality, and incremental refresh.
• Define security, workspace structure, deployment practices and governance.
• Evaluate visuals and advanced Power BI capabilities.
• Mentor junior developer and establish reusable patterns.
• Collaborate with stakeholders to identify data gaps and risks.

Skills

Advanced DAX

Dimensional modelling

Power Query / M

Strong SQL

Power BI performance

RLS & security

Import / DirectQuery / composite

Incremental refresh

Power BI governance

Stakeholder communication

Microsoft Fabric / Azure

Power BI REST APIs

Custom visuals

CI/CD / source control

Large datasets

Enterprise/government BI

Tools

Azure Data services

Job description

Sightspectrum in Dubai seeks a Senior Power BI Lead / Solution Architect to translate complex business requirements into governed BI solutions using Power BI at scale.

The ideal candidate will design star-schema models, lead DAX/SQL decisions, ensure performance, security, and governance, and mentor a junior developer while delivering enterprise BI for government/enterprise clients. You will collaborate with stakeholders to identify data gaps and drive analytics roadmap.