Hybrid Student Intern, Buying and Planning Data Analytics

at Celestica

• Job title: Student Intern, Buying and Planning Data Analytics
• Job type: Internship
• Experience level: Entry level
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: ERP, Tableau
• Location requirements: Hybrid, Toronto, Canada

About the role

• Intern providing data driven support for Buying and Planning teams at Celestica. Engaging in inventory management, supplier negotiations, and data analysis within the Supply Chain team.

Responsibilities

• Act as a key member of the Supply Chain team by providing data driven support to the Buying / Planning teams.
• Redeploying Celestica’s inventory through negotiating pricing and sales, i.e. E&O Deployment
• Working with suppliers to negotiate VMI and Replenishment Lead Time improvement programs
• Work to reduce Days of Supply on key components, which will help with reducing overall inventory
• Collaborating with internal IT team to develop customer requested reports
• Work on customer data feeds
• Mitigate supply chain risk by running BOM risk analysis reports, Safety Stock solutions, Inventory Optimization strategies
• Setting up external Hubs, working with internal teams to coordinate, ad hoc Quarterly freight and hub management
• Data analysis and recommendations based on trend analysis
• Processing rapid reports from Supply Chain Directors, ad hoc

Requirements

• Enrolled in a Computer Science, Data Analytics, Supply Chain, General Engineering, or a General Business program in a recognized university, completing 3rd of a 4-year program of study.
• Understanding of Supply Chain strategies
• Advanced Microsoft Office skills, especially Excel and PowerPoint, or Google Suite skills
• Knowledge of basic computer applications and the ability to learn and use multiple applications specific to this department, including ERP tools
• Knowledge of SAP would be an asset
• Knowledge of dashboard tools (PowerBi, Tableau, etc.) would be an asset
• Ability to analyze data to extract opportunities and risks
• Ability to handle multiple tasks while maintaining attention to detail and accuracy and working under tight time deadlines
• Ability to evaluate, prioritize, and problem solve a variety of tasks to ensure their timely and accurate completion
• Ability to communicate effectively, both verbally and in writing, with a wide variety of internal and external customers.

Benefits

• Experience working for one of the largest Canadian global technology companies
• Possibility of a student casual contract position after completion of internship
• Possibility of a full-time position after completion of degree
• Access to Celestica’s development programs and projects
• Celestica's Time Off to Volunteer program – two paid days off to volunteer per year
• Fun intern activities including celebration events and networking
• Internal recognition programs and rewards for stellar performance