Kerja Sepenuh Masa, SAP BW Consultant di Ampstek Federal Territory - Maukerja

1. Role Overview

SAP BW Consultant responsible for designing, developing, and supporting data

warehousing and reporting solutions in SAP. The role focuses on data modeling, ETL

processes, reporting, and integration with SAP and non-SAP systems to enable

business analytics and decision-making.

2. Key Responsibilities

A. Data Modeling & Design

 Design and maintain BW data models:

o InfoObjects

o InfoProviders (DSO, ADSO, InfoCube)

o Composite Providers (in BW/4HANA)

 Develop data flow architecture based on business reporting needs

 Optimize models for performance and scalability

B. Data Extraction & ETL (Data Loading)

 Develop and support data extraction mechanisms from:

o SAP ERP (FI, MM, SD, PM, etc.)

o Non-SAP systems

 Work with:

o Extractors (LO Cockpit, FI/CO extractors)

o DataSources, Transformations, DTPs

 Monitor and resolve:

o Data load failures

o Data inconsistencies

C. Reporting & Analytics

 Develop reports using:

o BEx Query Designer

o SAP BO (WebI, Analysis for Office)

o SAP Analytics Cloud (SAC) (if applicable)

 Deliver:

o Financial reports

o Operational dashboards

o KPI-based analytics

 Ensure data accuracy and consistency in reports

D. AMS Support (if applicable)

 Provide L2/L3 support:

o Resolve incidents and service tickets

o Perform root cause analysis (RCA)

 Maintain:

o Data load schedules

o Process chains

 Support business users with reporting issues

E. Performance Optimization

 Optimize:

o Queries for faster execution

o Data models for efficient storage and retrieval

 Work on:

o Aggregates/indexing

o Partitioning (in BW/4HANA)

 Monitor system performance and suggest improvements

F. Integration & Data Management

 Ensure smooth integration with:

o SAP S/4HANA / ECC

o Other SAP modules (FI, SD, MM, PM)

 Handle:

o Data harmonization

o Data cleansing activities

 Support real-time data scenarios (ODP/CDS views)

3. Required Skills

Functional & Technical Skills

 Strong expertise in:

o SAP BW / BW on HANA / BW/4HANA

 Hands-on experience in:

o Data modeling (ADSO, InfoProviders)

o ETL processes (DTP, Transformations)

o BEx Queries

 Good understanding of:

o Business processes (Finance, Supply Chain, etc.)

Tools & Technologies

 Exposure to:

o SAP BO (BusinessObjects)

o SAP Analytics Cloud (SAC) (preferred)

o HANA modeling (Calculation Views – added advantage)

4. Experience Requirement

 3–7 years of SAP BW experience

 Experience in:

o AMS support projects

 Exposure to S/4HANA or BW/4HANA environments (preferred)