Sr. SAP ETL Developer

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.

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

Keywords:

Senior SAP ETL Developer, SAP Data Integration Specialist, SAP Data Engineer, SAP ETL Architect, Enterprise Data Engineer, Cloud Data Integration Engineer, SAP BI Developer, SAP HANA Data Engineer, Azure Data Engineer, SAP S/4HANA Integration Specialist, SAP ECC, SAP S/4HANA, SAP HANA, SAP Datasphere, SAP BW, Microsoft Azure, Azure Synapse Analytics, Azure Data Lake Storage, Microsoft Fabric, OneLake, JD Edwards, SQL Server, Snowflake, AWS, Google Cloud Platform (GCP), Azure Data Factory, Informatica, Alteryx, SSIS, SAP Data Services, SAP Business Data Cloud, PySpark, Apache Spark, Databricks, Microsoft Power BI, SAP CDS Views, SAP ODP, SAP BAPIs, SAP RFCs,

SQL, Python, PySpark, ABAP (for interpretation), JSON, XML, , ETL/ELT, Data Modeling, Canonical Data Models, Data Warehousing, Star Schema, Kimball Methodology, Data Federation, Data Replication, Data Governance, Data Quality, Data Security, PII Compliance, Machine Learning Readiness, Semantic Modeling

This job opens for applications on 6/13/25. Applications for this job will be accepted for at least 30 days from the posting date.

#LI-GM1 #LI-Remote