SAP BW/4HANA Consultant

Job Overview
We are seeking an experienced SAP BW/4HANA Consultant with strong expertise in SAP HANA Modeling, SAP BW/4HANA, data integration, ABAP, SQL, and SAP Analytics Cloud (SAC). The consultant will design, develop, and implement scalable data warehousing and reporting solutions while integrating data from SAP and non-SAP source systems.

Location: Chicago, IL — Day 1 Onsite
Contract: 12+ Months

Key Responsibilities

- Gather and analyze reporting, analytics, and data integration requirements from business stakeholders.

- Design end-to-end SAP BW/4HANA and SAP HANA solutions aligned with business and technical requirements.

- Develop and optimize SAP HANA Calculation Views, CDS Views, and SAP BW/4HANA data models, including ADSOs, Composite Providers, and Open ODS Views.

- Design and implement SAP Smart Data Integration (SDI) and ETL processes for SAP and non-SAP systems.

- Develop and optimize complex SQL queries, procedures, and scripts.

- Perform performance tuning for queries, data loads, and overall system scalability.

- Support reporting tools and dashboards by developing clean, reliable, and optimized data models.

- Perform unit testing, integration testing, and data validation.

- Troubleshoot data integration and performance-related issues.

- Create technical design documents, data flow diagrams, and support documentation.

- Support BW 7.5 on HANA to BW/4HANA migration activities.

- Collaborate effectively with technical teams, business users, and other stakeholders.

Requirements

Required Skills; Strong hands-on experience with SAP HANA Modeling; Expertise in SAP BW/4HANA Modeling; Hands-on experience with SAP Smart Data Integration (SDI) and ETL processes; Strong experience with ABAP; Advanced SQL skills; Experience with SAP BusinessObjects Data Services (BODS); Strong understanding of data warehousing concepts and architectures; Experience with performance tuning and optimization; Experience with SAP Analytics Cloud (SAC); Experience with BW 7.5 on HANA to BW/4HANA migration; Strong analytical, communication, and problem-solving skills; Qualifications; 10–12+ years of experience with SAP BW/4HANA, SAP HANA, and SAC; Proven experience designing and implementing enterprise data warehousing solutions; Ability to communicate effectively across different levels of an organization; Pharma or Manufacturing industry experience is highly desired; Ability to work onsite in Chicago, IL from Day 1