[Hiring] BI Data Analyst at Genetec

Your team dynamics:

We are seeking a highly skilled Business Intelligence Data Analyst to join our Information Architecture and Analytics team. In this role, you will serve as a strategic link between our key business processes, operational source systems, and the enterprise data warehouse ecosystem.

As a Business Intelligence Data Analyst, you will focus on data profiling, solution architecture design, impact analysis, and implementation management. You will primarily work in a largely Microsoft-based environment, including on-premises SQL servers, SSIS, SSAS, databases and data lakes in the Azure cloud, as well as Microsoft Fabric and Power BI. While specialized data engineers will handle the pipeline behind the scenes and migration development, you will design blueprints, write technical documentation, write analytical SQL queries, create semantic models and Power BI reports for business users, and lead the engineering team throughout the implementation.

Your day at a glance:

Data warehouse solution design and technical supervision

• Perform in-depth data profiling and analyze the characteristics, patterns, and architecture of source systems to design target implementations for our enterprise data warehouse ecosystem.
• Write comprehensive technical documents, including entity-relationship diagrams (DERs), source-target mappings, data traceability documentation, and functional specifications.
• Collaborating with a team of data engineers to ensure that data store additions, ETL models, and designed batch integrations are implemented accurately and according to plan.

Power BI, semantic modeling, and operational support

• Develop, maintain and optimize robust, enterprise-grade Power BI dashboards and Microsoft Fabric semantic models (including DAX calculations, relationships and security policies).
• Profile and inspect data using SQL SELECT queries on on-premises databases and Azure/Fabric SQL analytics endpoints to guide engineering decisions and validate data quality.
• Analyze, coordinate and execute targeted data cleansing initiatives as well as bulk data update operations within operational systems, as needed.
• Manage complex requests for ad-hoc data extraction and analysis to support decision-making at the management and departmental levels.

Analysis of business processes and management of downstream impacts

• Analyze constantly evolving business processes to determine their structural impact on our entire reporting and data ecosystem.
• Conduct proactive impact analyses when the behavior of source systems, application patterns or structures change, identifying downstream reports, business processes and key stakeholders affected.
• Ensure cross-functional coordination with data analysts and data engineers to prioritize, execute, and validate corrective actions required for all affected pipelines and reports.

Batch integrations and IT solutions consulting

• Analyze, design and prepare technical integration documentation for batch integrations between operational systems, overseeing the execution of data engineering tasks.
• Collaborating with internal IT application and infrastructure teams during the design phase of new software solutions, providing analyses to flag background designs or schemas that violate best practices in data modeling.
• Lead the analytical planning, design, validation and implementation of data migration projects during the introduction of new enterprise solutions, guiding data engineers throughout execution.

What makes you an excellent candidate:

• 3 to 5 years or more 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
• Prior experience with formal frameworks for IT change management and project delivery
• Bachelor’s degree in computer science, software engineering, information technology, or a related technical discipline
• A Master’s degree or MBA is considered an asset.
• Fluency in French and English, both spoken and written (this position requires interaction with our international colleagues and clients)

Your technical expertise:

• Power BI and Microsoft Fabric: Hands-on experience developing semantic models, the DAX language, row-level security (RLS), and Power BI reports within a Fabric ecosystem
• Relational databases and SQL: Advanced proficiency in writing complex SQL queries for data profiling, source validation, and schema inspection on Microsoft SQL Server (on-premises and Azure)
• Knowledge of enterprise architecture: Technical understanding of Azure data lakes, SSAS tabular models, and SSIS/Fabric data integration models
• Domain knowledge: Practical experience using essential business data from Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), and operational systems.
• Data modeling and systems design: Ability to create formal entity-relationship diagrams (ERDs), data flow diagrams, and source-target mapping documentation.
• Leadership and stakeholder management: Excellent communication skills, with a proven track record of effectively managing business stakeholders and leading engineering teams throughout technical implementation.

This is what we offer!

• Attractive compensation package
• Training Expense Reimbursement Program
• Work-life balance thanks to a flexible working schedule
• Subsidized meals at our amazing Bistro (Les Cordons Bleus)
• Unlimited free coffee and fruit
• Free parking space for all employees
• On-site fitness center with personal trainer, as well as several health and wellness workshops

If you would like to know what the work environment is like at Genetec, here is the link to our company video: 

We know that diverse backgrounds and experiences bring great value to our teams. Even if you don’t meet all the requirements, we encourage you to apply – your profile might surprise us!

Thank you for your application, but please note that only shortlisted candidates will be contacted. Headhunters and recruitment agencies are not permitted to submit CVs through this website or directly to hiring managers.

—————————————————————————————————

Job Overview:

