Sr. SAP ETL Developer

Zachary Piper Solutions; Toronto; On-site; CAD 135,000 - 145,000; Full time

Job summary

An established construction company in Toronto is seeking a Senior SAP ETL Developer. This role involves designing ETL pipelines and integrating SAP and non-SAP data into a cloud-based platform to support analytics and reporting. Ideal candidates will have 8-10 years of experience with SAP data structures and strong expertise in enterprise ETL tools like Azure Data Factory and Alteryx. Competitive salary and comprehensive benefits package offered.

Benefits

Comprehensive Benefits: Medical, Dental, Vision, 401K, PTO

Qualifications

• 8–10+ years of hands-on experience with SAP ECC and S / 4 HANA data structures.
• Strong expertise in enterprise ETL tools.
• Proficiency in SQL and scripting languages.

Responsibilities

• Design and implement scalable ETL pipelines.
• Collaborate with cross-functional teams for data requirements.
• Develop and optimize data transformations.

Skills

SAP ECC and S / 4 HANA data structures

Azure Data Factory

SQL

Python

Data governance

Education

Bachelor’s degree in Computer Science, Data Science, Information Systems, or related field

Tools

Azure Data Factory

Informatica

Alteryx

SQL

PySpark

Job description

Piper Companies is seeking a Senior SAP ETL Developer for an established construction company based in Toronto, ON. The Senior SAP ETL Developer will be responsible for designing and leading the integration of SAP and non-SAP data into a cloud-based enterprise data platform to support analytics, reporting, and machine learning initiatives.

Responsibilities of the Senior SAP ETL Developer :

• Design and implement scalable ETL pipelines to extract and harmonize data from SAP ECC, S / 4 HANA, and other ERP systems into a unified data platform.
• Collaborate with cross-functional teams to define data requirements, canonical models, and ensure alignment with business needs across finance, supply chain, and manufacturing.
• Develop and optimize data transformations using tools like Azure Data Factory, Alteryx, SQL, and PySpark for analytics and reporting in Microsoft Fabric.
• Ensure data quality and governance by establishing standards, monitoring data integrity, and resolving data issues.
• Stay current with evolving technologies in the SAP and Microsoft data ecosystems to inform architectural decisions and tool selection.

Qualifications of the Senior SAP ETL Developer :

• 8–10+ years of hands-on experience with SAP ECC and S / 4 HANA data structures and integration methods (ODP, CDS views, BAPIs, etc.).
• Strong expertise in enterprise ETL tools such as Azure Data Factory, Informatica, Alteryx, or SSIS.
• Proficiency in SQL and scripting languages (Python, PySpark) for data transformation and orchestration.
• Experience with cloud-native data platforms, especially Microsoft Azure (Synapse, Data Lake, SQL DB, OneLake).
• Solid understanding of data modeling concepts including star schema, Kimball methodology, and semantic modeling.
• Familiarity with SAP Datasphere, SAP BW, and integration of non-SAP ERP systems.
• Knowledge of data governance, security, and compliance best practices, including handling of PII.
• Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field; relevant certifications are a plus.

Compensation for the Senior SAP ETL Developer :

• Salary: $135,000-$145,000
• Depending on experience
• Comprehensive Benefits: Medical, Dental, Vision, 401K, PTO, Sick Leave if required by law