Student Intern, Data Warehouse Developer

Job title: Student Intern, Data Warehouse Developer

Company: Celestica

Job description: Req ID: 123084
Remote Position: Hybrid
Region: Americas
Country: Canada
State/Province: Ontario
City: Toronto16 Month InternshipCelestica (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 TechnologyStart Date: May 2025Location: 5140 Yonge Street, Toronto, ONExperience: No formal experience is requiredNumber of positions: 1Education: 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.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. Special arrangements can be made for candidates who need it throughout the hiring process. Please indicate your needs and we will work with you to meet them.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.

Expected salary:

Location: Toronto, ON

Job date: Sat, 28 Sep 2024 07:30:09 GMT

Apply for the job now!