Data Engineer - SAP

Total Number of Openings 1 The Data Engineer designs, develops, and operates scalable enterprise data solutions that integrate SAP and non-SAP data across the Microsoft Azure ecosystem. The role builds and optimizes ingestion frameworks, lakehouse and data warehouse solutions, transformation pipelines, data models, and governed data products that support enterprise reporting, analytics, AI, and intelligent applications. The role combines expertise in Azure data engineering, SAP data integration, lakehouse architecture, Databricks, SQL, DevOps, data governance, and AI engineering to create trusted, reusable, secure, and high-performing enterprise data foundations. About Us Chevron is a leading multinational energy company with operations in over 180 countries. Founded in 1879, Chevron has a rich history of innovation and growth, making significant contributions to the global energy landscape. Chevron markets Caltex® fuels, lubricants and other petroleum products in the Philippines. Our network of service stations, terminals and sales offices forms the backbone of our presence in the Philippines. In March 2020, Chevron sold its 45% non-operated interest in the Malampaya natural gas field. This was the first natural gas development and largest industrial project in the Philippines. From the Philippines, we provide operational support for Chevron offices on five continents. The workforce supplies transactional, processing and consulting services in areas ranging from finance to information technology. Chevron operates through two subsidiaries in the Philippines. Our Downstream company is Chevron Philippines Inc. We also operate a business processes support organization through Chevron Holdings Inc. There are two Chevron companies operating in the Philippines: Chevron Holdings Incorporated (CHI) and Chevron Philippines Incorporated (CPI). CHI is a shared services center providing transactional, processing, and consulting services in the areas of finance and accounting, information technology, supply chain management, human resources, downstream customer service and marketing. Established in 1998, CHI serves Chevron affiliates in six continents around the world. Over the years, it has grown to be one of the leading members of the shared services industry in the Philippines. CHI has received various recognitions as a top employer: the 2024 Circle of Excellence for CSR Company of the Year; 2024 Top 10 Fortune 500 companies; 2023 HR Asia best companies; 2022 Diversity Company of the Year; 2021 Asia’s Best Employer Brand Award; 2021 Global Best Employer Brand Award; 2020 HR Asia Best Companies to Work for in Asia; 2019 Circle of Excellence, Top Employer Category at Asia CEO Awards, and the 2018 Wellness Company of the Year at the same Asia CEO Awards. CPI markets the Caltex brand of top-quality fuels, lubricants, and petroleum products through a network of service stations, terminals and sales offices. About the Role We have an exciting opportunity for Lead ERP Data Engineer . This role will be based in 6750 Building, Makati City, Philippines . Responsibilities for this position may include but are not limited to: 1. Azure Data Platform Engineering • Design, build, and enhance enterprise data platforms on Microsoft Azure , spanning ingestion, transformation, storage, orchestration, serving, and consumption layers. • Develop reusable data engineering frameworks and patterns supporting both SAP and non-SAP enterprise data sources . • Design scalable solutions using Azure Databricks, Azure Data Lake Storage Gen2, Azure Data Factory, Azure Synapse Analytics, SQL, and Microsoft Fabric , based on enterprise architecture standards. • Engineer batch and, where required, streaming or event-driven data pipelines. • Balance performance, scalability, resiliency, maintainability, and cloud cost when selecting data processing patterns. • Contribute to platform architecture standards, reusable components, engineering guardrails, and technology roadmaps. 2. SAP & Enterprise Data Integration • Design and develop scalable ingestion solutions for SAP S/4HANA, SAP BW/HANA and other relevant SAP platforms , alongside non-SAP sources. • Integrate enterprise data from platforms such as TM1, Salesforce, SQL databases, APIs, cloud applications, and flat/file-based sources . • Work with SAP functional and technical teams to understand SAP business objects, tables, CDS views, extractors, APIs, and business semantics. • Develop SAP-to-Azure ingestion and transformation patterns that preserve appropriate business context and relationships. • Implement incremental loading, change-data processing, reconciliation, restartability, and data lineage. • Optimize ingestion strategies for high-volume SAP datasets. • Partner with SAP Integration, Basis, Security, Functional, and Data teams to ensure appropriate extraction and consumption of SAP data. 3. Lakehouse & Medallion Architecture • Design and implement centralized ingestion and transformation frameworks aligned with Medallion Architecture principles. • Build and maintain: • Bronze: raw, source-aligned and auditable data. • Silver: cleansed, standardized, validated and integrated data. • Gold: curated, business-ready datasets and analytical data products. • Design and implement Delta Lake-based solutions for scalable analytical processing. • Develop reusable frameworks for schema management, incremental processing, metadata management, and data transformations. • Define appropriate partitioning, optimization, retention, and lifecycle strategies. 4. Data Warehouse & Data Modeling • Design and optimize enterprise data warehouse and lakehouse schemas . • Develop dimensional data models using fact and dimension modeling , including appropriate star-schema patterns. • Design reusable analytical views, curated datasets, semantic-ready data products, and aggregation strategies. • Translate complex SAP transactional structures into business-co