Student Intern, Smart Energy - Pricing Management and Product Data Analysis

Student Intern, Smart Energy - Pricing Management and Product Data Analysis

Date: Sep 27, 2024

Location: Toronto, ON, CA

Celestica (NYSE, TSX: CLS) is a US$7.9 billion global leader in design, manufacturing, hardware platform and supply chain solutions. We bring global expertise and insight at every stage of product development - from the drawing board to full-scale production and after-market services. Through our unrivalled customer-centric approach, we partner with leading companies in aerospace and defense, communications, enterprise, healthtech, industrial, capital equipment, and smart energy to deliver solutions for their most complex challenges.

Celestica is a high-integrity work environment and when you join Celestica you are a part of a leading global company that enables the world’s best brands, and contributes to our innovative and collaborative solutions that help our customers unlock the potential of the future.

Our global network spans 15 countries with 26,000 employees across the Americas, Europe and Asia. At our Toronto headquarters, we are focused on attracting top talent into our organization, including interns from universities and colleges. Celestica's internship program provides students with valuable development through real-life work experience, exciting projects and networking with industry professionals.

Benefits for Students Include:

• 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

What’s in it for you?

• Opportunity: Job experience at a large Canadian-based global company
• Innovation: We look to our employees to implement new ideas and improve the way we do things
• Collaboration: Students work as part of global teams, enabled by collaborative technology
• Sustainability: We uphold strong ethics, reduce our impact on the environment and empower employees to give back to the community with two paid days off per year to volunteer
• Development opportunities: including soft skills courses, innovation projects and mentorship
• Networking: Strategically build your professional network to advance your career and deepen relationships across your peers and colleagues.
• Fun: Our interns have the opportunity to participate in fun activities including intern social events, Celestica’s charitable initiatives and our Spirit Week activities

About this opportunity:

• Advanced proficiency in MS Office (ex. Microsoft Excel functions such as VLOOKUP, PIVOT tables, Indexing, and data analysis).
• Strong analytical skills.
• Strong organizational skills.
• Excel Macros and VBA are an asset.
• Knowledge of SQL programming language is an asset.

Activities:

• Understand content of customer Bill of Material (BOM) and Engineering drawings.
• Read and process the customer "Approved Vendor List" (AVL).
• Will be trained to analyze and deploy both the technical and commercial impacts of the Engineering Changes Notices (ECN).
• Consolidate, tabulate, analyze and report on various topics, commitments, and performance metrics.
• Communicate and report data issues and other requirements to internal and external contacts.
• Understand and process supply chain related parameters like Lead Time (LT), Minimum Order Quantity (MOQ) and Estimated Annual Usage (EAU).
• Participate in material bid pricing activities and interact with global customer business units.
• Coordinate, send and negotiate quote tenders with suppliers to establish cost and set pricing.
• Research Energy or other customers products and market trends.
• Create presentations and reports using Excel & PowerPoint.
• Support customers to resolve pricing management related issues for products.
• Will have exposure to SAP and internal databases and applications. In some case will work with business and IT to maintain and develop new applications.

Physical Demands:

• Duties of this position are performed in a normal office environment.
• Duties may require extended periods of sitting and sustained visual concentration on a computer monitor or on numbers and other detailed data.
• Repetitive manual movements are frequently required (e.g. data entry, using a computer mouse, etc).

Area: Global Supply Chain Services

Start Date: May 2025

Location: 5140 Yonge Street, Toronto, ON

Experience: No formal experience required

Education: Currently enrolled in an Internship program completing their 3rd or 4th year specializing in Business, Finance, Computer Science, or Engineering with the intention to return to school the following year.

***As this position involves work that is subject to the Canadian Government's Controlled Goods Program (CGP), your employment offer is conditional upon the successful completion of a security assessment by Celestica and/or its authorized agents, per the Controlled Goods Regulations.

To apply, please visit www.celestica.com. Please provide a copy of your transcript with your application. Please include your student email address in your application.

Celestica is an equal opportunity employer. All qualified applicants will receive consideration for employment and will not be discriminated against on any protected status (including race, religion, national origin, gender, sexual orientation, age, marital status, veteran or disability status or other characteristics protected by law).

At Celestica we are committed to fostering an inclusive, accessible environment, where all employees and customers feel valued, respected and supported. Accommodations are available upon request for candidates throughout the hiring process. If you require an accommodation, we will work with you to meet your needs.

This position involves technologies regulated by the Canadian government's Controlled Goods Program (CGP). Candidates must be Canadian citizens or permanent residents of Canada and meet all other requirements under CGP. Job offers will be conditional upon candidates undergoing a successful security screening per the Controlled Goods Regulations.

Celestica would like to thank all applicants, however, only qualified applicants will be contacted.