Philips Lighting Intern Demand Planner in United Arab Emirates
As an intern demand planning you assist the Supply Chain department with business analysis and planning. Your eye for details and ability to transform data in a presentable format are the key to be successful in this position.
Your key responsibilities
Compile and generate spreadsheets capturing key data
Research, update, and validate data underlying spreadsheet production; strategically fill gaps
Create pivot tables and modify spreadsheets to achieve analytical goals
Manage spreadsheets and maintain data currency to ensure accurate data availability for managers and decision-makers
Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions
Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables
Designed, recorded, and executed macros to automate data entry inputs
Formatted spreadsheets and workbooks for print, document reproduction, and presentations
Business, Supply Chain or any other relevant degree
Good analytical skills
Data Driven and keen to comprehend and adapt based on business needs
Advanced knowledge of Excel – able to work with large amounts of data and information, manipulate data and extract relevant insights. Preferred if knowledgeable in commands such as vlookup, pivot table, Ifs, goal seek, etc.
Be curious and not afraid to ask questions