Job descriptionRichmond Northeast, Canada | Posted on 03/19/2026
We are looking for an experienced SAP BW (Business Warehouse) Developer to join our team. The SAP BW Developer will be responsible for designing, developing, and maintaining the SAP BW solutions that support data warehousing, reporting, and analytics across the organization. This role involves working closely with business analysts, data engineers, and business stakeholders to ensure that data models, ETL processes, and reports meet the company's requirements.
Key Responsibilities
SAP BW Development and Modeling
Design, develop, and implement SAP BW data models, InfoProviders, InfoObjects, and DataStore Objects (DSOs) to support reporting needs.
Build and maintain Extract, Transform, Load (ETL) processes to load data into SAP BW from various source systems, including SAP and non-SAP sources.
Create complex queries in BEx Query Designer to enable advanced reporting and analytics.
Data Extraction and Integration
Develop and optimize data extraction processes, including data extraction from SAP ECC, S/4HANA, and other sources.
Work on integration with SAP HANA, SAP Data Services, and other ETL tools, ensuring efficient data flow and transformation.
Perform data extraction, data transformation, and data loading using standard SAP BW tools and processes.
Performance Tuning and Optimization
Conduct performance tuning for data loading and query processing in SAP BW.
Optimize BW data models and ETL processes to improve the overall system performance and response time.
Monitor and resolve performance bottlenecks within BW processes and data retrieval.
Reporting and Analytics
Develop BW reports and dashboards to provide actionable insights for business users.
Collaborate with business users to understand their reporting needs and translate them into technical requirements.
Design and deliver reports using SAP BW reporting tools, including BEx Analyzer, Analysis for Office, and SAP BW/4HANA.
Support and Troubleshooting
Provide production support for SAP BW, including troubleshooting and resolving data load failures, data quality issues, and performance problems.
Analyze and resolve issues with data inconsistencies, incorrect data loads, and reporting errors.
Ensure data integrity and accuracy within BW applications and outputs.
Qualifications
Experience: Minimum 5+ years of experience in SAP BW development, including experience with SAP BW on HANA or SAP BW/4HANA.
Strong experience in data modeling, ETL processes, and BW data extraction.
Hands‑on experience with BEx Query Designer and Analysis for Office.
Technical Skills
Proficiency in SAP BW tools, including InfoObjects, InfoCubes, DSOs, Composite Providers, and Open ODS Views.
Solid knowledge of SAP ECC or SAP S/4HANA data sources.
Strong SQL skills and experience with data warehousing concepts.
Familiarity with SAP Data Services, SAP HANA Studio, and ABAP coding is a plus.
Soft Skills
Strong analytical and problem‑solving skills.
Excellent communication skills for effective interaction with both technical and business teams.
Ability to manage multiple priorities in a fast‑paced environment.
Preferred Qualifications
SAP BW/4HANA certification or SAP HANA certification.
Experience with SAP Analytics Cloud or SAP Lumira.
Knowledge of SAP Fiori or SAP UI5 for report visualization.
#J-18808-Ljbffr