BW/BDC/Databricks Consultant

About LemongrassLemongrass 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.Job Details and ResponsibilitiesAbout 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 ConsultantBW/4HANA & Business Data Cloud ConsultantLead BW-BDC-Databricks ConsultantSAP BDC & Databricks Solution ArchitectSenior Data & Analytics Consultant – SAP BDC / DatabricksIn 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, Composite Providers, 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.QualificationsRequired 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), Composite Providers, InfoObjects, Open ODS Views, Hybrid Providers, and Layered Scalable Architecture (LSA++) design.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.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.ECloud & 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.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.Lemongrass Consulting is an Equal Opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, religious creed, sex, gender, sexual orientation, gender identity, gender expression, age, genetic information, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.