SAP BW Consultant

Siren Infotech Software

Full Time

Experience: 8 Years

Location: India

Salary: 120000 - 150000 INR Per Month

Job Description

In this role, you will design, architect, and deliver robust SAP BW and ABAP-based data solutions across complex enterprise landscapes — spanning SAP BW/4HANA, SAP S/4HANA, SAP HANA, and legacy SAP ECC environments. You will build and optimize custom ABAP programs, BW data models, CDS Views, and extraction frameworks that power enterprise reporting, analytics, and data migration initiatives.
You will collaborate closely with business stakeholders, SAP functional consultants, enterprise architects, and data engineering teams to translate business requirements into high-quality, scalable technical solutions. As a trusted technical advisor and client-facing SME, you will contribute to solution design, code quality standards, and the continuous evolution of our SAP data engineering practice.
This is a high-impact role offering the opportunity to influence architecture decisions, mentor junior engineers, and drive the modernization of SAP data landscapes through clean core principles, CDS-based development, and cloud-native integration patterns. If you thrive at the convergence of SAP BW expertise and advanced ABAP engineering, this is your platform to lead.

SAP BW & Data Modeling :

  • 7–10 years of hands-on SAP BW/4HANA or BW-on-HANA experience across full project lifecycles — from requirements gathering through design, build, test, and go-live.
  • Deep expertise in SAP BW/4HANA data modeling: Advanced DSOs (Standard, Write-Optimized, Direct Update), CompositeProviders, Open ODS Views, Hybrid Providers, and the Layered Scalable Architecture (LSA++) design pattern.
  • Strong knowledge of BW process chains, data transfer processes (DTPs), transformations, and delta load management for high-volume, production-grade data warehousing.
  • Hands-on experience building and maintaining BEx Queries, including restricted/calculated key figures, structures, exceptions, conditions, and variables for enterprise reporting.
  • Solid understanding of SAP HANA native modelling concepts: Calculation Views, SQL procedures, and in-memory data processing relevant to BW-on-HANA and BW/4HANA environments.
  • Experience in SAP BW/4HANA migration and landscape transformation — converting legacy BW objects, managing deprecation of InfoCubes/MultiProviders, and aligning to LSA++ architecture.

SAP S/4HANA & Ecosystem Knowledge :

  • Strong understanding of SAP S/4HANA architecture, data structures, and key business domains: Finance (FI/CO), Logistics (MM/SD/PP), and their impact on BW extraction and data modeling.
  • Familiarity with SAP S/4HANA embedded analytics and its interaction with BW: Virtual InfoProviders, ODP extraction from S/4HANA, and CDS-based reporting.
  • Working knowledge of SAP DataSphere, SAP Analytics Cloud (SAC), and SAP BTP integration patterns as adjacent platforms to BW/4HANA and S/4HANA landscapes.
  • Experience with SAP Landscape Transformation (SLT) and other real-time replication tools for data movement between SAP systems and target analytics platforms.

Integration & Cloud Awareness :

  • Understanding of cloud-native data integration patterns: REST APIs, OData services, and middleware tools (Azure Data Factory, SAP Integration Suite) for connecting SAP with cloud platforms.
  • Familiarity with at least one major cloud platform — Azure, AWS, or GCP — particularly in the context of SAP-to-cloud data integration and extraction.
  • Knowledge of DevOps and CI/CD practices for ABAP development: gCTS (Git-based Change and Transport System), ABAP Test Cockpit (ATC), and pipeline-based quality gates.

