Job Description
[Key Responsibilities]
Data Collection and Integration
- Consolidate data from multiple sources on a weekly and daily basis to ensure consistency and integrity of data fields.
- Assist in data mapping and master data construction.
Promotional Activity & Spending Maintenance
- Construct promotion activity database.
- Maintain promotional information by SKU, including period, event theme, price, and consumer activity.
- Collaborate with business and trade marketing teams to collect the cost of each promotional activity, define an allocation rule to build a comprehensive database.
- Populate the data in a template for each product and promo event. Put in the investment per case for each pack in the promo event
Data Reporting
- Work with RGM team to create reports at the area, channel, and retailer levels.
[Required Skills]
- Proficient in Excel and Power Query.
- Familiarity with Python or R is preferred.
- Strong logical thinking and data interpretation skills.
Primary Location
Taipei Office
Additional Locations
Worker Type
Employee
Worker Sub-Type
Fixed Term (Fixed Term)
Time Type
Full time
