Sales Intelligence & Forecasting Associate

PepsiCo; Jakarta Selatan; On-site; IDR 240,000,000 - 480,000,000; Full time

Job summary

PepsiCo in Jakarta Selatan is seeking a Sales Intelligence Associate to support the Sales Planning & Intelligence function by preparing, consolidating, and maintaining sales data and standard performance analyses.

You will work under close guidance, contributing to analytics that enable accurate business reporting and IBP processes, while ensuring data quality and governance. Collaboration with senior analysts will drive reporting efficiency.

Qualifications

• 2–3 years of relevant experience in sales analytics, planning, demand planning, or a related analytical role (including internship or contractual).
• 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 reporting and forecasting.
• Experience using data and analytics tools such as Excel and BI dashboards to produce standard analyses and recurring reports.
• Analytical capability to identify trends, variances, and data inconsistencies and translate observations into forecasting.
• Strong attention to detail with disciplined documentation, version control, and data governance.
• Ability to work within structured processes and manage multiple recurring deliverables.
• Good communication skills to collaborate with cross-functional stakeholders.

Responsibilities

• Develop and maintain short- and long-term commercial forecasts across categories and channels.
• Conduct pressure test, scenario planning and sensitivity analysis to evaluate 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 required analytical inputs under established frameworks.
• Conduct first-level analysis on sales performance trends to identify key movements, risks, or anomalies for escalation and interpretation.
• Maintain data quality and integrity through regular checks and data corrections with 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 under governance.

Skills

Sales analytics

Sales planning

Demand planning

Excel

BI dashboards

Data governance

Tools

Power BI

Job description

PepsiCo in Jakarta Selatan is seeking a Sales Intelligence Associate to support the Sales Planning & Intelligence function by preparing, consolidating, and maintaining sales data and standard performance analyses.

You will work under close guidance, contributing to analytics that enable accurate business reporting and IBP processes, while ensuring data quality and governance. Collaboration with senior analysts will drive reporting efficiency.