Senior SAP ETL Developer

Carlisle Weatherproofing Technologies (CWT) is a leading supplier of building envelope solutions that effectively drive energy efficiency and sustainability in commercial and residential applications. We are looking for a Senior SAP ETL Developer to join our IT team working remotely.

 

Job Summary:

The Senior SAP ETL Developer will be responsible for leading the integration of SAP data—primarily from SAP ECC and SAP S/4 HANA—into our unified, cloud-based Enterprise Data Platform (EDP). This role requires deep expertise in SAP data structures, combined with strong experience in enterprise ETL development using cloud-native technologies.

 

As a Senior SAP ETL Developer, you will play a key role in designing and implementing scalable data pipelines that extract, transform, and harmonize data from SAP systems into canonical models for analytics, reporting, and machine learning use cases. You will partner closely with data engineers, architects, and SAP subject matter experts to ensure accuracy, performance, and alignment with business requirements.

 

This role will support a variety of high-impact projects focused on enabling cross-ERP visibility, operational efficiency, and data-driven decision-making across finance, manufacturing, and supply chain functions. Your contributions will help standardize critical datasets and accelerate the delivery of insights across the organization.

 

This is a remote position open to candidates based in Canada or the United States.

 

Duties and Responsibilities:

• SAP Data Integration (70%):
  • Architect and implement robust ETL pipelines to extract data from SAP ECC, SAP S/4 HANA, SAP HANA, and SAP Datasphere using best-practice integration methods (e.g., ODP, CDS views, RFCs, BAPIs).
  • Analyze and interpret SAP’s internal data models (e.g., tables like BKPF, BSEG, MARA, EKPO) and work closely with SAP functional and technical teams.
  • Work with SAP Datasphere (SAP Data Warehouse Cloud) to federate or replicate SAP data for consumption in the EDP (highly desired).
  • Review or interpret ABAP logic when necessary to understand legacy transformation rules and business logic (nice to have).
  • Lead the end-to-end data integration process from SAP ECC, ensuring deep alignment with the EDP’s design and downstream data usage needs.
  • Leverage knowledge of HANA Data Warehouse and SAP BW to support historical reporting and semantic modeling.
  • Integrate data from non-SAP ERP systems such as JD Edwards and other legacy systems into a unified data platform.
  • Transform and model data for analytics within Microsoft Fabric, including OneLake, Dataflows Gen2, and Synapse Data Warehouse.
  • Establish data quality, security, and governance standards within integration workflows.
  • Document technical processes and contribute to the ongoing improvement of data integration frameworks.
  • Stay current on SAP and Microsoft data ecosystem developments to inform future architecture and tools.

• Enterprise ETL and Cloud Data Engineering (30%):
  • Design and build robust, scalable ETL/ELT pipelines to ingest data into Microsoft cloud using tools such as Azure Data Factory, or Alteryx.
  • Automate data movement from SAP into Azure Data Lake Storage / OneLake, enabling clean handoffs for consumption by Power BI, data science models, and APIs.
  • Build data transformations in SQL, Python, and PySpark, leveraging distributed compute (e.g., Synapse or Spark pools).
  • Work closely with cloud architects to ensure integration patterns are secure, cost-effective, and meet performance SLAs.

• Data Quality and Governance:
  • Establish and enforce data quality standards and governance practices to ensure data integrity and consistency across integrated systems.
  • Monitor, troubleshoot and address data quality issues, implementing solutions as needed.

• Collaboration and Communication:
  • Collaborate with data modelers to define canonical enterprise models and develop mappings from SAP source tables.
  • Work closely with cross-fu