Senior Power BI Lead / Solution Architect

confidential; Abu Dhabi; On-site; AED 300,000 - 480,000; Full time

Job summary

confidential is seeking a Senior BI Developer in Abu Dhabi with 6-10 years in BI and 4-6+ years delivering Power BI solutions. You will lead modelling, DAX, and governance in a government/enterprise context.

You will design star schemas, implement scalable semantic models, and mentor a second developer while partnering with stakeholders to close data gaps and ensure secure, high-performance BI delivery.

Qualifications

• 6–10 years BI experience with 4–6+ years Power BI delivery.
• Experience translating business requirements into governed BI solutions.
• Experience with performance tuning and security concepts.

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

RLS and enterprise security

Import/DirectQuery/Composite models

Incremental refresh

Power BI deployment/governance

Stakeholder communication

Microsoft Fabric / Azure

Power BI REST APIs

Custom visual development

Tools

CI/CD pipelines

Source control

Job description

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