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.
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!
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.
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.
- 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.
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.
#ABINDSJ
