Sr. SAP ETL Developer
Job Description
Description
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 pipelinesto extract and harmonize data from SAP ECC, S / 4 HANA, and other ERP systems into a unified data platform.
- Collaborate with cross-functional teamsto define data requirements, canonical models, and ensure alignment with business needs across finance, supply chain, and manufacturing.
- Develop and optimize data transformationsusing tools like Azure Data Factory, Alteryx, SQL, and PySpark for analytics and reporting in Microsoft Fabric.
- Ensure data quality and governanceby establishing standards, monitoring data integrity, and resolving data issues.
- Stay current with evolving technologiesin 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 :
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 / 10 / 25. Applications for this job will be accepted for at least 30 days from the posting date.
#J-18808-Ljbffr
Company
Piper Companies
Location
Toronto
Country
Canada
Salary
100.000
URL