Administrative Assistant

Overview

This position contributes to the success of the Pepsi Beverages Company by providing administrative support to the West Branch Michigan in Outstate MI Market.

Responsibilities

• Daily Cashiering Processes, utilizing internal and external systems
• Daily Dispute case research and resolution utilizing internal systems
• Weekly/Daily research of short pays and rebills, analyzing trends and correcting
• Weekly Payroll Processes as needed, utilizing Kronos Timekeeper and SAP
• Assist with Location Onboarding processes as needed
• Actioning on and communicating end of period results as needed
• Timely processing of AP activities utilizing multiple systems including SAP
• Provide dedicated administrative support in a professional, confidential and organized manner
• Monitor email and phone calls; proactively respond to and/or coordinate issues when possible
• Maintain and update distribution and contact lists
• Organize/maintain department files, both electronic and hard copy
• Daily interaction with all Functional Teams
• Maintain high level of integrity and professionalism in handling confidential material on a daily basis
• Ability to work proficiently and calmly under pressure situations
• Administer specific applications/time bound processes in an accurate and timely manner
• Highly proficient in Microsoft Office (excel, word, power point, outlook)
• Basic administrative support (phones, copies, office supplies, etc.)
• Capable of creating customized actionable market reports using pivot tables, advanced formulas or macros
• Work on special projects as necessary
• Other duties as assigned to support the team in the administrative function
• Support Community projects
• Support Management to provide them more time with front line
• Ensure participation and compliance with all Payroll/GCS audit procedures
• Analytical ability to summarize data, develop recommendations and implement solutions
• Accurate and detail-oriented individual
• Respond to or Create Accounts Receivable cases via SAP
• Organize and maintain accurate records, both electronically and hard copy
• Distribute AR reports weekly
• Monitor emails and phone calls, providing quick and accurate follow up.
• Adhere to Control and Compliance guidelines in all areas of business
• Complete special projects
• Assist Settlement Admin and act as back up for vacation

• Reconcile Delivery Driver collections, noting and addressing discrepancies
• Generate and distribute reports
• Ability to lift FSV coin deposit weighing as much as 50 lbs.
• Provide information to incoming callers or direct to someone to assist

• The expected compensation range for this position is between $33,300 - $53,150 per year based on a full-time schedule
• Location, confirmed job-related skills and experience will be considered in setting actual starting salary
• Paid time off subject to eligibility, including paid parental leave, vacation, sick, and bereavement
• In addition to salary, PepsiCo offers a comprehensive benefits package to support our employees and their families, subject to elections and eligibility: Medical, Dental, Vision, Disability, Health and Dependent Care Reimbursement Accounts, Employee Assistance Program (EAP), Insurance (Accident, Group Legal, Life), Defined Contribution Retirement Plan.

• 2+ years' experience Admin Support
• Show strong attention to detail
• Strong skills in Excel and Outlook
• Strong team player / assist others and take on projects
• Ability to prioritize work with a strong sense of urgency
• Demonstrate tact, professionalism, and respect for others