Piper Companies is seeking a Senior SAP ETL Developer to design and lead the integration of SAP and non-SAP data into a cloud-based enterprise data platform to support analytics, reporting, and machine learning initiatives for an established construction company.
Requirements
- 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.
Responsibilities
- 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.
- 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.
- Collaborate with cross-functional teams to define data requirements, canonical models, and ensure alignment with business needs across finance, supply chain, and manufacturing.
Other
- Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field; relevant certifications are a plus.
