Piper Companies is seeking an 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.

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.

• 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.