Data Analyst S&OP

Description

Job Summary: Responsible for administering, transforming, and analyzing critical information for S&OP processes, providing technical support. Key Highlights: 1. Administer, transform, and analyze critical information for S&OP. 2. Develop and maintain automated reports and dashboards in Power BI. 3. Ensure data integrity and quality for decision-making. **Location:** Lima, PE, 15823 **\#job\-location.job\-location\-inline { display:** inline; } **Department:** Supply Chain **Full\-time or Part\-time:** Full\-Time **Job Type:** Employee **Shift:** On site **.buttontextc23a3e91845ba7f3 a{ border:** 1px solid transparent; } .buttontextc23a3e91845ba7f3 a: focus{ border: 1px dashed \#00a1de !important; outline: none !important; } Accelerate the possible by joining a winning Amcor team that’s transforming the packaging industry and improving lives around the world. At Amcor, we unpack possibility through our innovative and responsible packaging to provide solutions that benefit our customers, our people and our planet. More than 10,000 consumers worldwide encounter our products every second and rely on us for safe access to food, medicine and other goods. We value their trust by making safety our guiding principle. It’s our core value and integral to how we do business. Beyond this core principle, our shared values and behaviors unite us as we work together to elevate customers, shape lives and protect the future. We champion our customers and help them succeed. We play to win – adapting quickly in an everchanging world – and make smart choices to safeguard our business, our communities and the people we serve for generations to come. And we invest in our world\-class team, empowering our colleagues to unpack their potential, because we believe when our people grow, so does our business. To learn more about playing for Team Amcor, visit www.amcor.com I LinkedIn I Glassdoor I Facebook I YouTube **Job Title:** Data Analyst S\&OP **Business Unit:** Middle Americas **Office Location:** Lima **Department:** Supply Chain Management **Direct Report Job Title:** SUPPLY PLANNING MANAGER MIDDLE AMERICAS **1\. Job Purpose:** Responsible for administering, transforming, and analyzing critical information for S\&OP processes. Serve as the primary technical support for report automation, dashboard development, database management, and KPI generation—ensuring reliable, timely, and standardized information for decision-making. **2\. Job Scope:** Not applicable. **3\. Key Responsibilities:** Consolidate, clean, and manage databases sourced from multiple systems. Design, develop, and maintain automated regional reports. Develop operational and executive dashboards in Power BI. Automate processes using Advanced Excel, Power Query, Power Pivot, and VBA (Macros). Ensure data integrity, consistency, and quality used by the S\&OP team. Generate, update, and maintain performance indicators (KPIs) for Demand Planning, Supply Planning, Customer Service, Logistics, and Inventory. Develop tools to reduce manual effort and increase team productivity. Support the S\&OE process by generating data and analysis for decision-making. Identify trends, variances, and improvement opportunities through data analysis. Support Data Management, Data Governance, and continuous improvement initiatives. Participate in digital transformation and process automation projects. Provide technical support to users on analytics and visualization tools. Comply with Amcor’s Four Pillars and Six Life-Saving Rules. Comply with Internal Work Regulations, Internal Occupational Safety and Health Regulations, and Amcor Safety Standards. Comply with current BRCGS Packaging, BPM, and HARA standards. **4\. Key Challenges and Complexities:** Increase visibility and availability of information for decision-making. Significantly reduce manual effort associated with reporting and analysis. Improve data quality and reliability within the S\&OP function. Standardize KPIs and reports at the regional level. 5\. Relationships **Internal:** **External:** 6\. Requirements 6\.1 Work Experience and Academic Level **Required Experience:** Minimum 3–5 years of experience as a Data Analyst or in similar roles. **Academic Level:** Technical or university degree in Computing, Systems, Informatics, Data Analytics, Statistics, Business Administration, or related fields. Knowledge / Skills / Competencies **Knowledge / Skills / Competencies:** Knowledge Advanced / Expert Excel Power Query Power Pivot VBA and Macros Advanced Power BI Data modeling and transformation Dashboard and KPI development Database management and consolidation Flexible packaging production processes (desirable) **Desirable Knowledge:** SAP Data Governance Master Data Management Process automation and digitalization tools **Competencies:** Analytical thinking Attention to detail Organization and planning Problem-solving Internal customer orientation Proactivity Ability to simplify complex information Collaborative work **.buttontextb0a45bf21434917c a{ border:** 1px solid transparent; } .buttontextb0a45bf21434917c a: focus{ border: 1px dashed \#00a1de !important; outline: none !important; } About Amcor Amcor is the global leader in developing and producing responsible consumer packaging and dispensing solutions across a variety of materials for nutrition, health, beauty and wellness categories. Our global product innovation and sustainability expertise enables us to solve packaging challenges around the world every day, producing a range of flexible packaging, rigid packaging, cartons and closures that are more sustainable, functional and appealing for our customers and their consumers. We are guided by our purpose of elevating customers, shaping lives and protecting the future. Supported by a commitment to safety, over 75,000 people generate $23 billion in annualized sales from operations that span over 400 locations in more than 40 countries. **NYSE:** AMCR; ASX: AMC www.amcor.com \| LinkedIn \| YouTube **.jobdescription { font\-family:** customcef69263c61d4b27bc8d1; font\-size: 16px; }