Promotion Analyst

Promotion Analyst

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