Job Openings Senior SAP BW Consultant

About the job Senior SAP BW Consultant

Key Responsibilities:

1. SAP BW Development & Modeling:

  • Design and implement BW data models including InfoObjects, ADSOs, Composite Providers, Open ODS Views, and Aggregates.
  • Develop HANA-optimized data models and transformations to enhance system performance.
  • Configure and maintain MultiProviders, DSO, and InfoCubes for data warehousing solutions.

2. Data Extraction & Integration:

  • Develop and optimize ETL processes for data extraction from SAP and non-SAP systems.
  • Implement Operational Data Provisioning (ODP), SLT, and Direct Extraction for real-time data integration.
  • Work with SAP Data Services, BODS, and HANA Smart Data Integration (SDI) for advanced data extraction.

3. Performance Optimization & HANA Integration:

  • Optimize BW queries and data loads for improved performance on HANA.
  • Utilize HANA Calculation Views and SQL Script-based transformations to enhance reporting capabilities.
  • Implement Near-Line Storage (NLS) and archiving strategies for managing large datasets.

4. Reporting & Analytics:

  • Develop BEx Queries & Analysis for Office (AFO).
  • Integrate SAP BW with SAP Analytics Cloud (SAC) and Power BI for advanced analytics.
  • Support business users and key stakeholders in designing and optimizing reports.

5. System Administration & Support:

  • Monitor BW Process Chains, job schedules, and troubleshoot failures.
  • Conduct SAP BW housekeeping, database tuning, and performance monitoring.
  • Perform SAP BW upgrades and system patches in coordination with the Basis team.

Technical Skills Requirement:

Strong expertise in SAP BW 7.5 on HANA (Backend & Frontend).
Hands-on experience with HANA-native modelling (Calculation Views, CDS Views, AMDP, SQL scripting).
Proficiency in SAP BW Extractors, DataSources, and ODP Framework.
Experience in BEx Query Designer, Analysis for Office (AFO), SAP Analytics Cloud (SAC).
Understanding of HANA Optimization Techniques, HANA SQL, and BW Performance Tuning.
Knowledge of BW/4HANA concepts and migration from BW 7.5 to BW/4HANA is a plus.
Experience with ABAP for BW (Start/End Routines, Transformation Routines, BADIs, Function Modules).
Exposure to Cloud Integration (SAP BTP, SAP DataSphere, SAP CPI, Azure, AWS, or Google Cloud) is beneficial.


Or refer someone