Preferred Qualifications :

  • SAP Certified Application Associate — SAP BW/4HANA (current certification strongly preferred).
  • SAP Certified Development Associate — ABAP with SAP NetWeaver or SAP S/4HANA.
  • Experience with SAP HANA native development: Calculation Views, Analytic Privileges, and Smart Data Access (SDA) for federated data access.
  • Hands-on experience with SAP DataSphere data builders, data flows, and entity-relationship modelling as a next-generation complement to BW/4HANA.
  • Familiarity with Python or SQL scripting for data transformation tasks in hybrid SAP/cloud data pipelines.
  • Prior experience in a Big 4 consulting, global system integrator (GSI), or technology advisory environment with client-facing SAP delivery responsibilities.
  • Exposure to SAP S/4HANA Cloud implementations and the clean core extensibility model (side-by-side, in-app), including the ABAP RESTful Application Programming Model (RAP).
  • Experience with real-time data replication strategies using SAP SLT, ODP streaming, or Kafka-based connectors for near-real-time data warehouse refresh scenarios.


Certifications (Valued) :

  • Certification   Issuing Body
  • SAP Certified Application Associate – SAP BW/4HANA    SAP SE
  • SAP Certified Development Associate – ABAP with SAP NetWeaver    SAP SE
  • SAP Certified Development Associate – SAP S/4HANA (ABAP for S/4HANA)    SAP SE
  • SAP Certified Application Associate – SAP S/4HANA    SAP SE
  • SAP Certified Technology Associate – SAP HANA 2.0 (SPS07)    SAP SE
  • Microsoft Azure Data Engineer Associate (DP-203)    Microsoft
  • AWS Certified Data Engineer – Associate    Amazon Web Services
  • Google Professional Data Engineer    Google Cloud

 

 

Responsibilities Duties:

  • Design, develop, and maintain SAP BW/4HANA and BW-on-HANA data models, including Advanced DSOs, InfoCubes, CompositeProviders, Hybrid Providers, Open ODS Views, and DataStore Objects.
  • Develop and optimize ABAP programs, function modules, BAdIs, user exits, and ABAP OO-based solutions to support complex business requirements across SAP ECC and S/4HANA landscapes.
  • Build and maintain CDS (Core Data Services) Views — including analytical, basic, composite, and consumption views — aligned with the SAP clean core and side-by-side extensibility model.
  • Design and implement SAP BW extraction frameworks, including custom extractors, ODP (Operational Data Provisioning) sources, BAPIs, RFC function modules, LIS/LO cockpit extractors, and generic delta extractors.
  • Develop ABAP Managed Database Procedures (AMDPs) and SQLScript-based calculations to leverage SAP HANA's in-memory processing capabilities for high-performance analytics.
  • Create and maintain BEx Queries, query elements (restricted/calculated key figures, structures), and variables to support business reporting via SAP BW and SAP Analytics Cloud (SAC).
  • Perform SAP BW/4HANA migration activities: convert legacy BW objects (InfoCubes, DSOs, MultiProviders) to BW/4HANA-compatible models, addressing compatibility and deprecation requirements.
  • Integrate SAP BW and ABAP-based solutions with SAP DataSphere, SAP BTP, and cloud data platforms (Azure, AWS, GCP) via ODP, SLT, CDS Views, and REST/SOAP API-based interfaces.
  • Conduct comprehensive ABAP performance tuning: SQL trace analysis, runtime analysis, HANA execution plan reviews, and optimization of memory consumption for large-volume data loads and transformations.
  • Collaborate with SAP functional consultants and business analysts to gather requirements, produce technical design specifications, conduct peer code reviews, and ensure alignment with SAP best practices and clean core principles.
  • Lead and participate in solution design sessions, technical workshops, and architecture reviews; produce architecture decision records (ADRs), technical specifications, and reusable design patterns.
  • Establish and enforce ABAP coding standards, naming conventions, transport management disciplines, and documentation practices across project teams.
  • Support pre-sales activities, including solution scoping, effort estimation, RFP/RFI responses, proof-of-concept delivery, and client-facing technical presentations.
  • Mentor and guide junior ABAP and BW developers, sharing expertise in SAP development best practices, performance optimization, and modern CDS-first development approaches.

Key Skills:

Experiance Qualifications:

Benefits: