Purpose & Overall Relevance for the Organization:

Your task as an Excess Inventor Assistant Manager / Data analyst is to create, develop and maintain dashboards/reports and support the active management of excess stock levels across all sales channels and stock destinations in Europe.

The Excess stock management process ensures a healthy inventory level of outdated products and supports Europe´s net-sales and contribution target.

Key Responsibilities:

Responsible to support the Excess Inventory Management team in creating regular analysis of inventory development and excess stock levels to ensure proper database for inventory control process and actions.

• Actively analyse and evaluate the inventory development of current and past seasons and provide regular qualitative feedback on latest trends and developments

• Create and maintain analysis and reporting tools that support easy and fast visualization of data using Power BI

• Operationalize and automate activities for efficient and timely production of data visuals (Alteryx, SQL, databricks, Excel, PowerBI) and enable better and faster decision making

• Create professional and easy to read dashboards to be able to present relevant information to all levels of management and take meaningful decisions.

• Develop and propose initiatives to reduce excess inventories levels,

considering qualitative and financial aspects

• Prepare and execute stock transfers following defined timelines and report results
• Liaise with departments relevant for the excess inventory process such as Brand Business Units, Factory Outlet, Finance and Market Sales Unit

• Regularly retrieve data out of SAP, Business intelligence (Micro Strategy), Databricks, SQL, Power BI and Alteryx data flow

• Proactively/ independently carry out special projects and assignments 

Project based

• Work with Europe Demand planning analytics team to enhance reporting capabilities (Data Analyst journey focused on Databricks/Lakehouse, Business Intelligence journey focused on PowerBI dashboards)
• Manage the transition from legacy system to new system in terms of testing, reporting and analytics

Key Relationships:

• Europe Finance and Demand Planning
• Cluster Clearance Managers
• Factory-Outlet Merchandising
• Market Sales Unit
• SCM Ranging, Logistics, Inventory, Order Fulfilment

Knowledge, Skills and Abilities:

• Good knowledge of MS Office, SQL/Databricks
• Expert knowledge of Excel, SAP/AFS, SAP/BI, Power BI, Power Query
• Fluency in English (written and verbal)

Requisite Education and Experience / Minimum Qualifications:

• University degree in Business Administration with a focus on marketing/sales/finance (or equivalent qualification)
• Minimum 2 years of work experience in cross-functional position, ideally with sales/marketing/finance background