Commercial Data Engineer

PepsiCo Inc.; Maluku; On-site; IDR 180,000,000 - 300,000,000; Full time

Job summary

PepsiCo Inc. is hiring a Commercial Data Engineer to build scalable data pipelines and platforms supporting commercial reporting, analytics, forecasting, and business decisions across Sales, Commercial Analytics, Revenue Management, Category Management, and Supply Chain teams.

You will integrate data from distributor systems, POS, ERP (SAP), CRM, shipments, master data, and market data, while developing ETL/ELT workflows and data models to enable sales performance reporting and demand

Qualifications

• Bachelor's degree in Computer Science, Data Engineering, Information Systems, Analytics, or a related field.
• 3–5 years of experience in Data Engineering, Analytics Engineering, or Business Intelligence, with hands‑on experience in data pipeline development.
• Strong SQL development skills and experience building and maintaining ETL/ELT pipelines.
• Solid understanding of data warehousing, data modeling, and data integration concepts.
• Experience with cloud-based data platforms and modern data infrastructure.
• Familiarity with data visualization tools such as Power BI or Tableau and the ability to support analytics and reporting requirements.
• Experience implementing data quality checks, monitoring, and governance practices.

Responsibilities

• Design, develop, and maintain scalable data pipelines to support commercial reporting, analytics, forecasting, and business intelligence.
• Integrate data from multiple sources, including distributor systems, 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.

Skills

SQL development

ETL/ELT pipelines

Data warehousing concepts

Cloud platforms

Data visualization (Power BI/Tableau)

Data quality checks

Data modeling

Stakeholder collaboration

Education

Bachelor's degree in Computer Science or related

Tools

Power BI

Tableau

SAP

Job description

Overview

The Commercial Data Engineer is responsible for building and maintaining scalable data pipelines and platforms that enable commercial reporting, analytics, forecasting, and business decision-making. This role integrates data from multiple sources to deliver reliable, high-quality datasets for Sales, Commercial Analytics, Revenue Management, Category Management, and Supply Chain teams. Working closely with business and technology stakeholders, the role ensures data availability, quality, and performance to support commercial growth and data-driven initiatives.

Responsibilities

• 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.

Qualifications

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

• 3–5 years of experience in Data Engineering, Analytics Engineering, or Business Intelligence, with hands‑on experience in data pipeline development.

• Strong SQL development skills and experience building and maintaining ETL/ELT pipelines.

• Solid understanding of data warehousing, data modeling, and data integration concepts.

• Experience with cloud-based data platforms and modern data infrastructure.

• Familiarity with data visualization tools such as Power BI or Tableau and the ability to support analytics and reporting requirements.

• Experience implementing data quality checks, monitoring, and governance practices.