PT Pepsi Cola Indobeverages - Finance & Sales Data Analyst Officer, Key Account Executive
PT Pepsi Cola Indobeverages - As a multi national FMCG Company we invite highly motivated individuals like you to join us to be a part of our team in this position below:
Finance & Sales Data Analyst Officer
Scope of Work :
- Responsible for performing database analysis and design in solving complex problems.
- Define architecture, including database structures and metadata, and develop and maintain best practices for data extraction, data loading, and data transformation into and out of a financial & accounting data or sales data.
- Interacting proactively with sales and marketing team, business management, distributors and other finance accounting groups to provide financial and accounting data to the management team.
- Perform Financial & Accounting Data on monthly Management and Financial Reporting versus Budget, Forecast and previous years etc.
- Perform various Business and Data Analysis such as Sales Analysis, Market Analysis, Customer Profitability Analysis, etc. to provide up-to-date and accurate information for management in decision making.
Qualification :
- At least a Bachelor’s Degree in Information Technology, Accounting or Finance
- Well versed in Accounting, Finance
- Proficient in Visual Basic Application for Microsoft Excel, SQL Server Business Intelligence such as Analysis Services, Reporting Services and Integration Services
- Proficient in data statistic & manipulation
- Minimum 2 Years Experience in Market Analisyst/Survey Company/ Media Pooling/Public Accounting
- Highly motivated, disciplined, result oriented, and ability to work independently with min supervision in a highly demanding environment
- Excellent communication and interpersonal skills and ability to deal with people from all levels in professional way
- Proficient in data statistic & manipulation, able to work with details, possess strong logic and analytical skills.
- Proficient with Microsoft Office juga (Power point)
- Fluent in English, both oral and written
- Excellent presentation skills.
Key Account Executive - Nov’09
Job Description :
- Develop Yearly Account Planning, Game Plan, Account Fact File and measurements ( sales volume, budgeting, shared growth, promotion activity, strategic execution, and time line ).
- Develop yearly Modern Trade Budget Spending ( Consumer Promo, Trade Promo, Account Specific Program, Fix Rebate, Conditional Rebate, Common Assortment Fee, and Others program ).
- Planning, conducting, and organizing the execution of consumer promotion at Account.
- To ensure the distribution of the customers’ order are delivered with in the targeted service level.
- Manage New Product Development ( NPD ) Report and analysis in line with Budgeting ( Listing Fee & Promo Support Budget ), promotional activity, and product allocation by Operation.
- To maintain a good relationship with major key accounts.
- Monitoring and analysis the market situation, in the short term, medium, and long term including market share growth, competitor activity and consumer update.
Qualifications:
- Male / Female, age max. 30 years old
- Bachelor degree (S1) or equivalent
- Highly recommended from Government University with min. GPA 3.00
- Min. 1 years Modern Trade experience
- Managing national chain store
- Understanding of retailer, distribution & key account process
- Fast learner & quick understanding
- Strong in team work with individual driver
- Fluent in English both written & spoken
- Company background can be principal, retailer, or distributor
If you are up to the challenge, we encourage you to apply for the above position. Please put the Job Title in the subject of your email and kindly send your comprehensive application letter and/or resume to:
hrd@pepsi.co.id
Only short-listed candidates will be invited for interview
