Supply Chain Analyst

ABARTA Coca-Cola Beverages; Houston (PA); On-site; USD 65,000 - 95,000; Full time

Job summary

ABARTA Coca-Cola Beverages in the United States seeks a Supply Chain Analyst to transform data into actionable insights across logistics, inventory, and operations. You will build reports, dashboards, and models to inform budgeting and strategic decisions.

Key requirements include a Bachelor's in a related field, advanced Excel and Power BI skills, and the ability to present findings to both technical and non-technical audiences. Travel between facilities may be required.

Qualifications

• Bachelor’s degree in Supply Chain, Business, Analytics, Operations Management, or related field.
• Advanced proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, Power Query).
• Strong analytical, organizational, and problem-solving skills.
• Ability to prepare, present, and communicate reports to technical and non-technical audiences.
• Experience with Power BI or similar data visualization tools.

Responsibilities

• Develop, maintain, and analyze supply chain reports, dashboards, and metrics to support planning and operations.
• Prepare, present, and communicate data findings to cross-functional partners.
• Create and maintain Power BI dashboards for real-time insights.
• Analyze inbound/outbound logistics performance and freight spend.
• Assist in demand planning, inventory optimization, and warehousing workflows.

Skills

Advanced Excel

Data analysis

Communication

Problem-solving

Attention to detail

Education

Bachelor's degree in Supply Chain, Business, Analytics, Operations Management, or related field

Tools

Power BI

Excel

Job description

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

• 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.