JOB DESCRIPTIONJob 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 sources (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
Ongoing 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 value-add information
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 and filed in proper order in the respective data storage spaces (digital or hardcopy)
Archive 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
Advanced knowledge of Excel (able to build complicated formulas, pivot tables, what-if analysis, macros)
Strong planning and time management skills
Good communication skills and 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
LOCATION:501A, Level 5, Uptown 1, 1 Jln SS21/58 Damansara Uptown, Petaling Jaya 47400 Selangor Darul Ehsan, Selangor MalaysiaFULL TIME/PART TIME:Full time
#J-18808-Ljbffr