Senior BI Developer (Power BI) – to help establish a BI Center of Excellence / Platform & Governance – Remote

Details:

• Duration: 6 months (high likelihood of extension, long-term program)
• Location: Remote (Canada)

Our client is building a Business Intelligence Center of Excellence (BI COE) and is seeking a Senior BI Developer to support the development, governance, and evolution of their enterprise BI platform.

This role sits within a hub-and-spoke model, acting as the central BI team responsible for platform management, standards, and best practices, while also supporting business teams with dashboard development where needed.

The successful consultant will play a key role in a large-scale BI transformation, including the migration from legacy SAP Web Intelligence to a modern BI ecosystem (Power BI and emerging tools such as Sigma).

Key Responsibilities:

• Develop and maintain Power BI dashboards and reports for business stakeholders
• Manage and optimize the BI platform, including workspaces, access controls, and semantic models
• Define and enforce BI standards, governance, and best practices across the organization
• Support business teams with dashboard development in lower-maturity areas
• Optimize SQL queries and data models for performance and scalability
• Contribute to BI platform evolution, including evaluation of next-gen tools (e.g., Sigma Computing)
• Support migration of legacy BI assets (SAP Web Intelligence) into the modern BI environment
• Collaborate with data and platform teams to ensure consistency and reliability

Must-Have Requirements:

• Strong hands-on experience with Power BI (development + platform management)
• Experience managing BI environments (workspaces, security, semantic models)
• Strong SQL skills with a focus on performance optimization
• Experience working in a governed BI environment (standards, best practices, COE model)
• Ability to operate independently in a fully remote environment

Nice-to-Have:

• Exposure to Snowflake and AWS
• Experience with DBT
• Exposure to Sigma Computing or similar modern BI tools
• Experience supporting BI transformation or migration initiatives
• Interest or exposure to AI/LLM-driven reporting use cases