Jobs · OTHR · Illinois

Senior SAP HANA / BW/4HANA Consultant

TALENT Software Services · Chicago, IL · Yesterday
On-siteOTHRFull-time

Role Summary

Design, develop, and implement enterprise data warehousing and reporting solutions using:

  • SAP HANA Modeling
  • SAP BW/4HANA
  • Smart Data Integration (SDI)
  • ETL

Key Responsibilities

  • Gather reporting, analytics, and data integration requirements from business stakeholders.
  • Architect end-to-end SAP BW/4HANA and SAP HANA solutions.
  • Develop and optimize SAP HANA:
    • Calculation Views
    • CDS Views
  • Develop SAP BW/4HANA data models including:
    • ADSOS
    • Composite Providers
    • Open ODS Views
  • Design and implement SDI/ETL processes.
  • Extract, transform, and load data from SAP and non-SAP systems.
  • Develop complex SQL queries, procedures, and scripts.
  • Perform SQL tuning and data processing optimization.
  • Maintain query performance, data load efficiency, and system scalability.
  • Support reporting tools and dashboards by providing clean and reliable data models.
  • Perform unit testing, integration testing, and data validation.
  • Ensure data accuracy and consistency.
  • Prepare technical design documents and data flow diagrams.
  • Support documentation and cross-functional teams.
  • Support SAP BW 7.5 on HANA to SAP BW/4HANA migration.

Required Technical Skills

  • Strong experience in SAP HANA Modeling.
  • Expertise in SAP BW/4HANA Modeling.
  • Hands-on experience with:
    • Smart Data Integration (SDI)
    • ETL processes
  • Experience with ABAP.
  • Advanced knowledge of SQL.
  • Knowledge of SAP BODS.
  • Strong understanding of:
    • Data warehousing concepts
    • Data integration
    • Performance tuning
    • Reporting architectures
  • Experience with SAP Analytics Cloud (SAC).
  • Strong understanding of enterprise data models and analytics solutions.
  • Experience migrating SAP BW 7.5 on HANA to SAP BW/4HANA.
  • Understanding of migration planning and execution.
  • Ability to analyze and optimize existing BW/HANA models during migration.

Minimum Qualifications

  • 10-12+ years of experience with:
    • SAP BW/4HANA
    • SAP HANA
    • SAP Analytics Cloud (SAC)
  • Strong experience designing and implementing enterprise data warehouse solutions.
  • Demonstrated ability to communicate effectively across different organizational levels.
  • Ability to collaborate with:
    • Business stakeholders
    • Technical teams
    • Cross-functional teams
  • Pharma or Manufacturing industry experience is highly desired.

Key Skills / Resume Keywords

  • SAP BW/4HANA
  • SAP HANA
  • SAP HANA Modeling
  • SAP BWSAP BW 7.5
  • BW 7.5 on HANA
  • BW/4HANA Migration
  • SAP Analytics Cloud (SAC)
  • HANA Calculation Views
  • CDS Views
  • ADSOS
  • Composite Providers
  • Open ODS Views
  • Smart Data Integration (SDI)
  • ETL
  • ABAP
  • SQL
  • SQL Performance Tuning
  • Data Warehousing
  • Data Modeling
  • Data Integration
  • Reporting
  • Analytics
  • Performance Optimization
  • Data Validation
  • Technical Documentation

Similar jobs