■Responsibilities
・Design, build, and maintain automated dashboards and reporting for Supply & Inventory Planning (Power BI, Excel) to improve visibility and operational efficiency
・Write and optimize SQL queries to extract and transform data from ERP, BI data sources, and other relevant systems for ad-hoc analyses and recurring reporting
・Develop robust data models and standard definitions (e.g., inventory status, service level, lead time) to ensure one source of truth across stakeholders
・Partner with Supply & Inventory Planners and cross-functional teams to identify issues, quantify impacts, and recommend actions (e.g., excess mitigation, inventory optimization, parameter updates etc)
・Monitor and improve data quality (master data and transactional data) and document reporting logic to ensure reliable planning and business decisions
・Support Supply & Inventory Planners to maintain accurate master data in a timely manner (e.g., item/supplier parameters, lead times, MOQ etc) and establish simple validation checks
・Drive work optimization by identifying repetitive reporting/process tasks and supporting automation initiatives using AI (Copilot) and RPA (e.g., Power Automate, UiPath) in collaboration with planners and relevant functions