[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.