Business Analyst

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

LOCATION501A, Level 5, Uptown 1,1 Jln SS21/58 Damansara Uptown, Petaling Jaya 47400 Selangor Darul Ehsan, Selangor MalaysiaFULL TIME/PART TIMEFull timeCurrent LS&Co Employees, apply via your Workday account.