Overview
USD 135,000.00 - 145,000.00 per year
Full Time
Skills
Machine Learning (ML)
Enterprise Resource Planning
Collaboration
Finance
Supply Chain Management
Manufacturing
Analytics
Reporting
Data Quality
Data Integrity
Microsoft
SAP ECC
SAP HANA
Data Structure
BAPI
Informatica
Alteryx
Microsoft SSIS
Scripting
Python
PySpark
Orchestration
Cloud Computing
Microsoft Azure
Data Lake
SQL
Database
Data Modeling
Star Schema
Semantics
Modeling
SAP BI
SAP ERP
Data Governance
Regulatory Compliance
Computer Science
Data Science
Information Systems
SAP
Extract
Transform
Load
Job Details
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:
Qualifications of the Senior SAP ETL Developer:
Compensation for the Senior SAP ETL Developer:
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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.