Student Intern, Data Warehouse Developer

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:

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 SAP Business Objects, PowerBI, SAP BW4HANA, etc. Solutions developed need to adhere to internal Architecture and Security standards.
 

Preferred Skills:

• Strong written and verbal communication skills
• Ability to work independently as well as a team environment
• Data modeling knowledge (asset)
• Basic Oracle database knowledge (asset)
• Writing Oracle SQL (asset)
• SAP BusinessObjects (asset)
• PowerBI (asset)
• SAP BW4Hana (asset)

Activities: 

• Involvement with design/development/support of new and existing applications/reporting in SAP BusinessObjects and SAP BW4HANA.
• Working closely with the team and internal customers for support and development of applications/reporting.
• Assist in the gathering of requirements - 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.
• Coaching and providing knowledge transfer to new interns.

Additional Details:

Area: Information Technology

Start Date: May 2025

Location: 5140 Yonge Street, Toronto, ON

Experience: No formal experience is required

Number of positions: 1

Education: Currently enrolled in a University Internship program. Preference to those completing 3rd year of a 4-year program. Enrolled in Computer Science, Computer Engineering or Software Engineering.

To apply, please visit www.celestica.com. Please provide a copy of your transcript with your application.