Sales Intelligence & Forecasting Associate

PepsiCo; Indonesia; On-site; IDR 180,000,000 - 240,000,000; Full time

Benefits offered by this job

Build globally recognized heritage品牌

Chance to create a lasting legacy

Tight-knit group with strong sense of

Competitive compensation & benefit

Job summary

PepsiCo is seeking a Sales Intelligence Associate to support data-driven planning and reporting within the Sales Planning & Intelligence function. You will help prepare forecasts, analyze performance, and deliver standard reports and dashboards under guidance from senior team members.

The role emphasizes data management, analytics support, and insights generation to enable IBP processes. Collaboration with cross-functional stakeholders is key to success.

Qualifications

• 2-3 years of relevant experience in sales analytics, sales planning, demand planning, or a related analytical role, including internship or contractual experience.
• Hands-on experience in preparing, cleaning, consolidating, and validating large datasets to support routine reporting and performance analysis.
• Working knowledge of sales performance metrics and their application in business reporting and forecasting.
• Experience using data and analytics tools such as Excel, BI dashboards, or similar reporting systems to produce standard analyses and recurring reports.
• Basic analytical capability to identify trends, variances, and data inconsistencies, with the ability to summarize observations for forecasting.

Responsibilities

• Develop and maintain short- and long-term commercial forecasts across categories and channels.
• Conduct pressure test, scenario planning and sensitivity analysis to evaluate the commercial plan.
• Produce standard sales planning outputs, including recurring reports and dashboards, using defined templates, tools, and timelines.
• Support IBP cycles by providing timely data preparation, basic variance analysis, and analytical inputs under established frameworks.
• Perform first-level analysis on sales performance trends to identify key movements, risks, or anomalies for escalation.
• Maintain data quality and integrity through checks and coordination with data owners.
• Collaborate with senior sales intelligence and strategy roles to align on analytical requirements and improve reporting.
• Build proficiency in sales analytics tools, systems, and processes with governance.

Skills

Sales analytics

Forecasting

Data management

BI dashboards

Data validation

Data governance

Cross-functional collaboration

Attention to detail

Tools

Excel

Job description

PepsiCo is seeking a Sales Intelligence Associate to support data-driven planning and reporting within the Sales Planning & Intelligence function. You will help prepare forecasts, analyze performance, and deliver standard reports and dashboards under guidance from senior team members.

The role emphasizes data management, analytics support, and insights generation to enable IBP processes. Collaboration with cross-functional stakeholders is key to success.