Sales Analytics

PepsiCo Inc.; Jakarta Pusat; Presencial; IDR 250.000.000 - 400.000.000; Jornada completa

Descripción de la vacante

PepsiCo Inc. is seeking a Sales Analytics Specialist in Jakarta to transform diverse data into actionable insights. You will monitor performance, develop dashboards, and support strategic planning with data-driven analyses across Sales, Marketing, and Supply Chain teams.

The role requires 3+ years in sales analytics, strong SQL/Excel skills, and experience with Power BI or Tableau. Collaboration and precise execution are essential in a fast-paced FMCG environment.

Formación

• Bachelor's degree in a relevant field as listed.
• Minimum 3 years in Sales/Commercial Analytics or BI in FMCG or consumer goods.
• Strong SQL and advanced Excel proficiency.
• Hands-on with Power BI, Tableau or similar tools.
• Experience analyzing sales, pricing, distribution and promotions.
• Familiarity with Nielsen/Circana/IRI, POS, distributor or CRM data a plus.
• Strong analytical skills to translate data into insights.
• Excellent communication, presentation and stakeholder management.
• Attention to detail and ability to manage multiple priorities.

Responsabilidades

• Analyze sales performance across channels, customers, regions, and product categories.
• Monitor KPIs including revenue, sales volume, market share, pricing and promotions.
• Develop dashboards and recurring reports using BI tools.
• Automate reporting processes and ensure data accuracy and timely delivery.
• Analyze POS, shipment, retailer and market data to evaluate performance.
• Assess trade promotions and measure ROI.
• Translate data into actionable insights to improve sales, performance and revenue.
• Partner with Sales, Marketing, Category, Revenue, and Supply Chain teams for planning and strategy.
• Extract, transform, and reconcile data from multiple sources using SQL and analytics tools.
• Continuously improve reporting processes and data governance.

Conocimientos

SQL

Excel

Data analytics

Stakeholder management

Communication

Sales analytics

Problem solving

Attention to detail

Forecasting

Revenue management

Python

R

Azure

Databricks

Educación

Bachelor's degree in Business Analytics, Statistics, Economics, Computer Science, Mathematics, Information Systems, or a related field

Herramientas

Power BI

Tableau

Excel

Descripción del empleo

Overview

The Sales Analytics Specialist is responsible for transforming sales, customer, distribution, and market data into actionable insights to drive business growth and improve commercial performance. This role partners closely with Sales, Marketing, Category Management, Revenue Management, and Supply Chain teams to monitor business performance, identify growth opportunities, and support strategic decision-making through data-driven analysis, reporting, and visualization.

Responsibilities

• Analyze sales performance across channels, customers, regions, and product categories to identify trends, growth opportunities, and business risks.

• Monitor key commercial KPIs, including net revenue, sales volume, distribution, market share, pricing, promotional performance, and customer profitability.

• Develop and maintain dashboards, executive scorecards, and recurring performance reports using Power BI, Tableau, or similar visualization tools.

• Automate reporting processes and ensure data accuracy, consistency, and timely delivery of business insights.

• Analyze point-of-sale (POS), shipment, retailer, distributor, and syndicated market data to evaluate customer performance, pricing, assortment, distribution, and promotional effectiveness.

• Assess trade promotions and marketing initiatives to measure effectiveness and return on investment (ROI).

• Translate complex data into actionable insights and recommendations to improve sales effectiveness, commercial performance, and revenue growth.

• Partner with Sales, Category Management, Revenue Management, Marketing, and Supply Chain teams to support business reviews, annual planning, forecasting, and commercial strategy development.

• Extract, transform, validate, and reconcile data from multiple sources using SQL and other analytical tools.

• Continuously improve reporting processes, maintain KPI definitions and business rules, and support data-driven decision-making across the organization.

Qualifications

• Bachelor's degree in Business Analytics, Statistics, Economics, Computer Science, Mathematics, Information Systems, or a related field.

• Minimum 3 years of experience in Sales Analytics, Commercial Analytics, Business Intelligence, or Data Analytics, preferably within FMCG, consumer goods, retail, or food and beverage industries.

• Strong SQL skills and advanced proficiency in Microsoft Excel.

• Hands-on experience with Power BI, Tableau, or similar data visualization and reporting tools.

• Experience analyzing sales, customer, distribution, pricing, and promotional performance data.

• Familiarity with Nielsen, Circana (IRI), POS data, distributor data, or CRM data is an advantage.

• Strong analytical and problem-solving skills, with the ability to translate data into actionable business insights.

• Excellent communication, presentation, and stakeholder management skills.

• Strong attention to detail and the ability to manage multiple priorities in a fast-paced business environment.

• Knowledge of Python, R, Azure, Databricks, or cloud-based analytics platforms is an advantage.

• Understanding of revenue management, trade promotion analytics, and sales forecasting is preferred.