Senior Power BI Lead/ Solution Architect

Sightspectrum; Dubai; Vor Ort; AED 350.000 - 550.000; Vollzeit

Zusammenfassung

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.

Qualifikationen

• 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.

Aufgaben

• 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.

Kenntnisse

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

Jobbeschreibung

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