Cloud BI Architect: Power BI & Fabric Migration Lead

Compunnel Inc.; Toronto; On-site; CAD 100,000 - 130,000; Full time

Job summary

A leading technology solutions provider in Toronto seeks a Systems Architect III. This role focuses on modernizing legacy BI platforms and migrating to cloud-native solutions using Power BI, Azure Data Factory, and Microsoft Fabric technologies. The ideal candidate will possess extensive experience in Business Intelligence and Data Engineering, specifically with Power BI migration and Azure data solutions. Join a team innovating data-driven strategies and enhancing analytic capabilities in a collaborative environment.

Qualifications

• 5+ years of experience in Business Intelligence and Data Engineering.
• Strong experience with Azure Databricks and Data Factory.
• Knowledge of data governance, RLS, and lineages.

Responsibilities

• Lead migration of legacy SSRS to modern Power BI dashboards.
• Design, develop, and optimize Power BI reports using DAX.
• Build and maintain ETL pipelines using Azure Data Factory.

Skills

Migrating SSRS to Power BI

Business Intelligence experience

Data Engineering experience

Hands-on experience with Azure Data Factory

Strong SQL skills

Performance tuning

Problem-solving skills

Education

Bachelor’s Degree in Computer Science or related field

Job description

The Systems Architect III will be responsible for modernizing legacy BI and data platforms by leading migrations from on-premise SQL Server ecosystems to cloud-native Microsoft analytics solutions. This role focuses on Power BI development, SSRS/SSAS modernization, and building scalable data engineering pipelines using Azure and Microsoft Fabric technologies. The ideal candidate will have strong hands-on experience in BI reporting, data engineering, and large-scale migration initiatives.

Key Responsibilities:

• Lead migration of legacy SSRS (Paginated Reports) to modern Power BI dashboards
• Design, develop, and optimize Power BI reports using DAX and Power Query
• Optimize report performance and enable efficient export of large datasets
• Build and maintain ETL pipelines using Azure Data Factory and Azure Databricks
• Query, transform, and validate data throughout the migration lifecycle
• Implement DirectQuery, composite models, and aggregations to manage large data volumes
• Modernize SSAS Tabular or Multidimensional models to Microsoft Fabric semantic models
• Work with MS Fabric components including OneLake, Data Engineering, and Data Factory
• Establish CI/CD deployment pipelines for Power BI and Fabric artifacts
• Implement data governance practices including RLS, security, and data lineage
• Collaborate with stakeholders to ensure successful platform modernization
• Ensure reliability, scalability, and performance of BI and analytics solutions

Required Skills:

• Strong experience migrating SSRS to Power BI
• 5+ years of Business Intelligence and Data Engineering experience required
• Hands-on experience with Azure Data Factory and Azure Databricks
• Strong SQL skills for querying and transforming data
• Experience managing large datasets and performance tuning
• Knowledge of DirectQuery, composite models, and aggregations
• Strong problem-solving and analytical skills

Preferred Skills:

• Experience migrating SSAS models to Microsoft Fabric
• Hands-on knowledge of Microsoft Fabric (OneLake, Direct Lake, Data Engineering)
• Experience with CI/CD pipelines for Power BI and Fabric
• Understanding of data governance, RLS, and data lineage
• Familiarity with DevOps practices in BI environments

Education:

Bachelor’s Degree in Computer Science, Information Technology, Data Analytics, or related field