Architecte de Données (Senior)

Published on 29/10/2026

About the Position

Context:

In the context of an acquisition and the integration of new activities, our client is undergoing an operational transition aimed at integrating multiple services and systems within its technological environment.

The mandate specifically concerns the "data" aspect of this transformation: strategy and migration of operational and historical data, data integration, report delivery, data quality, and support for technical and Data-BI teams.

The selected individual will be involved from the definition of the strategy to the support for the implementation of solutions.

Responsibilities

• Understand the project objectives and define all data-related needs and requirements.
• Gather, analyze, and document operational needs related to clients, users, and suppliers.
• Identify financial needs and operational and historical data consultation needs.
• Define monitoring, accountability, SLA, and BI needs.
• Identify and document operational and contractual reporting needs.
• Translate contractual, regulatory, and compliance requirements into data requirements.
• Define and propose a data migration strategy specifying the scope of operational and historical data to be migrated, target systems, and sequencing.
• Define migration waves, switch scenarios, system coexistence needs, and decommissioning strategies.
• Define the strategy for delivering operational and contractual reports to various target platforms, including Salesforce and BI solutions.
• Present strategies and recommendations to project stakeholders and governance bodies and contribute to their approval.
• Develop and manage a detailed activity plan covering the data and reporting aspects.
• Conduct detailed analyses necessary for the development and implementation of solutions.
• Perform source-target mapping and define transformation, cleansing, deduplication, and reconciliation rules for data.
• Collaborate closely with development teams for data-related activities.
• Collaborate with Data-BI teams to communicate and specify needs regarding the data ecosystem, including Databricks.
• Document and transmit needs to teams responsible for Salesforce, BI, and data platforms.
• Identify data-related risks and issues and propose appropriate mitigation measures.

Requirements

• Bachelor’s degree in computer science, software engineering, information systems, statistics, or a related field, or equivalent experience.
• Minimum of 10 years of experience in data analysis, management, and architecture.
• Significant experience in end-to-end data migration or conversion mandates, including operational and historical data.
• Experience in merger, acquisition, organizational integration, or system replacement contexts.
• Demonstrated experience in defining migration strategies: scope, sequencing, waves, switch, system coexistence, and decommissioning.
• Experience in presenting and defending recommendations to stakeholders and governance bodies.
• Experience in detailed data analysis: source-target mapping, transformation rules, cleansing, deduplication, and reconciliation.
• Experience collaborating with development and Data-BI teams in an Agile environment.
• Experience in the insurance, assistance, or financial services sectors is an asset.

Technical Skills

• Excellent proficiency in SQL.
• Strong proficiency in conceptual, logical, and physical data modeling.
• Good understanding of data migration and integration methods and tools: ETL/ELT, API, batch loads, and incremental loads.
• Knowledge of cloud data platforms, particularly Databricks.
• Knowledge of historical data archiving, retention, and consultation strategies.
• Mastery of data quality practices: profiling, validation rules, reconciliation controls, and quality indicators.
• Good understanding of BI needs, SLA, performance monitoring, and dashboard design.
• Knowledge of Power BI or an equivalent solution.
• Knowledge of Salesforce is an asset.
• Good understanding of data governance practices.

Regulatory Knowledge

• Knowledge of personal information protection requirements, including Law 25 in Quebec and PIPEDA.
• Understanding of data retention, classification, and security principles.
• Ability to translate regulatory and contractual requirements into functional and technical data requirements.

Desired Certifications

• CDMP (Certified Data Management Professional – DAMA).
• Databricks Certified Data Engineer Associate or Professional.
• Microsoft Certified: Azure Data Engineer Associate or Fabric Analytics Engineer.
• Salesforce Certified Data Architect or Salesforce Certified Administrator.
• CBAP or CCBA (IIBA), or equivalent business analysis certification.
• Certification in personal information protection, including CIPP/C.

Desired Skills

• Excellent strategic thinking and strong synthesis ability, allowing for the transition from a global vision to operational detail.
• Influential leadership and high autonomy to take charge of a complete project aspect.
• Excellent communication and presentation skills with business, technical, and management stakeholders.
• Rigor, organizational skills, and excellent prioritization in a fast-paced environment.
• Strong risk and issue management and anticipation of impacts.
• Ability to design and present concrete and pragmatic recommendations.
• Excellent collaborative spirit with multidisciplinary teams and stakeholders from different organizations.

We Offer

• Competitive salary
• Opportunity to work in a dynamic and innovative environment
• Professional development opportunities
• Collaborative and inclusive work culture

About the Company

Partnering with major companies since 1979, the SII Group is at the heart of the innovation economy, with 16,000 employees, an international presence in 20 countries, and a turnover exceeding 1.621 billion Canadian dollars.

SII Canada offers its clients cutting-edge technical expertise in application development, web and mobile, cybersecurity, and cloud computing. We also provide engineering services, particularly for embedded systems in various industrial sectors. Our ambition is to advance information systems and contribute to the creation of tomorrow's products and services for our clients.

Moreover, inclusion is at the heart of our corporate culture. SII Canada is committed to providing an equitable and respectful work environment that promotes diversity and equal opportunities.