11699

Maarut; Montreal (administrative region), Lévis; On-site; CAD 90,000 - 130,000; Full time

Job summary

Zohorecruit is seeking a Data Analyst for a Montreal/Québec project. The CDAC initiative integrates data from multiple wealth management systems into an Azure-based data environment and a Power BI data mart, serving business units.

The role sits between business experts, the data architect and developers, translating source data into rules, profiling, classification and documentation. It also supports ETL/configuration and QA activities from day one.

Qualifications

• Must have documented rules and functional specifications on large-scale data projects.
• Experience with data modelling and ETL in Azure.
• Knowledge of Power BI on the platform side (Service, gateway).

Responsibilities

• Collaborate with solution architects, developers, POs and business experts.
• Define data rules, profiling, classification and documentation.
• Support both development and QA teams from day one.

Skills

Teamwork

Analytical thinking

Documentation

Requirements

Tools

Power BI

Azure

Azure Synapse

Azure SQL

Data Factory

Data Lake

Job description

Montreal /Levis, Canada | Posted on 10/09/2026

• Assigned Recruiter(s) Madhumitha Mulakaluri
• Job Opening ID 11699
• City Montreal /Levis
• Country Canada
• Number of Positions 1
• Work Experience 10+ Years

Job Description

The CDAC project integratesdata from several wealth management systems and the new group insurance systeminto an Azure cloud environment, then makes it available to business unitsthrough a Power BI data mart. The role sits between business experts, the dataarchitect and developers: understanding source data, specifying the rules toapply, profiling, classifying and documenting. It also carries two supportcomponents, one toward the developer (ETL, data mart configuration), the othertoward the QA analyst (test cases, validation scripts, execution). The clientemphasizes a deadline-driven team culture, reflected in the competencieschecked: action and results orientation, managing complexity, analysis andsynthesis. This is a replacement, which implies quickly taking over a projectalready underway.

Candidatesought: a data analyst who has already documented rules and functionalspecifications on a large-scale data warehouse, data lake or data mart project,with hands-on modelling and ETL practice in the Azure ecosystem. They knowPower BI on the platform side (Service, gateway), not only on the report side,and can support both the developer and the QA analyst from day one.

REQUIRED

• Teamwork with solution architects, development teams, POsand business experts
  
• Knowledge of operational analytics
  
• Knowledge of data modelling
  
• Familiarity with data modelling tools
  
• Knowledge of ETL
  

Requirements

DESIRED

• Good knowledge of the sector (competency checked by theclient)
  

Profiles to Exclude:

• Profile mentioning Power BI only for building reports anddashboards, without data profiling, modelling or rule documentation.
  
• Data engineer or ETL developer profile without demonstratedwriting of functional specifications.
  
• Business analyst profile mentioning data without modellingor ETL on the resume.
  
• Profile whose Azure knowledge rests on training orcertifications, without a named project on Data Lake, Data Factory, Azure SQLor Synapse.
  
• Profile limited to one-off or departmental data projects,without an identifiable large-scale project on the resume.