SAP BW Consultant

Lumitrio; Bogotá; On-site; COP 110,000,000 - 190,000,000; Full time

Job summary

Lumitrio, a technology consulting firm, seeks 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, in Bogotá.

The role emphasizes data warehousing architecture, data modeling, development, and production support. You'll translate complex business requirements into scalable data warehousing and reporting solutions, with exposure to BW on HANA and S/4HANA Embedded Analytics.

Qualifications

• 8 to 10 years of hands-on SAP BW experience.
• Strong understanding of BW architecture and data modeling.
• Experience with BW on HANA and S/4HANA Embedded Analytics.
• Experience in BW production support and performance optimization.
• Ability to translate complex requirements into scalable data warehousing solutions.

Responsibilities

• Design, develop, and maintain SAP BW/BW on HANA data warehousing solutions.
• Analyze and translate business requirements into scalable data models and reporting solutions.
• Develop core BW objects: ADSOs, CompositeProviders, Open ODS Views, Transformations, DTPs, and Process Chains.
• Design efficient data extraction and loading from SAP and non-SAP sources.
• Support BW data extraction from SAP FI and SD modules and understand related data structures.
• Work with S/4HANA as a source system and support data extraction via appropriate frameworks.
• Provide BW production support, incident analysis, and performance optimization.
• Collaborate with stakeholders and cross-functional teams; mentor junior consultants.

Skills

SAP BW

BW on HANA

S/4HANA Embedded Analytics

Data warehousing concepts

Data modeling

Performance tuning

BW production support

Data extraction frameworks

CDS Views

ODP

ADSOs

CompositeProviders

Open ODS Views

InfoObjects

Transformations

DTPs

Process Chains

BEx Query Designer

SAP Analysis for Office

Education

Tools

ADSOs

CompositeProviders

Open ODS Views

InfoObjects

Transformations

DTPs

Process Chains

CDS Views

ODP

BEx Query Designer

SAP Analysis for Office

Job description

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 in large-scale enterprise data warehouse environments.
• Strong analytical, troubleshooting, and problem-solving skills.
• Good communication and stakeholder management skills.
• Ability to work independently and collaboratively with distributed technical and functional teams.
• Experience mentoring junior team members and providing technical guidance.