Bilingual (Fr/En) Senior Data Engineer / Architect - Data Migration & Integration

Bilingual (FR/EN) Senior Data Engineer / Architect - Data Migration & IntegrationLocation:
Montreal (Anjou) or Quebec City, QC - Hybrid (3 days onsite)
Duration:
8-month contract with potential for extension or permanent conversion
OverviewS.I. Systems is seeking a Senior Data Engineer / Data Architect to support a large Quebec-based organization undergoing a significant technology and data transformation.
Our client is implementing new ERP and CRM platforms while working to consolidate years of data spread across multiple businesses, legacy databases and operational applications. As part of this transformation, they are establishing a centralized data environment to improve data quality, integration, reporting and future analytics capabilities.
This is a hands‑on, build-from-the-ground‑up opportunity. The successful candidate will help define the data architecture, lead legacy data migration and integration efforts, and establish the foundation for future reporting and AI initiatives. We're looking for someone who is comfortable navigating complex environments, working independently and taking ownership of solutions from design through implementation.
Responsibilities
Design, build and maintain a scalable data architecture and platform to consolidate information across multiple business applications and legacy systems.
Lead hands‑on data extraction, cleansing, mapping, transformation and migration from SQL databases and legacy environments into new ERP and operational platforms.
Develop ETL/ELT pipelines and integrations across CRM, ERP, HRIS, financial and operational systems.
Assess existing data environments, identify gaps and recommend practical technical solutions.
Establish data quality, governance, validation and documentation practices.
Experience with data orchestration and ingestion from core applications (Telephony, CRM, ERP, Operations systems, HRIS, and CCMS).
Develop data models and support Power BI reporting, dashboards and analytics requirements.
Prepare the data environment to support future AI and automation initiatives.
Collaborate with internal stakeholders and external implementation partners to resolve technical challenges and support system implementations.
Must‑Have Qualifications
5+ years of hands‑on data engineering experience, including designing or building data platforms, data warehouses or data lakes.
Strong SQL and Python skills, with experience in data extraction, transformation, integration and migration.
Experience developing ETL/ELT pipelines, data models and integrating multiple enterprise applications.
Hands‑on experience with Microsoft Fabric, Databricks or Snowflake.
Experience with Power BI, including data modelling and reporting.
Ability to work independently, investigate complex data challenges and build solutions in evolving environments.
Bilingual French and English, with availability to work onsite three days per week in Montreal or Quebec City.
Nice‑to‑Have Qualifications
Microsoft Dynamics 365 Business Central or other ERP implementation experience.
Legacy data migration experience, including AS400.
Experience establishing data architecture and governance practices from the ground up.
Exposure to AI, automation or advanced analytics initiatives.
Disclaimer:AI may be used in evaluating candidates.This posting is for an existing vacancy.
#J-18808-Ljbffr