SALES & MARKETING ANALYST

PT Persada Batavia Diesel; Banjarmasin; On-site; IDR 133,920,000 - 200,880,000; Full time

Job summary

PT Persada Batavia Diesel is seeking a Sales & Marketing Analyst to manage sales reporting, data analysis, and performance tracking across the sales department. The role involves compiling daily, weekly, and monthly national-level sales reports and supporting forecasting and budgeting processes.

The ideal candidate will hold a Bachelor’s degree in Statistics or Economics, demonstrate advanced Excel skills (VLOOKUP, HLOOKUP, SUMIFS, Pivot Tables), and be proficient with CRM software and BI tools.

Qualifications

• Bachelor's degree in Statistics, Economics, or equivalent field.
• Advanced proficiency in Microsoft Excel, including VLOOKUP, HLOOKUP, SUMIFS, and Pivot Tables.
• Proficiency with CRM software and BI tools.
• Experience in Sales Support, processing commercial data, and preparing Sales Reports using BI software and Excel.
• Strong analytical capability across sales activities in distributor companies, with experience preparing daily, weekly, and monthly Sales Reports.
• Detail-oriented with high discipline, effective communication skills, and ability to interact with sales teams and cross-functional departments.

Responsibilities

• Ensure all Sales Department teams submit daily activity reports with discipline and timeliness.
• Compile daily, weekly, and monthly sales reports at national level with recapitulation by branch, principal, and salesman.
• Process and present Sales Team Productivity Analysis reports to measure performance against KPIs.
• Ensure updates and accuracy of sales data, Coverage Plans, and Customer Master Lists in company systems.
• Maintain Market Coverage Plans for all Sales teams in an organized, updated manner.
• Consolidate reports related to sales, inventory, productivity, distribution, and Sales Team incentive calculations.
• Support Head of Sales in developing annual sales targets, allocating cost budgets, and mapping sales team allocation needs.
• Assist Head of Sales in preparing accurate monthly sales projections and forecasts.

Skills

Advanced Excel

Data analysis

Communication

Education

Bachelor's degree in Statistics, Economics, or equivalent

Tools

VLOOKUP

HLOOKUP

SUMIFS

Pivot Table

CRM software

BI tools

Job description

A Sales & Marketing Analyst role responsible for managing sales reporting, data analysis, and performance tracking across the sales department. The position involves compiling daily, weekly, and monthly sales reports at national level, analyzing productivity metrics against KPIs, maintaining data accuracy in company systems, and supporting sales leadership with forecasting and budgeting.

Key responsibilities

Ensure all Sales Department teams submit daily activity reports with discipline and timeliness

Compile daily, weekly, and monthly sales reports at national level including recapitulation by branch, principal, and salesman

Process and present Sales Team Productivity Analysis reports to measure performance against established KPIs

Ensure updates, accuracy, and proper organization of sales data, Coverage Plans, and Customer Master Lists in company systems

Control and maintain Market Coverage Plans (Coverage Plan / PJP) for all Sales teams in an organized, consistent, and regularly updated manner

Consolidate and control reports related to sales, inventory, productivity, distribution, sales evaluation, sales team incentive calculations, and Business Review materials for each Principal monthly

Support Head of Sales in developing annual sales targets, allocating cost budgets, and mapping sales team allocation needs

Assist Head of Sales in preparing accurate monthly sales projections and forecasts to support achievement of company business targets

About you

Bachelor's degree in Statistics, Economics, or equivalent field of study

Advanced proficiency in Microsoft Excel, particularly VLOOKUP, HLOOKUP, SUMIFS, Pivot Table, and advanced data processing

Proficiency with CRM (Customer Relationship Management) software and Business Intelligence (BI) tools

Work experience in Sales Support, processing commercial data, and preparing Sales Reports using BI software and Excel

Strong analytical capability across all aspects of sales activities in distributor companies, with experience preparing daily, weekly, and monthly Sales Reports

Detail-oriented with high discipline, effective communication skills, and ability to interact well with sales teams and cross-functional departments

Unlock job insights

Hirer responsiveness Salary match Number of applicants

Researching careers? Find all the information and tips you need on career advice.