22 days ago
Jakarta, IndonesiaMid Level / Senior
Responsibilities
- Design, develop, and maintain scalable data pipelines for commercial reporting, analytics, forecasting, and business intelligence.
- Integrate data from distributor systems, point-of-sale systems, SAP ERP systems, CRM platforms, shipment records, customer master data, and syndicated market data.
- Build and maintain ETL/ELT workflows, data models, and datasets for sales, market share, revenue growth, trade promotion, customer performance, and demand forecasting use cases.
- Implement automated data validation, monitoring, reconciliation, and alerting to ensure data accuracy, completeness, consistency, and reliability.
- Develop and optimize data warehouse and data lake solutions for scalable processing and analytics.
- Deliver reliable, optimized datasets for Power BI, Tableau, and other reporting and visualization tools.
- Collaborate with business and technology stakeholders to support commercial growth and data-driven initiatives.
Requirements
- 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.
- Hands-on experience developing data pipelines and strong SQL development skills.
- Experience building and maintaining ETL/ELT pipelines.
- Understanding of data warehousing, data modeling, and data integration concepts.
- Experience with cloud-based data platforms and modern data infrastructure.
- Familiarity with Power BI or Tableau and the ability to support analytics and reporting requirements.
- Experience implementing data quality checks, monitoring, and governance practices.
Tech Stack
Categories
Data Engineering
About PepsiCo
PepsiCo is a global food and beverage company that manufactures, markets, and distributes snacks and drinks under brands such as Pepsi, Mountain Dew, Gatorade, Lay’s, Doritos, and Quaker Oats. It sells to consumers through retail, foodservice, and e-commerce channels, with products available in more than 200 countries and territories. Founded in 1965 and headquartered in Purchase, New York, PepsiCo is a public company listed on NASDAQ under the symbol PEP.