Supply Chain Analyst

Abarta-Coca--cola-Beverages; Houston (PA); On-site; USD 65,000 - 85,000; Full time

Job summary

ABARTA Coca-Cola Beverages is seeking a Supply Chain Analyst to turn data into actionable insights for cost-efficient operations. You will build reports, dashboards, and models that support planning, inventory, and logistics across teams.

The ideal candidate has advanced Excel, Power BI, and strong data communication skills to translate complex data into clear recommendations for leadership and collaborators across the organization.

Qualifications

• Bachelor’s degree in supply chain, business, analytics, or related field.
• Advanced Excel (pivot tables, VLOOKUP/XLOOKUP, nested formulas) and Power BI experience.
• Strong analytical and communication skills.

Responsibilities

• Develop, maintain, and analyze supply chain reports, dashboards, and metrics.
• Analyze inbound/outbound logistics, optimize freight spend, and assess performance.
• Collaborate with operations, logistics, procurement, and leadership to drive improvements.

Skills

Advanced Excel

Power BI

Analytical skills

Education

Bachelor's in Supply Chain / Analytics

Tools

Power Query

VLOOKUP/XLOOKUP

Macros

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.