Talent.com
Acestack
Power BI and Azure Platform EngineerAcestack • Toronto, ON, Canada
Search for other jobs
Power BI and Azure Platform Engineer

Power BI and Azure Platform Engineer

Acestack • Toronto, ON, Canada
4 hours ago
Job type
  • Full-time
  • Quick Apply
Job description

Power BI and Azure Platform Engineer

Location: Toronto, ON
Work Model: Onsite

Primary Skills

Microsoft Fabric, Power BI (DAX & Power Query), Azure Data Factory, SQL, Python/PySpark, Delta Lake.

Job Description

We are seeking an experienced Power BI and Azure Platform Engineer with strong expertise in Microsoft Fabric, Azure data services, and Power BI. The ideal candidate will be responsible for designing and implementing scalable data ingestion pipelines, developing modern Lakehouse and Data Warehouse solutions, building high-performance Power BI reports, and managing the Microsoft Fabric platform.

The candidate should have hands-on experience with data engineering, data modeling, platform administration, performance optimization, and migration from legacy data platforms to Microsoft Fabric.

Key Responsibilities

1. Fabric and Azure Integration

  • Design and implement data ingestion pipelines (ETL/ELT) using Microsoft Fabric Data Factory, Dataflows Gen2, and Azure Data Factory.

  • Integrate data from multiple sources into Microsoft Fabric and Azure environments.

  • Develop scalable and reliable data integration solutions.

2. Data Modeling and Storage

  • Create and manage Lakehouses, Data Warehouses, and Notebooks within Microsoft Fabric.

  • Implement Delta Lake best practices for efficient data storage and processing within OneLake.

  • Develop and maintain scalable data models and data engineering solutions.

3. Power BI Development and Enhancement

  • Develop complex, high-performance Power BI semantic models and interactive reports.

  • Implement advanced DAX calculations, Power Query transformations, and data modeling techniques.

  • Leverage Direct Lake mode to improve reporting performance and data accessibility.

  • Optimize Power BI dashboards and reports for business intelligence requirements.

4. Microsoft Fabric Platform Administration

  • Manage Microsoft Fabric capacity, workspace settings, security, and access controls.

  • Implement Role-Based Access Control (RBAC) and data governance policies across the Fabric tenant.

  • Ensure platform security, compliance, and efficient resource utilization.

5. Performance Optimization and Scaling

  • Monitor Microsoft Fabric workload utilization and optimize platform performance.

  • Optimize Spark jobs, SQL queries, and data processing workflows for large datasets.

  • Identify performance bottlenecks and implement appropriate optimization strategies.

6. Data Platform Migration

  • Lead migration initiatives from legacy platforms, including Azure Synapse and SQL-based systems, to Microsoft Fabric.

  • Ensure data integrity, performance, and business continuity throughout migration activities.

Required Technical Skills

  • Microsoft Fabric: Strong hands-on experience with the full Microsoft Fabric suite.

  • Microsoft Azure: Experience with Azure Data Factory and Azure SQL.

  • Programming Languages: Strong proficiency in SQL, Python, and PySpark.

  • Power BI: Expertise in DAX, Power Query, semantic modeling, and report development.

  • Data Engineering: Strong understanding of ETL/ELT, data pipelines, and data engineering concepts.

  • Lakehouse Architecture: Experience with Lakehouse, Delta Lake, Data Warehousing, and OneLake.

  • Data Modeling: Knowledge of scalable data modeling and analytics solutions.

Create a job alert for this search

Power BI and Azure Platform Engineer • Toronto, ON, Canada