This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
We are seeking a highly skilled Business Intelligence Developer for a 12-month contract in Toronto. This role is a key component of the BI Enablement project, focused on building enterprise-grade analytics solutions that bridge the gap between complex data platforms and business decision-makers. You will be responsible for the full lifecycle of BI development—from data modeling and semantic layer design to high-impact dashboard creation—specifically focusing on migrating legacy MicroStrategy reports to Microsoft Power BI.
Job Responsibility
Design, develop, and maintain high-performance Power BI dashboards and reports for critical business areas including SAP Finance, HR, Payroll, Maximo, and VISION
Build and document robust Power BI semantic layers and schemas to ensure data consistency and accuracy across self-serve analytics modules
Lead the migration of legacy reporting from MicroStrategy 2020+ to the Microsoft Power BI ecosystem
Model complex data structures and create optimized datasets using Microsoft Fabric tools, Lakehouse, and Dataflows Gen2
Write scalable Python/Spark code within Fabric Notebooks for ETL, data validation, and feature engineering
Configure and manage Fabric items and pipelines to handle data ingestion, transformation, and scheduling across the enterprise data platform
Implement and administer Power BI environments, including the setup of deployment pipelines and workspace governance
Convert complex business requirements into detailed technical design documents and functional specifications
Act as a subject matter expert to support end-users with Power BI self-serve analytics and provide BI tool training
Create project artifacts according to Project Management Office (PMO) standards, including data models and knowledge transfer summaries
Requirements
Minimum of 5 years as a Business Intelligence Developer, with extensive experience in large-scale enterprise environments
Microsoft Certified: Power BI Data Analyst Associate (PL-300) is required
Primary: Microsoft Power BI, Azure Synapse, SQL Server 2019+
Advanced: Microsoft Fabric (Lakehouse, Notebooks, PySpark), Python for ETL
Legacy (Asset): MicroStrategy 2020 or later
Expert understanding of star schemas, snowflake schemas, and data warehousing interfacing
University degree in Computer Science or a related discipline
Knowledge of (or ability to rapidly acquire) the Ontario Human Rights Code and AODA accessibility requirements for digital reporting
What we offer
High-Visibility Impact: Influence the reporting standards for one of North America’s largest systems
Cutting-Edge Tech: Gain deep, hands-on experience with Microsoft Fabric, the newest evolution in Microsoft's data and analytics ecosystem
Complex Migrations: Lead a significant architectural shift from MicroStrategy to Power BI, a highly sought-after expertise in the current market
Balanced Environment: Benefit from a hybrid model that blends the collaboration of a Toronto-based team with the flexibility of remote work