BW/BDC Consultant

Vacancy No

VN1392

Business Unit

Corporate

Job Location

India

Employment Type

Full Time

Job Details and Responsibilities

About the Role :

We are seeking a seasoned, hands-on SAP BW-BDC-Databricks Functional Consultant to serve as a subject matter expert at the strategic convergence of SAP BW/4HANA, SAP Business Data Cloud (BDC), and Databricks Lakehouse architecture. This role sits at the heart of Lemongrass's next-generation data practice - bridging the SAP analytical ecosystem with the power of open Lakehouse platforms to deliver unified, intelligent data foundations for global enterprise clients.

Candidates may be considered for any of the following role levels depending on experience and depth of expertise:

SAP BW-BDC Functional Consultant

BW/4HANA & Business Data Cloud Consultant

Lead BW-BDC-Databricks Consultant

SAP BDC & Databricks Solution Architect

Senior Data & Analytics Consultant – SAP BDC / Databricks

In this role, you will lead the design and delivery of enterprise data solutions that span SAP BW/4HANA, SAP BDC, and Databricks - enabling organizations to harmonize SAP-native analytical capabilities with open Lakehouse architectures. You will architect data models, define integration patterns, and guide clients through the modernization of their SAP data warehousing landscapes toward a unified, cloud-native data platform.

You will work closely with senior business stakeholders, SAP functional consultants, enterprise architects, and data engineering teams to translate complex business requirements into scalable, production-grade data products. As a trusted technical advisor and client-facing SME, you will shape solution architectures, lead functional design workshops, and accelerate cloud data transformation initiatives across our enterprise client portfolio.

This is a high-impact role offering the opportunity to influence data architecture decisions at scale, mentor emerging talent, and contribute to a practice that is redefining how enterprises harness the power of SAP data through BDC and Databricks-powered Lakehouse platforms. If you thrive at the convergence of SAP BW expertise, BDC's unified data fabric, and Databricks' open analytics engine - this is your platform to lead.

Key Responsibilities :

Lead the functional design and architecture of SAP BW/4HANA data solutions - including Advanced DSOs, CompositeProviders, InfoObjects, Open ODS Views, and LSA++ modelling patterns - aligned to enterprise reporting and analytics requirements.

Architect and implement SAP Business Data Cloud (BDC) solutions: configure BDC tenants, define data products, build data flows within SAP Datasphere, and integrate BDC with SAP BW/4HANA and S/4HANA source systems.

Design and deliver Databricks Lakehouse architectures: build and manage Bronze-Silver-Gold (Medallion) layers using Delta Lake, orchestrate data pipelines using Databricks Workflows and Delta Live Tables (DLT), and implement Unity Catalog for enterprise data governance.

Establish and maintain end-to-end data integration pipelines between SAP BW/4HANA, SAP BDC, and Databricks - leveraging ODP (Operational Data Provisioning), SAP SLT, CDS Views, and cloud-native connectors (e.g., SAP Databricks connector, Azure Data Factory, AWS Glue).

Develop and optimize SAP BW/4HANA extraction frameworks: ODP delta/full loads, generic extractors, function-module-based extractors, and LO Cockpit configurations to feed downstream BDC and Databricks environments.

Build and manage Databricks notebooks and PySpark / Spark SQL transformation logic for large-scale SAP data processing, harmonization, and enrichment within the Lakehouse.

Design semantic and analytical layers within SAP Datasphere (part of BDC): define Business Entities, Analytic Models, Perspectives, and Consumption Views to serve SAP Analytics Cloud (SAC) and third-party BI tools.

Define and implement unified data governance frameworks spanning SAP BDC and Databricks Unity Catalog - covering data lineage, data quality rules, access control policies, and data cataloguing.

Lead requirements workshops, functional design sessions, and architecture reviews with business stakeholders and enterprise architects; produce functional specification documents, data flow diagrams, and architecture decision records (ADRs).

Conduct SAP BW/4HANA migration activities: assess existing BW landscapes, convert legacy InfoCubes, DSOs, and MultiProviders to BW/4HANA-native objects, and define migration roadmaps toward BDC-first architectures.

Define and oversee data quality frameworks - including SAP Information Steward, Databricks Expectations (DLT), or equivalent tooling - to enforce data contracts across the integrated SAP-Databricks data platform.

