SAP BW Developer

iLink Digital•Richmond, BC

106d

About The Position

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 iLink's requirements.

Requirements

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.
Proficiency in SAP BW tools, including InfoObjects, InfoCubes, DSOs, CompositeProviders, and Open ODS Views.
Solid knowledge of SAP ECC or SAP S/4HANA data sources.
Strong SQL skills and experience with data warehousing concepts.
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.

Nice To Haves

Familiarity with SAP Data Services, SAP HANA Studio, and ABAP coding is a plus.
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.

Responsibilities

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.
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.
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.
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.
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.