Supply Chain Analyst

We need to output HTML fragment with sections: About the role? Actually posting includes "About ABARTA..." and "Summary". We need headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Use only sections that have real specific content. Let's parse. Content: - About ABARTA... (company description). Could map to "About the role"? Actually "About the role" is for role description; but we have a summary. Could use "About the role" heading for summary? The instruction: use

for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can use those headings if content exists. We have: - Summary: "The Supply Chain Analyst is responsible for providing data-driven insights..." That's role description. Could go under "About the role". - Responsibilities: list bullet points. - Qualifications: includes Education, Experience, Preferred, Physical Requirements. Could map to "Qualifications" heading (maybe includes Education, Experience). Also "Requirements" maybe separate? The posting has "Qualifications" with subheadings Education, Experience, Preferred, Physical Requirements. Could treat "Qualifications" as heading and include subpoints. - Skills: Not explicitly listed but could be derived from qualifications: advanced Excel, Power BI, analytical, communication, etc. But we should not invent content; only include if posting explicitly states them. The posting does mention skills: "Advanced proficiency in Microsoft Excel", "Strong analytical, organizational, and problem‑solving skills", "Ability to prepare, present, and communicate reports", "Strong attention to detail", "Experience with Power BI or similar data visualization tools". Those are skills. Could create a Skills section with those bullet points. However we must not create sections unless posting has real specific content for it. It does have those skill statements. So we can include Skills. - Benefits: Not mentioned. No benefits details. So omit Benefits. - Pay: Not mentioned. Omit. - Schedule: Not mentioned. Omit. Thus sections: About the role, Responsibilities, Qualifications, Skills. Possibly also Requirements? The posting has "Qualifications" but not separate Requirements. Could we treat "Qualifications" as Requirements? But we already have Qualifications. The instruction says use headings e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We can choose to include Requirements if there is content like "Education", "Experience". But we already have Qualifications covering that. To avoid duplication, we could map Education/Experience to Requirements and keep Qualifications for Preferred? But better to follow typical: Requirements = mandatory qualifications; Qualifications = preferred? However posting lumps them together. To be safe, we could create a Requirements section for Education and Experience (mandatory) and a Qualifications section for Preferred and Physical Requirements? But that may be splitting hairs. The instruction: "Prefer a few substantive sections over many thin ones." So better to have fewer sections. Let's combine Education, Experience, Preferred, Physical Requirements under a single "Qualifications" heading. That seems fine. Skills: we can extract from the qualifications bullet points: advanced Excel, Power BI, analytical, organizational, problem-solving, communication, attention to detail, etc. Those are skills. We'll list them. Now we need to remove boilerplate: cookie/navigation/legal/EEO etc. Not present. We need to preserve all substantive information. Must not lose any details. Let's extract content: About ABARTA paragraph: "We are actively seeking enthusiastic team players who want to work with the world’s most trusted and iconic brands. About ABARTAABARTA 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!" Note there is a typo: "About ABARTAABARTA". We'll keep as is. 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: bullet list under headings: Data Analysis & Reporting, Supply Chain Operations Support, Cross-Functional Collaboration. Each has sub-bullets. We need to preserve all bullet points. Let's list them: 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, Experience, Preferred, Physical Requirements): 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: background verification etc. This is boilerplate? It's about hiring process but not EEO. It's substantive? It's about background check. Should we keep? The instruction: remove cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate. Background verification is not exactly those; it's part of hiring process. Might be considered legal boilerplate? It's about employment contingency. Might be considered legal. Safer to drop? The instruction says remove legal boilerplate. This is legal. So drop Additional Information. Also the line "For more job postings and additional information about our company and culture, please visit our careers site at https://abartacocacola.com." That's navigation/link; drop. Now Skills section: we need to list skills derived from qualifications. But we must not invent. However the qualifications already list skills like advanced Excel, Power BI, analytical, organizational, problem-solving, communication, attention to detail. Those are explicitly stated. So we can create a Skills section with those bullet points. Ensure we don't duplicate content already in Qualifications? The instruction says preserve ALL substantive information; we can keep it in both sections? That would duplicate. Better to keep it only once. Since we already have Qualifications covering education, experience, preferred, physical requirements. The skills are part of Experience bullet points. If we move them to Skills, we might lose them from Qualifications. But we could keep them in Qualifications under Experience and also list them in Skills? That duplicates. To avoid duplication, we could keep Qualifications as is (including those skill bullets) and not create a separate Skills section. However the instruction encourages using Skills heading if there is real specific content. The posting does have skill statements; we could treat them as Skills section and move them there, but then we would lose them from Qualifications unless we also keep them there. But we could keep Qualifications focusing on Education and Experience (including the skill bullets) and also have Skills summarizing them? That duplicates. Better to follow typical resume: Qualifications includes education and experience; Skills is separate for technical skills. Since the posting already lists skills under Experience, we could still create Skills section and keep them there, and maybe remove them from Experience to avoid duplication. But then we would lose the detail that they are part of Experience. However the instruction says preserve ALL substantive information; we can preserve them in Skills section and still keep them in Experience? That would be duplication but still preserving. Duplication is not prohibited explicitly, but "Prefer a few substantive sections over many thin ones." Duplication may be considered thin? Not sure. I think we can keep Qualifications as is (including skill bullets) and not add a separate Skills section, to avoid duplication and keep sections few. However the instruction says we can use Skills heading if there is real specific content. It's optional. I'd lean to include Skills to demonstrate ability to follow heading usage, but we must ensure not to lose info. We could keep the skill bullets in both places; it's still preserving all info (just duplicated). That might be acceptable. Let's decide: include Skills section with bullet points: 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. Now we need to output HTML fragment with

headings and

• for lists,

  for prose. We need to include About the role heading with prose combining the initial paragraph and Summary? Could combine them. Let's craft:

  About the role

  We are actively seeking enthusiastic team players who want to work with the world’s most trusted and iconic brands. About ABARTAABARTA 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