Support SAP Analytics Cloud (SAC) integration: design live connections, import models, and planning models that consume data from BDC, BW/4HANA, and Databricks as unified analytical sources.

Collaborate with ABAP developers, cloud data engineers, and DevOps teams to ensure seamless delivery of data solutions across the full lifecycle - from extraction and transformation to consumption and governance.

Support pre-sales activities including solution scoping, effort estimation, RFP/RFI responses, proof-of-concept delivery, and client-facing technical presentations.

Mentor and develop junior functional consultants and data engineers, sharing expertise in SAP BW/4HANA, BDC architecture, and Databricks Lakehouse best practices.

Qualifications

Required Skills & Qualifications :

SAP BW/4HANA – Functional & Data Modelling :

7–10 years of hands-on SAP BW or BW/4HANA experience across full project lifecycles - from requirements gathering through design, build, test, and hypercare.

Deep expertise in SAP BW/4HANA data modelling: Advanced DSOs (Standard, Write-Optimized, Direct Update), CompositeProviders, InfoObjects, Open ODS Views, Hybrid Providers, and Layered Scalable Architecture (LSA++) design.

Comprehensive knowledge of BW process chains, Data Transfer Processes (DTPs), transformations (including ABAP routines), start/end routines, and delta load management for high-volume production data warehousing.

Hands-on experience with SAP BW extraction frameworks: ODP (full and delta), standard DataSources, LO Cockpit, generic extractors, business content activation, and custom extractor development.

Proficiency in BEx Query Designer / Analysis for Office: restricted/calculated key figures, structures, exceptions, conditions, hierarchies, and variables for enterprise-grade reporting.

Strong experience in SAP BW/4HANA migration and landscape consolidation - converting legacy BW objects, deprecated InfoProviders, and aligning to LSA++ and BDC-compatible architectures.

Working knowledge of SAP HANA native capabilities relevant to BW: Calculation Views, HANA Live, and in-memory computation for BW reporting and data load performance optimization.

SAP Business Data Cloud (BDC) :

Hands-on experience with SAP Business Data Cloud (BDC) - including BDC tenant configuration, data product definition, and federation with SAP BW/4HANA, SAP S/4HANA, and non-SAP sources.

Proficiency in SAP Datasphere (the foundation of BDC): Space management, Data Builder (data flows, replication flows, graphical views), Business Builder (Business Entities, Analytic Models, Perspectives), and Consumption Layers.

Strong understanding of BDC's Unified Semantic Layer and its role in harmonizing SAP and third-party data across cloud platforms to create governed, enterprise-ready data products.

Experience integrating SAP BDC with SAP Analytics Cloud (SAC): live connections, import connections, multi-dimensional models, Stories, and planning scenarios sourced from BDC.

Knowledge of BDC's open data ecosystem integrations: connecting BDC to Databricks, Snowflake, or Azure Synapse via open interfaces, OData services, and federated query engines.

Familiarity with SAP BDC Data Marketplace and the SAP Data Catalogue for publishing, discovering, and consuming governed data products across the enterprise.

Databricks Lakehouse Platform:

Hands-on experience with Databricks Lakehouse Platform: workspace administration, cluster management, Delta Lake storage layer, and Unity Catalog for unified data governance.

Proficiency in building and managing Medallion Architecture (Bronze-Silver-Gold) pipelines using Delta Live Tables (DLT), Databricks Workflows, and Auto Loader for incremental ingestion of SAP data.

Strong working knowledge of PySpark, Spark SQL, and DataFrame API for large-scale SAP data transformation, cleansing, enrichment, and harmonization within the Databricks environment.

Experience integrating SAP BW/4HANA or SAP S/4HANA data into Databricks using connectors such as the SAP ODP Databricks connector, SAP SLT-to-cloud replication, or ADF/Glue-based extraction pipelines.

Familiarity with Databricks Unity Catalog: data lineage tracking, fine-grained access controls, Delta Sharing, and data quality monitoring using DLT Expectations.

Understanding of Databricks ML and AI capabilities (MLflow, Feature Store, Model Serving) in the context of building AI-powered analytics on top of SAP enterprise data.

Experience with Databricks SQL Analytics and BI integrations: connecting Power BI, SAC, Tableau, or Looker to Databricks SQL Warehouses for self-service analytics on Lakehouse data.

