SAP BW Consultant (8-10 Years Experience)

About the role

Lumitrio, a technology consulting firm specializing in SAP design, configuration and digital services, is looking for an experienced SAP BW Consultant in Bogotá. The role requires 8 to 10 years of hands-on experience and fluency in English. The consultant designs, develops and maintains SAP BW and BW on HANA data warehousing solutions, turning complex business requirements into scalable data models, extraction strategies and reporting solutions.

Key responsibilities

• Design, develop, enhance and maintain SAP BW and BW on HANA data warehousing solutions.
• Analyze business requirements and turn them into data models, extraction strategies and reporting solutions.
• Maintain core BW objects such as InfoObjects, ADSOs, CompositeProviders, Open ODS Views, Transformations, DTPs, Process Chains and data extraction processes.
• Develop data extraction from SAP FI and SD, and from S/4HANA as a source system.
• Provide production support, incident analysis, root cause analysis and troubleshooting.
• Monitor data loads, process chains and system performance, and optimize queries and data loads.
• Participate in data migration, BW modernization and enhancement projects.
• Support integration of BW with S/4HANA and non-SAP sources, and S/4HANA Embedded Analytics scenarios.
• Collaborate with business stakeholders, solution architects and functional consultants, and mentor junior consultants.

Required profile

• 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.
• Experience in BW production support, maintenance, monitoring and incident management.
• Good understanding of performance tuning for BW objects, data loads and queries.
• Fluency in English is mandatory.

Required skills

• SAP BW and BW on HANA, including ADSOs, CompositeProviders, Open ODS Views, Transformations, DTPs and Process Chains.
• SAP S/4HANA as a source system, CDS Views, ODP and Embedded Analytics.
• SAP FI and SD knowledge, including data extraction from these modules.
• BEx Query Designer and SAP Analysis for Office.
• Preferred: BW modernization and migration experience, large-scale enterprise data warehouse exposure, mentoring experience.