Job Description – Power BI & Azure Platform Engineer
Location: Toronto, ON
Work Mode: Onsite
Position Summary
We are looking for an experienced Power BI & Azure Platform Engineer with strong hands-on expertise in Microsoft Fabric, Azure Data Engineering, and Power BI. The ideal candidate will be responsible for designing and developing scalable data pipelines, building modern Lakehouse and Data Warehouse solutions, developing high-performance Power BI reports, and managing the Microsoft Fabric platform.
The role involves working across data engineering, analytics, platform administration, performance optimization, and migration from legacy Azure data platforms to Microsoft Fabric.
Key Responsibilities
- Microsoft Fabric & Azure Data Integration
•
Design, develop, and maintain end-to-end data ingestion and transformation pipelines using Microsoft Fabric Data Factory, Dataflows Gen2, and Azure Data Factory.
•
Integrate data from multiple sources into centralized data platforms.
•
Implement efficient ETL/ELT processes to support enterprise data requirements.
- Data Engineering & Lakehouse Development
•
Design and implement Lakehouses, Data Warehouses, and Notebooks within Microsoft Fabric.
•
Work with OneLake and Delta Lake architecture, following data storage and engineering best practices.
•
Develop data transformation solutions using SQL, Python, and PySpark.
- Power BI Development & Optimization
•
Develop and maintain advanced Power BI reports, dashboards, and semantic models.
•
Build optimized data models using DAX, Power Query, and Direct Lake mode.
•
Improve report performance, data refresh efficiency, and overall analytics experience.
- Microsoft Fabric Platform Administration
•
Manage Microsoft Fabric capacities, workspaces, tenant settings, and platform configurations.
•
Implement security, Role-Based Access Control (RBAC), and data governance policies.
•
Ensure platform security, scalability, and compliance with enterprise standards.
- Performance Optimization & Scalability
•
Monitor Microsoft Fabric workload utilization and optimize capacity performance.
•
Optimize Spark jobs, SQL queries, and data processing workflows for large datasets.
•
Identify performance bottlenecks and implement solutions to improve platform efficiency.
- Platform Migration & Modernization
•
Lead or support migration of existing data platforms and workloads from legacy systems, including Azure Synapse Analytics and SQL-based environments, to Microsoft Fabric.
•
Assess existing data architecture and develop migration strategies.
•
Ensure data accuracy, performance, and minimal disruption during migration.
Required Technical Skills
•
Microsoft Fabric: Strong hands-on experience with Microsoft Fabric, including Lakehouse, Warehouse, OneLake, Notebooks, Data Factory, and Dataflows Gen2.
•
Microsoft Azure: Experience with Azure Data Factory and Azure SQL.
•
Power BI: Strong expertise in Power BI, DAX, Power Query, semantic modeling, and Direct Lake mode.
•
Programming: Advanced SQL, Python, and PySpark skills.
•
Data Engineering: Strong understanding of ETL/ELT pipelines, data modeling, and data transformation.
•
Data Architecture: Hands-on experience with Lakehouse architecture, Delta Lake, and modern data engineering concepts.
•
Platform Management: Experience with Fabric capacity management, workspace administration, RBAC, and data governance.
Ideal Candidate Profile
•
Strong experience in Microsoft Fabric and Azure data platform implementations.
•
Ability to work across data engineering, BI development, and platform administration.
•
Experience handling large-scale enterprise datasets and optimizing data workloads.
•
Strong problem-solving, analytical, and communication skills.
•
Experience migrating legacy data platforms to Microsoft Fabric.
