沛纳海CRM Data Operations Intern
招聘时间
即日起 至 2026-06-06
招聘单位
历峰
所在地区
上海
工作地点
静安嘉里中心办公楼三座
学历要求
不限
实习时长
每周5天，每天6小时
职责描述
Maison: Panerai
Job Purpose
Assist the CRM team in executing digital customer relationship management projects, supporting on data analysis, gift management, other daily admin operations and partly support in Marketing task.
________________________________________
Key Responsibilities
1. Data Analysis
Excel data mapping and processing on CRM data, including:
• VLOOKUP cross-table matching (multi-criteria)
• Pivot table analysis (dynamic data sources + calculated fields)
• Advanced filtering and conditional formatting automation
2. Project Operations Support
• Track store closure information and synchronize real-time updates with reminder alerts
3. Gift Management
• Track gift delivery status (warehouse, boutique, and office)
• Maintain office gift inventory records (storage location, quantity, type)
• Coordinate and document office gift dispatch (purpose, quantity, date)
• Manage incoming gift inventory (arrange storage location and record quantity)
4. SAP PO & Tsuite Order Processing
• Process supplier payment orders and maintain records
5. Administrative Support
• Printing, binding, courier services, and other office tasks
6. Partly support in Marketing task.
• Participate in and support Marketing team activities when campaign or event support is required.
________________________________________
Requirements
• Data Analysis: Proficient in Excel (VLOOKUP, Pivot Tables, advanced filtering, conditional formatting)
• Communication: Strong written and verbal communication skills in both Chinese and English
• Problem-Solving: Ability to work independently and address issues proactively
• Language: Fluent in English (written and spoken)
• Detail-Oriented: Strong organizational skills with attention to accuracy
• Multi-tasking: Capable of managing multiple priorities in a fast-paced environment
Job Purpose
Assist the CRM team in executing digital customer relationship management projects, supporting on data analysis, gift management, other daily admin operations and partly support in Marketing task.
________________________________________
Key Responsibilities
1. Data Analysis
Excel data mapping and processing on CRM data, including:
• VLOOKUP cross-table matching (multi-criteria)
• Pivot table analysis (dynamic data sources + calculated fields)
• Advanced filtering and conditional formatting automation
2. Project Operations Support
• Track store closure information and synchronize real-time updates with reminder alerts
3. Gift Management
• Track gift delivery status (warehouse, boutique, and office)
• Maintain office gift inventory records (storage location, quantity, type)
• Coordinate and document office gift dispatch (purpose, quantity, date)
• Manage incoming gift inventory (arrange storage location and record quantity)
4. SAP PO & Tsuite Order Processing
• Process supplier payment orders and maintain records
5. Administrative Support
• Printing, binding, courier services, and other office tasks
6. Partly support in Marketing task.
• Participate in and support Marketing team activities when campaign or event support is required.
________________________________________
Requirements
• Data Analysis: Proficient in Excel (VLOOKUP, Pivot Tables, advanced filtering, conditional formatting)
• Communication: Strong written and verbal communication skills in both Chinese and English
• Problem-Solving: Ability to work independently and address issues proactively
• Language: Fluent in English (written and spoken)
• Detail-Oriented: Strong organizational skills with attention to accuracy
• Multi-tasking: Capable of managing multiple priorities in a fast-paced environment