We are seeking a high-caliber Business Intelligence Data Analyst to join our Information Architecture & Analytics team. In this role, you will serve as the strategic bridge between our core business processes, operational source systems, and enterprise data warehouse ecosystem. 

As a BI Data Analyst, your focus will be on data profiling, solution architecture design, impact analysis, and delivery management. You will work extensively across a Microsoft-heavy environment—encompassing on-premises SQL Servers, SSIS, SSAS, Azure Cloud Databases/Data Lakes, and Microsoft Fabric/Power BI. While dedicated Data Engineers own the backend pipeline and migration development, you will design the blueprints, author technical documentation, write analytical SQL queries, build business-facing Power BI semantic models and reports, and direct the engineering team through implementation. 

Your day at a glance:

Data Warehouse Solution Design & Engineering Oversight 

• Perform deep-dive data profiling and analyze source system characteristics, schemas, and architecture to design target implementations for our enterprise data warehouse ecosystem
• Author comprehensive technical artifacts, including Entity-Relationship Diagrams (ERDs), source-to-target mapping, data lineage documentation, and functional specifications
• Collaborate with a team of Data Engineers to ensure designed warehouse additions, ETL patterns, and batch integrations are implemented accurately and according to plan

Power BI, Semantic Modeling & Operational Support 

• Develop, maintain, and optimize robust, enterprise-grade Power BI dashboards and Microsoft Fabric semantic models (including DAX calculations, relationships, and security policies)
• Profile and inspect data using SQL SELECT queries across on-premises databases and Azure/Fabric SQL analytics endpoints to guide engineering decisions and validate data quality
• Analyze, coordinate, and execute targeted data cleanup initiatives and mass data update operations within operational systems when required
• Handle complex ad-hoc data extract and analytical requests to support executive and departmental decision-making 

Business Process Analysis & Downstream Impact Management 

• Analyze evolving business processes to determine their structural impact on our broader reporting and data ecosystem
• Conduct proactive impact analyzes when source system behaviors, schemas, or application structures change—identifying affected downstream reports, business processes, and key stakeholders
• Coordinate cross-functionally with Data Analysts and Data Engineers to prioritize, execute, and validate the required remediation work across affected pipelines and reports

Batch Integrations & IT Solutions Consulting 

• Analyze, design, and prepare technical integration documentation for batch Integrations between operational systems, overseeing data engineering execution
• Partner with internal IT application and infrastructure teams during the design phase of new software solutions, providing analytical input to flag backend designs or schemas that violate data modeling best practices
• Lead the analytical planning, designing, validation & implementation for data migration projects when introducing new enterprise solutions, guiding data engineers through execution

What makes you a great fit:

• 3–5+ years of experience in a Business Intelligence Analyst, Business Process Analyst, Data Analyst or similar role within an enterprise IT environment

• Experience working in hybrid environments transitioning from SQL/SSIS workloads into Microsoft Fabric or Azure cloud architecture
• Prior 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 
• Master’s degree or MBA considered an asset 

• Fluent in French and English, both verbal and written (this role requires interaction with our international collaborators and customers)

Your technical expertise:

• Power BI & Microsoft Fabric: Hands-on experience developing semantic models, DAX, row-level security (RLS), and Power BI reports within a Fabric ecosystem
• Relational Databases & SQL: Strong proficiency in writing complex SQL queries for data profiling, source validation, and schema inspection across Microsoft SQL Server (On-Premises & Azure)
• Enterprise Architecture Familiarity: Technical understanding of Azure Data Lakes, SSAS tabular models, and SSIS/Fabric data integration patterns
• Domain Knowledge: Hands-on experience working with core business domain data originating from Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), and operational business systems
• Data Modeling & System Design: Ability to create formal ERDs, data flow diagrams, and source-to-target mapping documentation
• Leadership & Stakeholder Management: Excellent communication skills with a track record of effectively managing business stakeholders and directing engineering teams through technical delivery

Let’s talk perks!

• Attractive compensation package
• Training Tuition Reimbursement Program
• Work-life balance with a flexible working schedule
• Subsidized meals in our amazing Bistro (Les Cordons Bleus)
• Free, unlimited coffee and fruits
• Private, free parking for all employees
• Onsite fitness facility with personal trainer, and multiple wellness and health workshops

If you’d like to see what the work environment at Genetec looks like, check out our corporate video: 

We know that diverse backgrounds and experiences bring great value to our teams. Even if you don’t think you tick all the boxes, we still encourage you to apply – your profile may surprise us!

Thank you for your application, but please note that only selected candidates will be contacted. Head-hunters and recruitment agencies may not submit resumés/CVs through this Web site or directly to managers.