Trade Marketing Analyst: Build Winning In-Store Programs

PepsiCo; Guaynabo (PR); On-site; USD 45,000 - 65,000; Full time

Benefits offered by this job

Flexibility program

Wellness Line

Scholarship programs for children

Aid plans for life moments

Job summary

PepsiCo Puerto Rico is seeking a Trade Marketing Analyst to support the execution of the Trade Marketing and Perfect Store agenda. You will provide analytical, administrative and operational support across core fronts, ensuring data accuracy, budget visibility and timely deliverables for informed decisions.

You will maintain calendars, track budgets, develop field-ready playbooks, and prepare dashboards. Collaboration with sales, vendors, and internal teams is essential to drive successful

Qualifications

• Bachelor's degree in Business Administration, Marketing, Finance or related field.
• Bilingual: Spanish & English (intermediate+ English, written and oral)
• Advanced Excel and PowerPoint; working knowledge of PowerBI and tracking/database tools
• Strong analytical skills and attention to detail for budget tracking and performance reporting
• Experience or internships in trade marketing, sales support, finance or commercial roles within CPG (desirable)

Responsibilities

• Maintain commercial activity calendars and coordinate requirements, timelines and status updates across customers and sales channels.
• Track budgets, purchase orders, invoices and spending, partnering with the appropriate teams to identify and address variances.
• Create clear, field-ready playbooks, presentations and execution materials for commercial programs.
• Analyze initiative performance, maintain activity trackers and consolidate results to support business decisions.
• Prepare recurring reports and dashboards covering execution progress, spending and key performance indicators.
• Coordinate with vendors and internal partners on orders, deliveries, inventory and installation schedules for in-store materials.
• Support customer events and consumer programs, including logistics, materials, participation tracking and post-activity documentation.
• Maintain accurate and accessible records, including activity trackers, supporting evidence, financial files and program archives.

Skills

Advanced Excel

PowerPoint

PowerBI

Tracking/database tools

Strong analytical skills

Attention to detail

Education

Bachelor's degree in Business Administration, Marketing, Finance or related field

Tools

PowerBI

Job description

PepsiCo Puerto Rico is seeking a Trade Marketing Analyst to support the execution of the Trade Marketing and Perfect Store agenda. You will provide analytical, administrative and operational support across core fronts, ensuring data accuracy, budget visibility and timely deliverables for informed decisions.

You will maintain calendars, track budgets, develop field-ready playbooks, and prepare dashboards. Collaboration with sales, vendors, and internal teams is essential to drive successful