BI Data Analyst

Genetec

. Conduct in-depth data profiling and analyze source systems to design target implementations for the enterprise data warehouse .

Posted 10/15/2026full-timeMontreal • CanadaMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data profiling, ETL processes, and data warehouse design, with a strong focus on Power BI and Microsoft Fabric. Proficient in SQL query writing and data quality validation, while effectively managing stakeholder relationships and leading engineering teams.

Highest-signal resume keywords

Power BI DevelopmentSQL Query ProficiencyData Warehouse DesignData Migration ManagementBilingual Fluency in French and English

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ProfilingETL Model DevelopmentData Lineage DocumentationComplex SQL QueriesData Cleansing InitiativesERD CreationSource-to-Target MappingDAXRLSData Flow Diagrams

Soft Skills

Stakeholder ManagementCollaborationLeadership

Tools & Technologies

Power BIMicrosoft FabricAzureSQL ServerSSISSSAS Tabular ModelsERP SystemsCRM Systems

Industry Keywords

Business IntelligenceData AnalysisEnterprise IT EnvironmentChange ManagementProject Delivery Frameworks

Tech Stack

Tools & technologies

AzureCloudERPETLFluxMS SQL ServerSQLSSIS

About the role

Key responsibilities & impact

Conduct in-depth data profiling and analyze source systems to design target implementations for the enterprise data warehouse
Create ERDs, source-to-target mappings, data lineage documentation, and functional specifications
Collaborate with data engineers to ensure the accurate implementation of data warehouse enhancements, ETL models, and batch integrations
Develop, maintain, and optimize Power BI dashboards and Microsoft Fabric semantic models
Inspect data using SQL queries and validate data quality
Coordinate data-cleansing initiatives and bulk updates in operational systems
Manage complex data extraction requests and ad hoc analyses to support decision-making
Analyze business processes and assess the impact of changes on reports, pipelines, and stakeholders
Coordinate corrective actions with data analysts and engineers
Design and document batch integrations between operational systems
Advise application and IT infrastructure teams on data modeling
Lead the planning, design, validation, and implementation of data migrations

Requirements

What you’ll need

3–5 or more years of experience as a business intelligence analyst, business process analyst, data analyst, or in a similar role within an enterprise IT environment
Experience working in hybrid environments involving the migration of SQL/SSIS workloads to Microsoft Fabric or an Azure cloud architecture
Previous experience with formal IT change management and project delivery frameworks
Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or a related technical discipline
Fluency in French and English, both written and spoken
Power BI and Microsoft Fabric: hands-on experience with semantic models, DAX, RLS, and Power BI reports
Proficiency in writing complex SQL queries for Microsoft SQL Server, both on-premises and in Azure
Technical understanding of Azure data lakes, SSAS Tabular models, and SSIS/Fabric integration models
Hands-on experience with ERP, CRM, and operational system data
Ability to create ERDs, data flow diagrams, and source-to-target mapping documentation
Proven experience managing business stakeholders and leading engineering teams

Benefits

Comp & perks

Attractive compensation package
Training tuition reimbursement program
Work-life balance with a flexible work schedule
Subsidized meals in our amazing Bistro (Les Cordons Bleus)
Free, unlimited coffee and fruit
Private, free parking for all employees
On-site fitness facility with a personal trainer, as well as multiple health and wellness workshops