SAP Business Data Cloud (BDC) & BI Development Specialist

Looking to build your career and design your future? You have come to the right place.

We are seeking a skilled SAP Business Data Cloud (BDC) Integration Specialist with strong BI development expertise to design, build, and maintain data integration solutions across our SAP and Azure landscape. In the near term, this role will focus on connecting SAP BDC with Azure Data Factory (ADF) to ensure reliable, high-quality data flow into our Azure Data Lake (ADLS), supporting downstream analytics, reporting, and AI/ML workloads. Over time, the role will lead the migration away from ADF — replacing it with native SAP Datasphere pipelines that feed directly into Power BI — consolidating our analytics stack within the SAP BDC ecosystem. This role is critical to enabling data-driven decision-making by bridging SAP source systems with modern cloud analytics and reporting platforms.

Responsibilities

• Configure SAP BDC and Datasphere as the primary data source — set up connections, data flows, and outbound endpoints consumed by existing ADF pipelines
• Design and implement data integration solutions within SAP Business Data Cloud, including data ingestion, transformation, replication, and orchestration
• Expose SAP data via OData services, REST APIs, or Open Connectors from within SAP BDC/Datasphere for ADF and downstream consumption
• Define and publish SAP CDS Views from S/4HANA into Datasphere as the primary extraction layer feeding downstream pipelines
• Set up remote tables, replication flows, and data persistence layers within Datasphere to reliably stage data
• Ensure delta and CDC enablement on the SAP side so incremental pipelines receive correct, complete data
• Manage authentication and secure connectivity between SAP BDC and Azure — OAuth, service principals, and SAP Integration Suite where applicable
• Maintain existing ADF pipelines — monitor performance, troubleshoot failures, and ensure SLA adherence during the transition period
• Plan and execute the migration of ADF pipelines into native SAP Datasphere data flows and transformation layers
• Build and optimize Datasphere analytical datasets and semantic models to serve as the direct source for Power BI
• Configure and maintain SAP Datasphere to Power BI connectivity — live connection, DirectQuery, or dataset publish patterns
• Develop and maintain BI reports, dashboards, and analytical models using SAP Analytics Cloud (SAC) and/or Power BI
• Collaborate with functional and technical teams to understand data requirements and translate them into scalable solutions
• Monitor data pipeline performance, troubleshoot issues, and ensure data quality and integrity
• Document integration architecture, data flows, migration progress, and BI solutions; support end-user training and adoption

Qualifications

• 7+ years of SAP data and analytics experience with deep hands-on expertise in SAP BDC and/or SAP Datasphere
• Strong experience configuring SAP Datasphere as a data source and building native data flows, transformation views, and analytical datasets
• Proven ability to expose SAP data via OData services, REST APIs, or Open Connectors from within SAP BDC/Datasphere
• Hands-on experience defining and publishing SAP CDS Views from S/4HANA into Datasphere as the extraction layer
• Experience setting up remote tables, replication flows, and data persistence layers within Datasphere
• Strong understanding of delta and CDC enablement on the SAP side to support incremental pipeline patterns
• Hands-on experience with Azure Data Factory — maintaining pipelines, troubleshooting failures, and ensuring SLA adherence
• Experience connecting SAP Datasphere to Power BI, including live connection, DirectQuery, and semantic model publishing
• Experience planning or executing data pipeline migrations — ideally from ADF or similar tools into a native SAP layer
• Solid understanding of SAP data models across core modules (FI, CO, SD, MM, PS)
• Strong SQL and data transformation skills within SAP Datasphere and HANA Cloud
• Experience managing secure connectivity between SAP BDC and Azure — OAuth, service principals, SAP Integration Suite
• Experience with data modeling, ETL/ELT processes, and cloud data integration patterns
• Strong analytical and problem-solving skills with attention to data accuracy
• Bachelor’s degree in Computer Science, Information Systems, Data Science, or related field

Nice to Have

• Experience with SAP Analytics Cloud (SAC) as an alternative or complementary reporting layer to Power BI
• Familiarity with SAP BW/4HANA Open Hub as an alternative or legacy extraction mechanism
• Familiarity with SAP HANA Cloud and CDS-based analytical data modeling
• Knowledge of Python or SQL scripting for transformation automation within SAP BDC
• Experience with Power BI dataflows, semantic models, and enterprise-scale report governance
• SAP certification in Datasphere, Analytics Cloud, or BW/4HANA

SAP Business Data Cloud Integration Specialist

Summary

The SAP Business Data Cloud Integration Specialist is responsible for designing, developing, and supporting enterprise data integration, business intelligence, analytics, and reporting solutions across the SAP and Azure ecosystem. This role serves as a technical subject matter expert for SAP Business Data Cloud (BDC) and Datasphere, enabling the organization to leverage data as a strategic asset by connecting SAP source systems with modern cloud analytics and reporting platforms — including Power BI and SAP Analytics Cloud. In addition to building and managing data integration frameworks, the role leads the near-term ADF integration and drives the longer-term migration of ADF pipelines into native Datasphere data flows.

The position partners with business stakeholders, functional teams, and technology teams to deliver scalable data integration solutions, analytical models, dashboards, and reporting capabilities that support operational, financial, and strategic decision-making.

Essential Functions

Data Integration & Architecture

