Data Analyst S&OP

Amcor
Lima
Workplace: OnsiteFull timeFunction: Data Analytics & Business IntelligenceExperience: 3-5 yearsSkills: ["Analytical thinking","Attention to detail","Organization and planning","Problem-solving","Internal customer orientation","Proactivity","Ability to simplify complex information","Collaborative work"]

Own and analyze critical S&OP data to enable reliable, timely, and standardized decision-making. Build and maintain automated reports and dashboards for the region using Power BI, Power Query, Power Pivot, and advanced Excel (including VBA macros). Consolidate and clean data from multiple sources, generate and update KPI reporting for planning and logistics functions, and support data management/governance and digital transformation initiatives.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Amcor
Amcor
7 hours ago

Data Analyst S&OP

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 7 hours agoStatus: Live

Job Summary

Own and analyze critical S&OP data to enable reliable, timely, and standardized decision-making. Build and maintain automated reports and dashboards for the region using Power BI, Power Query, Power Pivot, and advanced Excel (including VBA macros). Consolidate and clean data from multiple sources, generate and update KPI reporting for planning and logistics functions, and support data management/governance and digital transformation initiatives.
Location: Lima
Workplace: Onsite
Employment Type: Full time
Job Function: Data Analytics & Business Intelligence

Key Responsibilities

  • •Consolidate, clean, and manage databases from multiple sources for S&OP.
  • •Design, develop, and maintain automated reports for the region.
  • •Develop operational and executive dashboards in Power BI.
  • •Automate processes using advanced Excel (Power Query, Power Pivot, and VBA macros) to reduce manual work and improve productivity.
  • •Generate, update, and maintain KPIs for Demand Planning, Supply Planning, Customer Service, Logistics, and Inventory.

Key Requirements

  • •3-5 years of experience as a Data Analyst or in a similar role.
  • •Advanced/Expert Excel plus Power Query, Power Pivot, and VBA (Macros).
  • •Advanced Power BI experience, including building dashboards and KPI indicators.
  • •Data modeling and transformation skills; ability to construct, consolidate, and manage databases from multiple sources.
  • •Professional technical/university degree in Computing, Systems, Informatics, Data Analytics, Statistics, Administration, or related fields.
Experience:3-5 years
Education:
Skills:Analytical thinkingAttention to detailOrganization and planningProblem-solvingInternal customer orientationProactivityAbility to simplify complex informationCollaborative work
Tech Stack:ExcelPower QueryPower PivotVBAMacrosPower BISAP

Company Brief

Amcor
Global packaging company that designs and manufactures flexible and rigid packaging solutions for food, beverage, healthcare, personal care, and home care products. Focuses on improving product protection, shelf life, recyclability, and sustainability.
Industry: Printing & Packaging
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: Zurich, Switzerland
Founded: 1860
WebsiteLinkedIn