Trade Marketing Specialist; 通路营销市场专员

Overview

Drive PepsiCo China's promotional, rebate, inventory, and store execution decisions across all channels with data. Through standardized processes, convert system data into actionable rebate calculations, promotion tracking, store inspection reports, and bonus settlements, ensuring marketing investments are "traceable, auditable, and optimizable."

Responsibilities

Rebate and Promotion Calculation

• According to customer contracts & TM policies, complete monthly, quarterly, and annual rebate calculations for distributors/wholesalers/IDTs.

Channel Activity Tracking

• Maintain master data related reports for MT and IDT channel activities.

Bonus and Incentive Settlement

• Based on TM quarterly SDO achievement rates, calculate bonuses for distributors and sales teams.

Store Execution & Inspection

• Follow up on the entire process of NPD, IPAR, and inspection projects from quotation to approval, ordering, and registration.

National Group Purchase Verification Data Support

System Data Operations and Maintenance

Process Optimization

• Convert manual Excel templates into Power BI/Alteryx automated dashboards, shortening month-end closing time and automating Dashboard and SOP updates.

Qualifications

• Bachelor's degree or above, preferably in Statistics/Finance/Marketing/Supply Chain Management related fields.

• Experience: 2+ years of FMCG or retail data analysis, Trade Marketing experience, familiar with at least one of SAP/Nielsen/BI tools.

• Proficient in Excel (functions, Power Query), Power BI or Tableau, capable of building independent models.

• High digital sensitivity.

Bonus Points

• Experience with SQL/Python automation, able to reduce 3 hours of manual merging to 10 minutes.

• Participated in FMCG TM or System go-live projects.