Job description

JOB DESCRIPTION

Job Purpose

The core purpose of this role is to provide reporting and analysis support to the Malaysia Commercial Operation Lead (Country Manager) in the areas of data generation, consolidation, analysis and reporting relating to Sell in, Sell Through, Trade Inventory, Retail KPIs and Promotion Mechanics.

Reporting:

Responsible for extracting data from various data source (XPERT POS, Data Warehouse, etc)
Consolidate and submit standard APD and local affiliate reports as per frequency and timeline required
Consolidate and provide any ad-hoc reports as required
Develop new templates or improve on current spreadsheets to provide user friendly and meaningful data
On- going process improvements to ensure data consolidation is done in an optimal manner
Provide timely, ongoing tracking and feedback to VP, Commercial Operation and/or the respective Account Executives on retailers’ performance

Analysis

Analyze and provide a robust summary or overview of reports generated (e.g. actual vs. forecast, etc)
Monitor and provide market related data where necessary as a value-add info

Record Keeping:

Maintain & update Retailers database to reflect up to date accounts/stores in each category in total country. Also, to maintain retailers contact details.
Ensure reports generated are named, filed in proper order in the respective data storage spaces (digital or hardcopy)
Archiving data when necessary to reduce overloading storage space available
Custodian of reports generated – able to retrieve and provide reports as and when requested

Coordination/Administrative Support

Provide coordination or administration support to the team for projects or tasks related to Sell In & Sell Through functions as necessary

Requirements:

Diploma/Degree holder in Economics or any business-related field with at least 1 year experience, preferably in retail industry
Excellent Analytical Skills with strong numerical ability
Able to relate to IT systems or reporting tools to facilitate data extraction
Advance knowledge of Excel (able to build complicated formulas, pivot table, what if analysis, macros)
Strong planning and time management skills
Good communication skills and is able to interact well with all levels of staff and management
Ability to maintain good working relationship with key stakeholders
Able to maintain good awareness of industry related trends