Cloud & Integration Platform Knowledge:

Working knowledge of at least one major cloud platform - Azure, AWS, or GCP - specifically in the context of hosting SAP BDC tenants and Databricks workspaces.

Experience with cloud-native data integration tools: Azure Data Factory (ADF), AWS Glue, or GCP Dataflow for orchestrating SAP-to-cloud data pipelines into Databricks or BDC.

Understanding of event-driven and real-time data integration patterns: Apache Kafka, SAP Event Mesh, or Azure Event Hub for near-real-time SAP data streaming into Lakehouse platforms.

Familiarity with SAP BTP (Business Technology Platform) and Integration Suite for API-based and event-driven connectivity between SAP and non-SAP systems.

Basic knowledge of DevOps practices for data platforms: CI/CD pipelines for Databricks notebooks (Databricks Asset Bundles, GitHub Actions), and transport-based lifecycle management for BDC/Datasphere artefacts.

Preferred Qualifications :

SAP Certified Application Associate - SAP BW/4HANA (current certification strongly preferred).

SAP Certified Application Associate - SAP Datasphere or SAP Business Data Cloud.

Databricks Certified Data Engineer Associate or Professional certification.

SAP Certified Application Associate - SAP Analytics Cloud (SAC).

Prior experience in a Big 4 consulting, global system integrator (GSI), or SAP-focused technology advisory firm with direct client-facing delivery responsibilities.

Exposure to SAP RISE and cloud ERP migrations, particularly the data migration and analytics workstreams leveraging BDC as the target data platform.

Hands-on experience with SAP Information Steward or Databricks DLT Expectations for automated data quality profiling, scorecarding, and alerting.

Familiarity with semantic modelling tools such as dbt (data build tool) for transforming SAP data within Databricks Lakehouse environments.

Experience delivering SAP S/4HANA greenfield or brownfield implementations with specific responsibility for the analytics and reporting workstream (BW/BDC).

Knowledge of AI/ML use cases on top of SAP data - including predictive demand forecasting, financial anomaly detection, and supply chain optimization - enabled by Databricks MLflow and SAC Predictive Scenarios.

Certifications (Valued) :

Certification Issuing Body

SAP Certified Application Associate – SAP BW/4HANA SAP SE

SAP Certified Application Associate – SAP Datasphere / SAP BDC SAP SE

SAP Certified Application Associate – SAP Analytics Cloud (SAC) SAP SE

SAP Certified Application Associate – SAP S/4HANA SAP SE

SAP Certified Technology Associate – SAP HANA 2.0 (SPS07) SAP SE

Databricks Certified Data Engineer Associate Databricks

Databricks Certified Data Engineer Professional Databricks

Microsoft Azure Data Engineer Associate (DP-203) Microsoft

AWS Certified Data Engineer – Associate Amazon Web Services

Google Professional Data Engineer Google Cloud

Education:

Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, Mathematics, or a closely related technical field.

Equivalent combination of professional experience, SAP certifications, Databricks credentials, and demonstrated technical achievement will be considered in lieu of a formal degree.

Selected applicant will be subject to a background investigation, which will be conducted and the results of which will be used in compliance with applicable law.

About Lemongrass

Lemongrass is a global SAP-focused Cloud services provider helping some of the world’s most recognized Enterprises modernize and transform their SAP environments. We combine deep technical expertise with automation, innovation, and AI to deliver meaningful business outcomes.

Our work spans SAP Cloud migrations, managed services, SAP Business Technology Platform (BTP), Business Data Cloud (BDC), and AI-enabled solutions. We help customers build clean core strategies, intelligent data foundations, and scalable Cloud operations across AWS, Microsoft Azure, Google Cloud Platform, and SAP Cloud ERP.

Founded in 2010, Lemongrass has grown into a trusted partner to SAP, AWS, Microsoft, and Google, earning top-tier partner designations along the way including SAP Gold Partner, Premier AWS Partner, Microsoft Gold Partner, and Google Cloud Partner. Our teams operate across the Americas, EMEA, and APAC, collaborating to solve complex challenges for global Enterprises.

At Lemongrass, you’ll work alongside Cloud architects, engineers, and innovators who are shaping the future of SAP in the Cloud - within a culture that values ownership, curiosity, collaboration, and continuous growth.