Power BI Architect

This is a remote position. We are looking for an experienced Power BI Architect to design, govern, and optimize enterprise-scale Power BI solutions within a complex global pharma environment.

The successful candidate will combine strong hands-on Power BI development expertise with architectural ownership, defining scalable semantic models, governance standards, deployment approaches, security models, and development best practices.

You will work closely with business stakeholders, data engineers, analysts, and IT teams to ensure that Power BI solutions are performant, maintainable, secure, and aligned with the wider enterprise data strategy.

Key Responsibilities

Design and maintain enterprise Power BI solution architecture , including datasets, semantic models, reports, workspaces, security, and deployment standards. Design scalable and reusable semantic/data models , applying dimensional modelling and Power BI modelling best practices.

Develop and review advanced DAX calculations , measures, calculation logic, and complex business KPIs. Design and optimize data ingestion and transformation using Power Query, SQL, and multiple enterprise data sources .

Perform performance analysis, troubleshooting, and optimization of Power BI reports, datasets, DAX queries, refresh processes, and semantic models.

Define standards and best practices for Power BI Service , including workspace architecture, administration, governance, capacity utilization, and report lifecycle management.

Design and implement robust security models , including Row-Level Security (RLS), access controls, workspace permissions, and data governance requirements. Define deployment, release management, and environment strategies across development, testing, and production environments.

Establish development standards around Power BI Project (PBIP) , Git-based source control, versioning, branching, and collaborative development. Support implementation of CI/CD and automated deployment practices for Power BI