Power BI & Azure Platform Engineer / Toronto, ON (Onsite) - FTE

AceStack; Toronto; On-site; CAD 120,000 - 180,000; Full time

Job summary

AceStack is seeking an experienced Power BI & Azure Platform Engineer for onsite work in Toronto, specializing in Microsoft Fabric, Azure Data Engineering, and Power BI. You will design scalable data pipelines, build Lakehouse and Data Warehouse solutions, and manage the Fabric platform.

You will migrate from legacy Azure data platforms, optimize data models with DAX and PySpark, and collaborate across data engineering, analytics, and platform administration to ensure secure, high-performance

Qualifications

• Microsoft Fabric: hands-on with Lakehouse, Warehouse, OneLake, Notebooks, Data Factory, Dataflows Gen2.
• Microsoft Azure: experience with Azure Data Factory and Azure SQL.
• Power BI: expertise in Power BI, DAX, Power Query, semantic modeling, Direct Lake mode.
• Programming: advanced SQL, Python, and PySpark.
• Data Engineering: ETL/ELT pipelines, data modeling, and data transformation.
• Data Architecture: Lakehouse, Delta Lake, modern data engineering concepts.
• Platform Management: Fabric capacity management, workspace administration, RBAC, and data governance.

Responsibilities

• 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.
• 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.
• Monitor Microsoft Fabric workload utilization and optimize capacity performance.
• Optimize Spark jobs, SQL queries, and data processing workflows for large datasets.
• Lead or support migration of existing data platforms and workloads from legacy systems to Microsoft Fabric.

Skills

Microsoft Fabric

Microsoft Azure

Power BI

SQL

Python

PySpark

ETL/ELT

Lakehouse architecture

Delta Lake

RBAC

Data governance

Job description

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

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.

2. 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.

3. 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.

4. 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.

5. 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.

6. 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.