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

Apply now »

Date: Sep 27, 2024

Location: Toronto, ON, CA

Company: Celestica International Inc.

​Req ID: 122845 
Remote Position: Hybrid
Region: Americas 
Country: Canada 
State/Province: Ontario 
City:  Toronto 

16 Month Internship

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:

The Smart Energy - Pricing Management and Product Data Analysis Intern will work on the engineering manufacturing team to resolve quality issues and fix any quality issues. Work is guided by detailed instructions, routines, and procedures. In the first 3 months, the intern will work under close supervision and receive detailed instructions on all work assignments. Once proficiency in the tasks is achieved, the intern will work autonomously and be given more complex duties. The intern will also have the opportunity to work with colleagues and suppliers around the globe, gaining international experience.

 

Preferred Skills:

  • Advanced proficiency in MS Office (ex. Microsoft Excel functions such as VLOOKUP, PIVOT tables, Indexing, and data analysis).
  • Strong analytical skills.
  • Strong organizational skills.
  • Strong communication skills.
  • Project management experience.
  • 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 varied and will include:

  • 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).

Additional Details:

 

Area:   Global Supply Chain Services

 

Start Date: May 2025

 

Location: 5140 Yonge Street, Toronto, ON

 

Vacancies: 1 position

 

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.


Celestica does not accept unsolicited resumes from recruitment agencies or fee based recruitment services.


Job Segment: Supply Chain, Database, Supply, Data Entry, Pricing, Operations, Technology, Administrative

Apply now »