Senior Power BI Developer

Maarut; Montreal , Quebec; On-site; CAD 110,000 - 140,000; Full time

Job summary

Maarut is seeking a senior Power BI developer to lead end-to-end BI delivery for the CDAC project through 2027. The role spans requirements analysis, semantic modeling, and configuring gateways within the Azure data platform, culminating in a Power BI data mart and production deployment.

The ideal candidate has delivered complete semantic models (DAX/Power Query) in large organizations, with ETL on Azure, automated testing, and CI/CD using GitHub or Azure DevOps.

Qualifications

• Experience delivering semantic models (DAX/Power Query) and gateways.

Responsibilities

• Lead end-to-end BI delivery from requirements to production support.
• Develop semantic models and manage gateways and data flows.
• Implement automated tests and CI/CD and maintain source control.

Skills

Power BI development

Semantic modeling

ETL development

CI/CD automation

Azure data services

Relational & dimensional models

Testing & QA

Gateways & deployment

Tools

GitHub

GitHub Actions

Azure Data Factory

Azure Synapse Analytics

Power BI Gateway

Job description

The client is seeking a senior Power BI developer, 8+ years, to support the CDAC project through final delivery in 2027. The project integrates data from several legacy systems and the new group insurance system into an Azure environment, then exposes it through a Power BI data mart. The role spans the full chain: requirements analysis, modeling, semantic model, workspace and gateway configuration with the Power BI foundation team, testing, deployment and post-production support. The mandate requires a testing and source control practice rarely found in BI profiles, which sets the target apart from a report developer. User support and training round out a primarily technical role.

Target candidate: a senior Power BI developer who has delivered complete semantic models (DAX, Power Query, gateways) in large organizations, fed by ETL on Azure, and who applies software engineering discipline to their deliverables: automated testing, continuous integration, Git. Exposure to group or life insurance, or financial services, speeds up onboarding.

Key Requirements:

• Excellent knowledge of Power BI (Desktop, Service, components, gateway)
  
• Development on the Power BI platform: reports, semantic models and data gateways
  
• Excellent knowledge of ETL
  
• Knowledge of relational and dimensional models
  
• Excellent knowledge of testing approaches: TDD, UI testing, automated testing and continuous integration
  
• Knowledge of source control and deployment platforms, such as GitHub and GitHub Actions
  
• Knowledge of Azure data storage environments (DataStorage, Data Lake, Blob Storage, Azure Data Factory, Azure SQL Database, Synapse Analytics)
  
• Functional knowledge
  
• Good knowledge of the industry (competency checked on the form)
  
• Soft skills: resourcefulness and autonomy, teamwork and task sharing, pleasant personality, working in an environment with standardized processes
  
• Competencies checked on the form: managing complexity, results orientation, analysis and synthesis

Requirements

Profiles to Exclude:

Profile mentioning Power BI for report building only, with no demonstrated development of semantic models (DAX, Power Query) or gateways.

Profile with no demonstrated ETL development.

Profile whose BI experience relies on Tableau, Qlik or SSRS, without Power BI delivered to production.

Profile with no mention of automated testing, continuous integration or source control tools (Git, GitHub, Azure DevOps).

Profile limited to on-premises environments (SSIS, SSAS), with no demonstrated Azure component.