Role Summary
We are seeking a highly experienced Lead Power BI Architect & Analytics Developer to design, develop and govern enterprise-grade business intelligence solutions using Microsoft Power BI and Microsoft Fabric.
The successful candidate must possess deep expertise across the entire Power BI stack, extending well beyond report development. The role requires advanced capabilities in semantic modelling, DAX, Power Query/M, performance optimization, security, governance, deployment, administration and enterprise BI architecture.
The individual will work closely with the Microsoft Fabric Data Engineering team and business stakeholders to transform governed enterprise data into intuitive, performant and trusted analytical solutions.
Key Responsibilities
- Architect, develop and maintain enterprise-grade Power BI reports, dashboards, semantic models and analytical applications.
- Design scalable semantic models supporting Finance, Sales, Operations, Supply Chain and executive reporting.
- Develop robust dimensional models using appropriate star-schema principles, fact/dimension modelling, relationship design and reusable measures.
- Demonstrate expert-level DAX, including filter and row context, context transition, CALCULATE, iterators, time intelligence, virtual tables, variables, calculation groups and advanced measure design.
- Develop sophisticated transformations using Power Query and M while determining whether transformations should appropriately reside in Power Query, Fabric pipelines, Lakehouse/Warehouse or the semantic model.
- Design solutions using Import, DirectQuery, Direct Lake and composite models, selecting the appropriate architecture based on performance, latency and business requirements.
- Build Power BI solutions directly against Microsoft Fabric Lakehouse and Warehouse environments.
- Optimize semantic models and reports for performance, scalability and user experience.
- Troubleshoot DAX, model and query performance using tools and techniques such as Performance Analyzer, DAX Studio, query diagnostics and model optimization.
- Implement incremental refresh, aggregations, partitions and appropriate refresh strategies for large datasets.
- Implement and maintain Row-Level Security (RLS), Object-Level Security (OLS) and appropriate workspace/app access controls.
- Design secure reporting solutions for different business units, roles and management hierarchies.
- Establish standards for Power BI workspaces, apps, semantic models, reports, naming conventions, endorsements/certification and content lifecycle management.
- Configure and manage gateways, connections, credentials, refresh schedules and data source connectivity where required.
- Build reusable enterprise semantic models rather than creating unnecessary report-specific datasets.
- Establish a single source of truth for enterprise KPIs and business metrics.
- Work with Finance and business stakeholders to define calculations and ensure consistent interpretation of measures across reports.
- Develop executive dashboards, operational reporting, drill-through experiences, tooltips, bookmarks, parameters and advanced interactive reporting capabilities.
- Apply strong principles of data visualization, information hierarchy, accessibility, usability and dashboard design.
- Design mobile-friendly Power BI experiences where required.
- Implement deployment pipelines and Dev/Test/Prod processes.
- Support Git/source-control and CI/CD practices where applicable within the Microsoft Fabric/Power BI environment.
- Implement appropriate refresh monitoring, usage monitoring, adoption analytics and operational support procedures.
- Understand and optimize Power BI/Fabric capacity utilization, including identifying poorly performing models, queries and reports.
- Support migration and modernization of legacy Tableau and other reporting solutions into Power BI where appropriate.
- Document semantic models, KPI definitions, data lineage, security rules, report specifications and support procedures.
- Conduct peer reviews and establish Power BI development standards across the organization.
- Train and mentor developers, analysts and business users on Power BI best practices.
Advanced Power BI Expertise Required
This candidate should be genuinely senior and have deep experience with: Power BI Desktop and Service; Microsoft Fabric; semantic models; DAX; Power Query/M; Direct Lake; Import and DirectQuery; composite models; star schemas; calculation groups; field parameters; incremental refresh; aggregations; RLS/OLS; deployment pipelines; gateways; Power BI Apps; workspace administration; dataflows; paginated reporting where required; performance tuning; capacity management; and enterprise BI governance.
They should understand when logic belongs in DAX vs. Power Query vs. SQL vs. the Fabric data engineering layer, rather than solving every problem inside the report.
Required Experience
Ideally, the resource should have 8+ years of BI/data analytics experience with 5+ years of advanced Power BI development, including responsibility for enterprise-scale implementations.
Strong SQL skills are essential.
Experience with Microsoft Fabric, Azure/Fabric data platforms, enterprise data warehouses and complex ERP/financial datasets is strongly preferred.
The candidate should have demonstrated experience building solutions used by both operational teams and senior executives and should be capable of taking a Power BI solution from requirements model DAX visualization security deployment performance optimization production support.