Senior Azure Senior Data Integration Specialist to support the migration and integration of SAP[...]

S I Systems; Toronto, Montreal, Ottawa; On-site; CAD 100,000 - 130,000; Full time

Job summary

A technology solutions provider in Toronto is looking for a Senior Azure Data Integration Specialist to support the migration of SAP data into the Azure cloud environment. The candidate will be responsible for building Azure Data Factory pipelines, implementing data transformation models, and designing secure data architectures. This role requires over 10 years of experience with SAP BI/BW and a strong understanding of Azure services.

Qualifications

• 10+ years of experience with SAP BI/BW.
• Strong understanding of data integration and analytics.
• Experience in Azure cloud services.

Responsibilities

• Build and manage Azure Data Factory pipelines.
• Develop and optimize data transformation models.
• Design secure data architectures.

Skills

SAP BI/BW

Tools

Azure Data Factory

Azure Synapse

Power BI

Azure Purview

Job description

Senior Azure Senior Data Integration Specialist to support the migration and integration of SAP Logistics Platform data into the enterprise Azure cloud environment for a public sector client.

Our valued public sector client is hiring a Senior Azure Senior Data Integration Specialist to support the migration and integration of SAP Logistics Platform data into the enterprise Azure cloud environment.

Background:

The organization is undertaking a large-scale data modernization initiative to transition critical SAP data (Finance, Supply Chain, and Enterprise Asset Management) from its existing SAP BI/BW environment into the Azure cloud. This effort will enable secure, scalable, and high-performance analytics through Azure Synapse and Power BI, forming the foundation for Defence’s enterprise reporting and readiness initiatives. The specialist will lead the design and implementation of Azure-based data pipelines, ensuring seamless, compliant, and optimized integration between SAP and Azure.

Job Tasks:

• Build and manage Azure Data Factory (ADF) pipelines to extract and move SAP BI/BW data (FI, SCM, EAM) into Azure Synapse and ADLS Gen2.
• Develop and optimize data transformation and semantic models to support analytics and enterprise reporting.
• Design secure, scalable data architectures conforming to ITSG-33 and departmental data governance standards.
• Integrate and standardize SAP master data, reference data, and transactional datasets within the Azure ecosystem.
• Enable Power BI reporting by ensuring performant and accurate data availability through Azure services.
• Implement metadata management, data lineage, and cataloging using Azure Purview.
• Collaborate with SAP BI/BW and analytics teams to align migration, testing, and validation activities.
• Support knowledge transfer and internal capability-building for Azure data integration and analytics.

Must Haves:

• SAP BI/BW - 10+ years