Share this Job

Student Intern, Data Warehousing (2 Positions)

Apply now »

Date: Mar 18, 2019

Location: Toronto, CA

Company: Celestica International Inc.

Req ID: 40645 
Region: Americas 
Country: Canada 
State/Province: Ontario 
City:  Toronto 

16-Month Internship


When you join Celestica, it's more than just a job. It's about being part of a team of uniquely talented and forward-thinking individuals who are passionate about what they do. It’s about joining a leading global company that enables the world’s best brands, and contributing to our innovative and collaborative solutions that help our customers unlock the potential of the future.


Celestica (NYSE, TSX: CLS) is a US$6 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, semiconductor capital equipment, and smart energy to deliver solutions for their most complex challenges.


Our global network spans 13 countries with 27,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 throughout Southern Ontario. 


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 on-call 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
  • Discounted GoodLife Fitness memberships


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: Our students have the opportunity to network and develop lasting relationships with the intern community and their team members
  • 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:


This position is ideal for a person with a passion for Data Warehousing and the associated visualization and reporting of the data. You will help transform Business requirements into SQL Code running on an Oracle 11g database. Here the standard Software Development Life Cycle is followed with Requirements elicitation, Analysis, Design, Code, Test and Deployment. There’s also an element of Integration involved here as you will help bring data from disparate systems into a centralized Data Warehouse. Once in the Warehouse, the data needs to be surfaced to the Business user via Dashboards and Reports using technologies such as Sisense and SAP Business Objects. Solutions developed need to adhere to internal Architecture and Security standards.


Preferred Skills:

  • Currently enrolled in a Computer Science or Computer Engineering program
  • Have completed the 3rd year in school
  • Good written and verbal communication skills
  • Ability to work independently as well as team environment
  • Data modeling knowledge (optional)
  • Basic Oracle database knowledge (optional)
  • Writing Oracle sql (optional)
  • Java, .Net, Analytics and Cloud computing (optional)
  • SAP BusinessObjects and Sisense (optional)



  • Involvement with design/development/support of new and existing applications.
  • Working closely with Celestica's outsource partner(s) for support/development of applications.
  • Assist in the gathering of requirements for new web applications- includes collecting and analyzing existing documentation, reviewing with Subject Matter Experts & writing specification documents.
  • Perform routine management/reporting tasks as they relate to the portfolio of applications.
  • Interact with broader team involved in Java, .NET, Analytics and Cloud computing.


Area: Information Technology


Start Date: May 2019


Location: 5140 Yonge Street, Toronto


Experience: No formal experience required.


Education: Currently enrolled in a University Internship program. Preference to those completing 3rd year of a 4-year program.


To apply, please visit


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

Celestica (NYSE, TSX: CLS) is a US$5.6 billion global leader in the delivery of end-to-end product lifecycle solutions. Our customers trust us to deliver the most advanced design, engineering and manufacturing expertise for their highly sophisticated and complex products. From advanced medical devices, to highly engineered aviation systems, to next-generation hardware solutions for the Cloud, at Celestica we manage the complexity for our customers and set the bar for quality and reliability in their markets. Our customer portfolio includes leaders in the enterprise computing, communications, aerospace and defense, industrial, smart energy, healthtech and semiconductor markets. Headquartered in Toronto, our global network spans 13 countries with 26,000 employees throughout the Americas, Europe and Asia.

Job Segment: Database, Data Warehouse, Oracle, ERP, Engineer, Technology, Engineering