ABARTA Coca-Cola Beverages
Supply Chain Analyst
Houston, Pennsylvania•Full-time
About the Job
ABARTA Coca-Cola Beverages is a family-owned company committed to being a visible, engaged partner to the customers and communities we serve. We value diversity and individuality and when you thrive, we thrive. ABARTA offers the perks of a large corporation with the personalized touch of a smaller company. We are a workplace that encourages sharing ideas in a supportive environment, growing professionally, maintaining a healthy work/life balance, and interacting with all levels of the organization. We would love for you to become a part of our family to help make our vision of Quenching the Thirst of Our Neighbors a reality!
Summary:
The Supply Chain Analyst is responsible for providing data-driven insights to support efficient, cost-effective supply chain operations. This role analyzes supply chain performance, prepares and interprets reports, identifies improvement opportunities, manages key datasets, and collaborates across departments to enhance operational decision-making. The ideal candidate brings strong analytical skills, advanced Excel capabilities, and experience translating complex data into actionable recommendations.
Responsibilities:
Data Analysis & Reporting:
- Develop, maintain, and analyze supply chain reports, dashboards, and metrics to support strategic planning and daily operations.
- Prepare, present, and clearly communicate data findings to cross-functional partners, including operations, logistics, procurement, and leadership.
- Utilize advanced Excel skills (pivot tables, complex formulas, Power Query, macros preferred) to build tools and models that improve visibility and performance tracking.
- Create and maintain Power BI dashboards to deliver real-time insights and trend analysis.
Supply Chain Operations Support:
- Analyze inbound and outbound logistics performance, including carrier efficiency, freight spend, and service adherence.
- Assist in evaluating transportation and freight opportunities; experience with transportation/freight rates is a plus.
- Support demand planning, inventory optimization, and warehousing workflows through accurate and timely data analysis.
- Help identify, diagnose, and resolve supply chain inefficiencies using data-driven approaches.
Cross-Functional Collaboration:
- Partner with internal teams to support business reviews, root cause analyses, budgeting activities, and process improvement initiatives.
- Present findings and recommendations with clarity to audiences at all levels, tailoring communication style as needed.
- Work closely with vendors, carriers, and internal stakeholders to maintain accurate data and improve operational outcomes.
Qualifications:
- EDUCATION: Bachelor’s degree in Supply Chain, Business, Analytics, Operations Management, or related field.
EXPERIENCE:
- Advanced proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, nested formulas, Power Query, etc.).
- Strong analytical, organizational, and problem‑solving skills.
- Ability to prepare, present, and communicate reports to technical and non‑technical audiences.
- Strong attention to detail and ability to manage multiple priorities.
- Experience with Power BI or similar data visualization tools.
Preferred:
- Experience with transportation, freight rate structures, rate analysis, or carrier management.
- Knowledge of supply chain management systems.
- Prior experience in supply chain, logistics, or operations analytics.
PHYSICAL REQUIREMENTS:
- Prolonged periods of sitting at a desk and working on a computer.
- Ability to lift, carry, or move items up to 20 pounds occasionally (e.g., files, reports, samples, or small equipment).
- Must be able to visually review data, reports, and computer screens for extended periods.
- Ability to communicate clearly in person, virtually, and over the phone.
- Requirement to walk through warehouse or operational areas, which may include standing, walking, or exposure to varying temperatures.
- Ability to travel between facilities or vendor locations as needed.
Additional Information:
ABARTA Coca-Cola Beverages, LLC requires all applicants to undergo a background verification process prior to commencing employment with the company. Employment with ABARTA Coca-Cola Beverages is contingent on the satisfactory completion of a pre-employment background check which may include drug screening. Background verifications will be evaluated according to ABARTA Coca-Cola Beverages guidelines to determine eligibility for this position.
For more job postings and additional information about our company and culture, please visit our careers site at https://abartacocacola.com.