Data Engineer – Intermediate

COFOMO; Montreal; Hybrid; CAD 85,000 - 120,000; Full time

Job summary

COFOMO, a leading Canadian consulting firm in Montreal, seeks an Intermediate Data Engineer to design and maintain data pipelines and infrastructure supporting analysis and decision-making. You will analyze diverse data sources, implement ETL/ELT patterns, and develop high-performance data flows using Microsoft Fabric, while ensuring data quality, security, and governance.

Fluency in French is required. You will collaborate with cross-functional teams to align data solutions with Fabric, Azure

Qualifications

• Fluency in spoken and written French.
• Experience in designing, developing, and maintaining data integration and management solutions.
• Expertise with Microsoft Fabric, Azure DevOps, and CI/CD practices.
• Knowledge of data integration, interoperability, governance, security, and data quality.
• Experience in designing data flows, analytical models and traceability mechanisms.
• Proficiency in Microsoft Purview and concepts of classification, lineage, and access control.

Responsibilities

• Design, develop, and maintain data pipelines and infrastructure to support analysis, reporting, and decision support.
• Analyze data sources, define ETL/ELT integration logics, and apply design patterns.
• Develop high-performance flows in Microsoft Fabric and structure data in models.
• Implement data quality controls and contribute to testing.
• Ensure integration, security and confidentiality of data.
• Collaborate with teams to ensure consistency of solutions.
• Document solutions and support data product deployment.

Skills

Data integration

ETL/ELT design

Data modeling

Data governance

Security & data quality

Proficiency with Fabric

Azure DevOps

CI/CD practices

Purview concepts

French fluency

Tools

Microsoft Fabric

Azure DevOps

CI/CD

Microsoft Purview

Job description

# Data Engineer – IntermediateMontrealHybridSoftware Development and EngineeringApplyWith over 30 years of recognized expertise, COFOMO is now a leading Canadian consulting firm specializing in digital and artificial intelligence. Supported by more than 3,000 experts, 10 Centers of Excellence, and 4 offices across the country, we are uniquely positioned to successfully guide our clients through their transformations. Both strategic and tactical, we help organizations across a wide range of industries thrive in today’s rapidly evolving world.## Our promiseHelp our clients succeed and maximize the impact of their transformation initiatives, turning them into powerful drivers of growth and innovation.## Job description**Here's a brief overview of the tasks and responsibilities you'll have :** • Design, develop, and maintain the data pipelines and infrastructure needed to support analysis, reporting, and decision support; • Analyze data sources, define ETL/ELT integration logics, and apply recommended design patterns; • Develop high-performance flows in Microsoft Fabric and structure data in appropriate models; • Implement data quality controls and contribute to unit and integrated testing; • Ensure the integration, security and confidentiality of clinical and administrative data; • Manage code, lineage, and deployments using Azure DevOps and CI/CD practices; • Document solutions, share knowledge, and support the operationalization of data products; • Collaborate with relevant teams and stakeholders to ensure consistency of solutions; • Define data integration and interoperability guidelines between source systems, Microsoft Fabric, and analytical products; • Design event-oriented and metadata-driven integration patterns as well as batch and near-real-time processing mechanisms; • Establish rules for circulation, transformation, traceability, reconciliation, and error handling; • Determine the mechanisms for technical governance, classification, lineage, and access control; • Ensure alignment of solutions with Microsoft Fabric, Azure, Microsoft Purview, Azure DevOps, and CI/CD standards; • Produce flow models, data contracts, technical decisions, standards and integration templates; • Evaluate dependencies between data sources and recommend sustainable integration approaches; • Review solutions proposed by development teams and ensure end-to-end consistency; • Measure performance, resilience, scalability and operationalization issues; • Support teams in the implementation of orientations and the resolution of complex technical issues **The profile we are looking for is as follows:** • Fluency in spoken and written French; • Experience in designing, developing, and maintaining data integration and management solutions; • Expertise with Microsoft Fabric, Azure DevOps, and CI/CD practices; • Knowledge of the concepts of data integration, interoperability, governance, security, and data quality; • Experience in designing data flows, analytical models and traceability mechanisms; • Be proficient in Microsoft Purview and the concepts of classification, lineage, and access control