Supply Chain Analyst

ABARTA Coca-Cola Beverages, LLC; Pittsburgh (Allegheny County); On-site; USD 65,000 - 90,000; Full time

Job summary

ABARTA Coca-Cola Beverages, LLC is seeking a Supply Chain Analyst to provide data-driven insights for cost-effective operations. You will analyze performance, prepare reports, and collaborate across departments to drive improvements with strong Excel and Power BI skills.

The role supports demand planning, inventory optimization, and warehousing workflows, and requires presenting findings to diverse audiences. Some travel between facilities may be needed.

Qualifications

• Bachelor’s degree in Supply Chain, Business, Analytics, or related field
• Advanced Excel skills (Pivot Tables, VLOOKUP/XLOOKUP, Power Query)
• Strong analytical, organizational, and problem-solving abilities
• Ability to present reports to technical and non-technical audiences
• Experience with Power BI or similar data visualization tools

Responsibilities

• Develop, maintain, and analyze supply chain reports and dashboards.
• Present data findings clearly to cross-functional partners.
• Build tools using advanced Excel features to improve visibility.
• Create Power BI dashboards for real-time insights and trends.
• Analyze inbound/outbound logistics performance and freight spend.
• Support demand planning, inventory optimization, and warehousing workflows.
• Collaborate with internal teams and external partners to drive improvements.

Skills

Advanced Excel

Power BI

Analytical skills

Communication of reports

Education

Bachelor’s degree in Supply Chain or related field

Tools

Power BI

Power Query

Job description

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.