Original
Simplified
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
501A, Level 5, Uptown 1,1 Jln SS21/58 Damansara Uptown, Petaling Jaya 47400 Selangor Darul Ehsan, Selangor Malaysia
FULL TIME/PART TIME
Full time
Current LS&Co Employees, apply via your Workday account.
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
- 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
- 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
- Provide coordination or administration support to the team for projects or tasks related to Sell In & Sell Through functions as necessary
- 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
501A, Level 5, Uptown 1,1 Jln SS21/58 Damansara Uptown, Petaling Jaya 47400 Selangor Darul Ehsan, Selangor Malaysia
FULL TIME/PART TIME
Full time
Current LS&Co Employees, apply via your Workday account.
Similar Jobs