job description
Join ams OSRAM, a global leader in optical solutions, as a Specialist in Supply Chain (Systems & Processes) based in beautiful Bali. This role offers a unique opportunity to drive efficiency and innovation in our supply chain operations through advanced data analytics and system optimization.
In this position, you will leverage your expertise in Microsoft Excel, SQL, PowerBI, and Snowflake to transform raw data into actionable insights, ensuring seamless supply chain processes. You will collaborate with cross-functional teams to enhance operational performance, reduce costs, and improve delivery timelines.
If you are passionate about data-driven decision-making and thrive in a dynamic, technology-focused environment, this is your chance to make a significant impact in a leading global organization.
Responsibility
- Develop and maintain advanced Excel macros and SQL queries to automate supply chain reporting and analysis.
- Design and implement PowerBI dashboards to visualize key supply chain metrics and performance indicators.
- Optimize data models in Snowflake to enhance data accuracy and accessibility for supply chain operations.
- Collaborate with procurement, logistics, and production teams to identify process improvements and cost-saving opportunities.
- Monitor and analyze supply chain performance, providing data-driven recommendations for efficiency enhancements.
- Ensure compliance with company policies and industry regulations in all supply chain processes.
- Train and support team members on the use of supply chain systems and data tools.
- Lead continuous improvement initiatives to streamline supply chain workflows and reduce operational bottlenecks.
Qualifications
- Bachelor’s degree in Supply Chain Management, Logistics, Business Analytics, or a related field.
- Proven experience in supply chain systems, data analysis, and process optimization.
- Advanced proficiency in Microsoft Excel (macros, VLOOKUP, pivot tables) and SQL.
- Experience with PowerBI for dashboard creation and data visualization.
- Familiarity with Snowflake or similar cloud-based data warehousing solutions.
- Strong analytical and problem-solving skills with a keen attention to detail.
- Excellent communication and collaboration skills to work effectively with cross-functional teams.
- Certification in Supply Chain Management (e.g., CSCP, CPIM) is a plus.