Assistant Manager - BI And Reporting

Overview

This position will be part of the North America Beverage organization. This position contributes to the success of the Pepsi Beverages Company by supporting the Merchandising Center of Excellence team. The Analyst will ensure exceptional operational services are provided by his/her organization to sales employees across multiple teams and markets. The services for the supported teams include assessing and communicating equipment inventory, reviewing and validating orders prior to placement, and monitoring equipment orders from placement to delivery using internal systems. Additionally, preparing order/tracking/delivery reporting for internal and external audiences, as needed. Continuously identify opportunities and implement processes to improve quality and timeliness of output.

Responsibilities

• Ensure accurate and timely delivery of tasks regarding Permanent or Temporary merchandise equipment:
• review and validate field orders for prior to placement
• monitor equipment orders from placement through to delivery using internal systems
• maintain equipment inventory database by tracking orders as they come thru the system
• report any inventory variances and issues to Sector or Division teams timely
• preparing order tracking and delivery reporting for internal and external audiences, as needed
• prepare and submit equipment status by market or customer to sales leaders
• Indepth analysis of status, delays and tracking
• Work across multiple functions to aid in collecting insights for action-oriented cause of change analysis
• Recognize opportunities and take action to improve delivery of work
• Implement continued improvements and simplifications of processes, standardization of reporting and optimal use of technology
  
  

• +3 years of experience in Data analysis/Finance/Marketing
• Bachelor’s in economics/ finance/engineering
• Experience with advanced Excel and Power BI
• Propensity to learn PepsiCo software systems
• Ability to provide superior customer service