SAP BW Consultant

Fluency in English and 8 to 10 years of relevant experience are mandatory requirements for this role

About Lumitrio

Lumitrio is a technology consulting firm specializing in SAP design, configuration, and digital services for global clients. We help organizations improve business processes and support enterprise transformation through technology and consulting expertise.

Position Overview

We are seeking an experienced SAP BW Consultant with 8 to 10 years of hands-on experience in SAP BW 7.5, BW on HANA, and SAP S/4HANA Embedded Analytics.

The ideal candidate will have strong expertise in SAP Business Warehouse architecture, data modeling, development, performance optimization, production support, and maintenance. The successful candidate will translate complex business requirements into scalable enterprise data warehousing and reporting solutions.

Strong experience in SAP BW production support, troubleshooting, incident resolution, and BW on HANA environments is required. Exposure to S/4HANA data extraction, CDS Views, ODP, and Embedded Analytics is highly desirable.

Key Responsibilities

• Design, develop, enhance, and maintain SAP BW and BW on HANA data warehousing solutions.
• Analyze business requirements and translate them into scalable data models, extraction strategies, and reporting solutions.
• Develop and maintain core SAP BW objects, including:
• Advanced DataStore Objects (ADSOs)
• Design and implement efficient data extraction and loading processes from SAP and non-SAP source systems.
• Develop data extraction solutions from SAP FI and SD modules, applying a strong understanding of the relevant business processes and data structures.
• Work with SAP S/4HANA as a source system and support data extraction using appropriate frameworks and technologies.
• Provide SAP BW production support and maintenance, including incident analysis, root cause analysis, troubleshooting, and resolution.
• Monitor data loads, process chains, and system performance, proactively addressing failures and bottlenecks.
• Analyze and resolve BW query, data load, and performance issues, and implement appropriate optimization strategies.
• Participate in data migration, BW modernization, and enhancement initiatives.
• Support the integration of SAP BW with S/4HANA and non-SAP source systems.
• Support SAP S/4HANA Embedded Analytics scenarios, including reporting and analytical requirements based on CDS Views.
• Collaborate with business stakeholders, solution architects, functional consultants, and cross-functional technical teams.
• Lead or contribute to technical design discussions, effort estimates, solution reviews, and implementation planning.
• Prepare and maintain technical documentation, design specifications, and operational procedures.
• Mentor junior consultants and contribute to the adoption of SAP BW development standards and best practices.

Required Qualifications

SAP BW and BW on HANA

• 8 to 10 years of hands-on experience in SAP BW and BW on HANA.
• Strong understanding of data warehousing concepts and SAP BW architecture.
• Strong hands-on experience with ADSOs, CompositeProviders, Open ODS Views, InfoObjects, Transformations, DTPs, and Process Chains.
• Experience designing and implementing end-to-end BW data flows.
• Strong understanding of SAP BW data extraction frameworks.
• Experience in BW production support, maintenance, monitoring, and incident management.
• Good understanding of performance tuning and optimization for BW objects, data loads, and queries.

SAP S/4HANA

• Experience working with SAP S/4HANA as a source system.
• Good understanding of CDS Views and their role in analytics and data extraction.
• Experience with ODP-based extraction frameworks.
• Understanding of SAP S/4HANA Embedded Analytics.
• Ability to support integration between S/4HANA and SAP BW or BW on HANA.

SAP Functional Knowledge

• Good understanding of key SAP functional modules, particularly SAP Financial Accounting (FI) and Sales and Distribution (SD).
• Hands-on experience extracting data from SAP FI and SD.
• Ability to understand functional requirements and translate them into appropriate BW data models and extraction solutions.

Reporting and Analytics

• Experience with BEx Query Designer.
• Experience with SAP Analysis for Office (AO).
• Good understanding of SAP BW reporting and analytical concepts.
• Ability to develop and support reporting solutions based on business requirements.

Preferred Qualifications

• Experience in SAP BW modernization and migration initiatives.
• Experience working