Senior Power BI Lead / Solution Architect

confidential; Dubai; On-site; AED 360,000 - 520,000; Full time

Job summary

Confidential in Dubai seeks an experienced BI Lead to own end-to-end Power BI delivery, translating business requirements into governed BI solutions.

You will design star schemas, optimize performance with VertiPaq, and mentor a junior developer while coordinating with stakeholders across client teams.

The role requires 6–10 years in BI, 4–6+ years Power BI, strong SQL/DAX, and governance experience in enterprise environments.

Qualifications

• Advanced DAX and Power BI modeling
• Strong SQL and data modelling skills
• Experience with large enterprise BI environments

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.

Skills

Advanced DAX

Dimensional modelling

Power Query / M

SQL

Power BI performance tuning

VertiPaq

RLS and enterprise security

Import/DirectQuery/Composite models

Incremental refresh

Power BI deployment/governance

Enterprise BI experience

Microsoft Fabric / Azure

Power BI REST APIs

Custom visuals

CI/CD / source control

Large datasets

Stakeholder communication

Tools

Power BI

SQL

Job description

Target experience: 6–10 years in BI, with 4–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

Skills

• CI/CD and source control
• Experience with large datasets
• Enterprise/government BI experience