Asahi Europe & International (AEI) is a subsidiary of Asahi Group Holdings Ltd, a global beverage and food company listed on the Tokyo Stock Exchange in Japan. Employing over 12,000 people, AEI have world-class brewing and production facilities in 8 markets – UK, NL, ITL, PL, CZ, SK, HU, RO. In most of these markets, we are the leading brewer with full portfolio of Domestic and International premium and super premium brands.
In other parts of Europe and across Africa, the Middle East, Latam, and North America, our international business - EMEA & Americas (AEI EMEAA) are growing our broad portfolio of well-established and iconic international brands such as Peroni Nastro Azzurro, Pilsner Urquell, Grolsch, Kozel and Asahi Super Dry both directly and through our global distribution network. The business is well positioned to inspire people around the world to drink better through our shared purpose of Creating Meaningful Connections.
Very excitingly, EMEAA has recently purchased a fantastic new production facility in Wisconsin USA, Octopi Beverages. This marks a key step forward in accelerating our growth journey and realizing our ambitions for our Global Brands, most notably Asahi Super Dry for North America.
We are seeking an analytical and detail-oriented Data Coordinator to join our Supply Chain team. This role will play a pivotal part in managing the integrity and visibility of data used across demand and supply planning, innovation, inventory, and all other reporting processes. You will support the creation and maintenance of critical files, datasets and PowerBI dashboards used in Demand & Supply Planning, while ensuring their accuracy. You will work closely with the Demand Planners, Customer Service, Commercial, and Finance teams to deliver data-driven insights and improvements.
Key Responsibilities
Updating Market DRM Files:
1. Update DRM files pre-DRM catch-ups and after month-end in a timely manner
2. Update with invoicing and open orders
3. Add new SKUs (update master data & add into DRM SKU list)
4. Action pricing changes and coordinate with finance to update NPR/HL and GM/HL
5. Repeat on monthly basis, capturing LM information for Month-on-Month comparison
Collate and Review Submitted Numbers into DRM Base post-DRMs:
6. Update DRM base file (DRM 2025, LM, 2026, R&Os) with information from individual market DRM files
7. Check numbers and formulas pull through correctly and refresh pivot tables
8. Update SKU master and BP master tabs
SKU Activity and Innovation Data governance:
9. Maintain and track SKU changes and new product launch (PIRs) data in the DRM and supply planning process
10. Ensure PIR volumes and timings are accurately reflected in planning files
11. Identify and resolve any discrepancies in innovation data with Planning and Commercial teams
Data Capture and Organisation:
Manage the storage, organisation, and timely refresh of input datasets from both internal systems and external sources
12. Expand data coverage to enhance visibility and support deeper insights for the planning team
13. Generate and analyse ad hoc reports using SAP queries to support operational and strategic decision-making
Update Power BI Reports:
14. Maintain and enhance Power BI dashboards, including:
15. Daily Sales report (DRM info Monthly)
16. KPI dashboard Monthly (Forecast Accuracy, Lead Time, etc.)
17. Supply Planning & Inventory
18. PIR Overview
19. Ensure all reports are refreshed in line with cycle timelines and reflect latest available data
Update Presentations for DRM and SRM:
20. Use information from the DRM Base and PowerBI to update slides, tables, and graphs of DRM & SRM presentation decks
Collaboration:
21. Work closely with the demand planning team
22. Highlight any issues with master data and reporting
23. Collaborate with International Supply Chain Analysts and Commercial Teams to influence operational behaviours of customers to optimize joint supply chain practices order management, forecasting)
Additional Responsibilities:
24. Assist in the preparation and coordination of monthly and quarterly demand planning meetings
25. Support the development and implementation of demand and supply planning processes and tools
26. Maintain accurate and up-to-date documentation of demand planning activities
27. Provide administrative support, including scheduling meetings and managing communications
28. Participate in continuous improvement initiatives to enhance efficiency and accuracy across End-to-End supply chain processes
Requirements:
29. Proficiency in Microsoft Excel
30. Experience in Power BI and SAP essential
31. Strong analytical skills and attention to detail
32. Excellent communication and interpersonal skills
33. Ability to work collaboratively in a team environment
34. Prior experience in demand planning or supply chain management is a plus
Skills:
35. Data analysis and reporting
36. Time management and organizational skills
37. Problem-solving and critical thinking
38. Customer service orientation
Personal Attributes:
39. Highly organized and able to manage multiple tasks simultaneously
40. Excellent communication skills
41. Ability to work independently and as part of a team
We are committed to nurturing a workplace where we celebrate and respect difference, and support everyone to be true to who they are! At Asahi Europe and International we believe you can SHINE AS YOU ARE - no matter your age, gender, ethnicity, sexual orientation, disabilities, religion, or beliefs. We want to support you to be courageous in your individuality and to know that whoever you are and whatever your circumstances, you can belong with us without having to conform.