Trade Marketing Analyst – Perfect Store (DTS)

About the role

The Trade Marketing Analyst will own and scale the Perfect Store strategy for PepsiCo in Puerto Rico, turning strategy into winning in‑store execution that drives volume, share of market and net revenue growth. The role is the single point of accountability for how PepsiCo appears on the shelf in the Direct‑to‑Store (DTS) channel.

Key responsibilities

• Lead the evolution and deployment of in‑store execution strategies, defining standards and priorities by channel and customer segment.
• Manage the trade‑marketing and merchandising agenda, ensuring consistent execution at the point of sale.
• Develop the commercial activity calendar, including seasonal programs, innovation launches and brand campaigns.
• Monitor execution through scorecards, audits and performance analysis, translating findings into corrective action plans.
• Use market, sales and in‑store data to identify opportunities and guide investment recommendations.
• Coordinate the deployment of commercial materials and resources, including planning, inventory control and return tracking.
• Drive cross‑functional alignment and communicate execution progress, commercial impact and key learnings.

Required profile

• Bachelor’s degree in Business Administration, Marketing or a related field.
• Previous experience in Trade Marketing, Sales Strategy, Commercial Execution or similar roles within CPG, retail or food‑service environments.
• Experience with Perfect Store / PICoS frameworks, sell‑in/sell‑out analysis and in‑store audit data (mandatory).
• Exposure to Organized Trade (OT) and Direct‑to‑Store (DTS) models is preferred.

Required skills

• Intermediate to advanced Excel (mandatory).
• Intermediate Power BI (mandatory).
• Power Apps and other tracking/database tools (preferred).
• NIQ/Nielsen data platforms (preferred).

What we offer

• Learning and development programs, internal digital platforms and leadership training.
• Financial wellness, flexibility programs and family‑focused benefits.
• Recognition programs for seniority, behavior, leadership and life moments.