Supply Chain Analyst
Company: ABARTA Coca-Cola Beverages
Job Location: 4900 Pitts. Support Center, PA
Other Potential Locations: Pittsburgh HQ, PA
We are actively seeking enthusiastic team players who want to work with the world’s most trusted and iconic brands.
About ABARTA
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.
Nearest Major Market: Pittsburgh