Sales Intelligence Associate

PepsiCo; Pondok Pinang; On-site; IDR 133,920,000 - 200,880,000; Full time

Job summary

PepsiCo is seeking a Sales Intelligence Associate in Indonesia to support the Sales Planning & Intelligence function. You will prepare, consolidate, and maintain sales data to enable timely business reporting, focusing on IBP processes under close guidance from senior team members.

The role emphasizes data management, analytics support, and insight generation to underpin data-driven decisions. Collaboration with cross-functional stakeholders is essential, with a strong emphasis on accuracy and

Qualifications

• 2–3 years of experience in sales analytics or related analytical role.
• Hands-on data preparation, cleaning, consolidation for routine reporting.
• Knowledge of sales performance metrics and their use in forecasting.
• Experience with Excel, BI dashboards, or similar reporting tools.
• Ability to summarize observations clearly for stakeholders and translate to forecasts.
• Attention to detail and data governance in structured processes.

Responsibilities

• Develop and maintain short- and long-term commercial forecasts across categories and channels.
• Conduct pressure tests, scenario planning and sensitivity analysis for the commercial plan.
• Produce standard sales planning outputs and dashboards using defined templates.
• Support IBP cycles with timely data preparation and variance analysis.
• Perform first-level analysis on sales performance trends for escalation.
• Maintain data quality and coordinate corrections with data owners.
• Collaborate with senior teams to align analytical requirements and reporting.
• Build proficiency in sales analytics tools and ensure governance.

Skills

Sales analytics

Forecasting

Data reporting

Tools

Excel

BI dashboards

Reporting systems

Job description

Overview

Sales Intelligence Associate supports the Sales Planning & Intelligence function by preparing, consolidating, and maintaining sales data and standard performance analyses to enable accurate and timely business reporting. The role focuses on executional data management, analytics support, and insight generation within established frameworks, particularly to support Integrated Business Planning (IBP) processes. Operating under close guidance from senior team members, the role does not own commercial strategy but provides reliable data and analysis that underpin data-driven decision making.

Responsibilities

Responsibilities:

1. Develop and maintain short- and long-term commercial forecasts across categories and channels.
2. Conduct pressure test, scenario planning and sensitivity analysis to evaluate commercial plan.
3. Produce standard sales planning outputs, including recurring reports and dashboards, using defined templates, tools, and timelines.
4. Support Integrated Business Planning (IBP) cycles by providing timely data preparation, basic variance analysis, and required analytical inputs under established frameworks.
5. Conduct first-level analysis on sales performance trends to identify key movements, risks, or anomalies for escalation and further interpretation by senior team members.
6. Maintain data quality and integrity through regular checks, issue identification, and coordination of data corrections with relevant data owners.
7. Collaborate with senior sales intelligence and strategy roles to align on analytical requirements and continuously improve reporting effectiveness.
8. Build proficiency in sales analytics tools, systems, and processes through hands-on execution, ensuring compliance with established standards and governance.

Qualifications

Requirements:

1. 2–3 years of relevant experience in sales analytics, sales planning, demand planning, or a related analytical role, including internship or contractual experience.
2. Hands-on experience in preparing, cleaning, consolidating, and validating large datasets to support routine reporting and performance analysis.
3. Working knowledge of sales performance metrics (e.g., volume, building blocks, value, mix, customer or channel performance) and their application in business reporting and forecasting.
4. Experience using data and analytics tools such as Excel, BI dashboards, or similar reporting systems to produce standard analyses and recurring reports.
5. Basic analytical capability to identify trends, variances, and data inconsistencies, with the ability to summarize observations clearly for senior team members and translate into forecasting.
6. Strong attention to detail and data accuracy, with a disciplined approach to documentation, version control, and data governance.
7. Ability to work effectively within structured processes and under close guidance, managing multiple recurring deliverables and deadlines.
8. Good communication skills to collaborate with cross-functional stakeholders and respond to data or reporting requests in a clear and timely manner.