Commercial Data Engineer: Build Scalable Pipelines & Insights

PepsiCo Inc.; Jakarta Pusat; Presencial; IDR 350.000.000 - 550.000.000; Jornada completa

Descripción de la vacante

PepsiCo Inc. seeks a Commercial Data Engineer to design and operate scalable data pipelines powering sales, analytics, forecasting, and business decision-making across multiple data sources.

You will collaborate with business and technology stakeholders to ensure data availability and quality for reporting and analytics. The role emphasizes building ETL/ELT workflows, data models, and datasets, developing data warehouses/data lakes, and delivering trusted datasets for Power BI, Tableau, and

Formación

• Bachelor's degree in Computer Science, Data Engineering, Information Systems, Analytics, or a related field.

Responsabilidades

• Design, develop, and maintain scalable data pipelines to support commercial reporting, analytics, forecasting, and business intelligence.
• Integrate data from multiple sources, including distributor systems, point-of-sale (POS), ERP systems such as SAP, CRM platforms, shipment records, customer master data, and syndicated market data.
• Build and maintain ETL/ELT workflows, data models, and datasets to support sales performance reporting, market share analysis, revenue growth management, trade promotion analytics, customer performance, and demand forecasting.
• Implement automated data validation, monitoring, reconciliation, and alerting processes to ensure data accuracy, completeness, consistency, and reliability.
• Develop and optimize data warehouse and data lake solutions to support scalable data processing and analytics requirements.
• Deliver reliable and optimized datasets for Power BI, Tableau, and other reporting and visualization tools.

Conocimientos

SQL development

Data pipelines

Data warehousing

Data modeling

Data governance

Educación

Bachelor's degree in Computer Science or related field

Herramientas

Power BI

Tableau

SAP

Descripción del empleo

PepsiCo Inc. seeks a Commercial Data Engineer to design and operate scalable data pipelines powering sales, analytics, forecasting, and business decision-making across multiple data sources.

You will collaborate with business and technology stakeholders to ensure data availability and quality for reporting and analytics. The role emphasizes building ETL/ELT workflows, data models, and datasets, developing data warehouses/data lakes, and delivering trusted datasets for Power BI, Tableau, and