• Configure SAP BDC and Datasphere as the primary data source — set up connections, data flows, and outbound endpoints consumed by existing ADF pipelines
• Design, develop, and maintain data integration solutions within SAP Business Data Cloud, including data ingestion, transformation, replication, orchestration, and monitoring
• Expose SAP data via OData services, REST APIs, or Open Connectors from within SAP BDC/Datasphere for ADF and downstream consumption
• Define and publish SAP CDS Views from S/4HANA into Datasphere as the primary extraction layer
• Set up remote tables, replication flows, and data persistence layers within Datasphere
• Ensure delta and CDC enablement on the SAP side to support incremental pipeline patterns
• Manage authentication and secure connectivity between SAP BDC and Azure — OAuth, service principals, and SAP Integration Suite
• Build and support integrations between SAP BDC and SAP systems such as S/4HANA, BW/4HANA, Datasphere, and other enterprise applications
• Ensure data quality, integrity, security, and governance standards are incorporated into all integration solutions

Analytics, Reporting & BI Migration

• Maintain existing ADF pipelines — monitor performance, troubleshoot failures, and ensure SLA adherence during the transition period
• Plan and execute the migration of ADF pipelines into native SAP Datasphere data flows and transformation layers
• Build and optimize Datasphere analytical datasets and semantic models to serve as the direct source for Power BI
• Configure and maintain SAP Datasphere to Power BI connectivity — live connection, DirectQuery, or dataset publish patterns
• Develop and maintain Power BI reports and dashboards consuming Datasphere models across finance, operations, and executive reporting
• Develop and maintain dashboards, reports, stories, and analytical applications using SAP Analytics Cloud and related BI platforms
• Create and support enterprise data models that enable self-service reporting and advanced analytics
• Partner with business stakeholders to translate reporting and analytical requirements into technical solutions
• Support financial, operational, and executive reporting through scalable and sustainable analytics solutions
• Identify opportunities to improve reporting efficiency, data accessibility, and business insights

Data Modeling & Solution Development

• Design and maintain logical and physical data models that support reporting, planning, forecasting, and analytical initiatives
• Develop and optimize ETL/ELT processes and data transformation logic within SAP Datasphere and HANA Cloud
• Leverage SAP and cloud-based technologies to deliver efficient, high-performing analytical solutions
• Support the implementation of new data sources, integrations, and reporting capabilities as business requirements evolve

Operational Support & Continuous Improvement

• Monitor integration processes, data pipelines, and reporting environments to ensure system reliability and performance
• Troubleshoot and resolve data integration, reporting, and analytics issues in a timely manner
• Maintain technical documentation, including integration architecture, data lineage, data flows, data models, and reporting specifications
• Provide end-user support, training, and knowledge transfer to promote adoption of reporting and analytics solutions
• Research emerging SAP analytics and data management technologies and recommend improvements to existing processes and platforms

Additional Responsibilities

• Perform other duties as assigned

Education & Experience

Required

• Bachelor’s degree in Computer Science, Information Systems, Data Science, Business Analytics, or a related field
• Seven (7) or more years of experience supporting SAP data, analytics, business intelligence, or enterprise reporting solutions
• Strong experience configuring SAP Datasphere as a data source and building native data flows, transformation views, and analytical datasets
• Proven ability to expose SAP data via OData services, REST APIs, or Open Connectors from within SAP BDC/Datasphere
• Hands-on experience defining and publishing SAP CDS Views from S/4HANA into Datasphere as the extraction layer
• Experience setting up remote tables, replication flows, and data persistence layers within Datasphere
• Hands-on experience with Azure Data Factory — maintaining pipelines, troubleshooting failures, and ensuring SLA adherence
• Experience connecting SAP Datasphere to Power BI, including live connection, DirectQuery, and semantic model publishing
• Experience with SAP BW, SAP BW/4HANA, SAP Datasphere, SAP Analytics Cloud, or comparable SAP analytics technologies
• Experience designing and supporting enterprise data integration solutions and data pipelines
• Strong understanding of SAP data structures and business processes across modules such as Finance (FI), Controlling (CO), Sales and Distribution (SD), Materials Management (MM), and Project Systems (PS)
• Experience with data modeling, ETL/ELT development, and cloud-based integration architectures
• Strong SQL and data transformation skills within SAP Datasphere and HANA Cloud
• Experience managing secure connectivity between SAP BDC and Azure — OAuth, service principals, SAP Integration Suite

Preferred

• Experience with SAP Business Data Cloud (BDC) implementation, administration, or support
• Experience planning or executing data pipeline migrations — ideally from ADF or similar tools into a native SAP layer
• Experience with SAP Datasphere and its integration capabilities within the SAP data ecosystem
• Experience with SAP HANA Cloud and Core Data Services (CDS) modeling
• Experience with SAP Analytics Cloud (SAC) as an alternative or complementary reporting layer
• Familiarity with SAP BW/4HANA Open Hub as an alternative or legacy extraction mechanism
• Experience with non-SAP analytics and visualization tools such as Power BI or Tableau
• Experience with Power BI dataflows, semantic models, and enterprise-scale report governance
• Experience using SQL, Python, or other scripting languages for data transformation, automation, and analytics
• SAP certifications related to SAP Analytics Cloud, SAP BW/4HANA, SAP Datasphere, SAP HANA, or Business Data Cloud technologies

Skills & Competencies

• Strong understanding of enterprise data integration, cloud analytics, and business intelligence best practices
• Ability to design and develop scalable, secure, and high-performing data solutions
• Strong analytical and problem-solving skills with a focus on data accuracy and quality
• Ability to translate business requirements into technical solutions and communicate technical concepts to non-technical audiences
• Strong organizational skills with the ability to manage multiple projects and priorities simultaneously
• Detail-oriented with a commitment to maintaining data integrity and documentation standards
• Effective written and verbal communication skills
• Strong collaboration skills with the ability to work effectively across business and technology teams
• Working proficiency with SAP analytics platforms, cloud data technologies, SQL, and Microsoft Office applications

If you like working with a growing close knit team and helping home owners design the home of their dreams, come build your career with us!

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, individual with disabilities, veteran status, gender identity or national origin.

Originally posted on