Job Information
Celestica Student Intern, Data Analyst & Quote Controller in Toronto, Ontario
Req ID: 122915
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 Indirect Procurement team is responsible for ensuring that products and services purchased are provided with the best value and quality for what is required. They are responsible for developing contracts, managing the vendor selection process, monitoring spending and driving policy compliance for audits. The team is split into different spend categories (e.g. Equipment, IT, Facilities) with dedicated Category Managers who manage them. This team is highly energized and is successfully driven by their team approach and customer focus attitude.
The data analyst portion of the role is to drive understanding around the Global Spend and Savings for the company with respect to indirect products and services. These analytics helps to ensure the company runs successfully. The opportunity allows for global data trend analysis across a number of business functions around the globe. The data is reported to various senior leaders and executives in the company.
The quote controller portion of the role acts as the Indirect Procurement “Request for Quote/Information” (RFX) focal point between external and internal stakeholders. You are the communication engine of the department.
This role combines data analytics with business savvy communication development opportunities. This individual should be self-driven, have interest in continuous improvement and a willingness to support their team. Students will have the opportunity to work in the Corporate Supply Chain and develop skills in supply chain/commodity business practices, communications, analytics, as well as advanced proficiency in various Microsoft products, project management and Global interaction experience.
Students will enjoy a stimulating and challenging work environment with opportunities to develop many skills, while working in a highly motivated team. This position is ideal for students that are currently enrolled in 3rd or 4th year from Computer Science, Data Science, Statistics, Commerce/Finance, or Social Sciences.
Preferred Skills
A self starter with the ability to pull in knowledge of different tools to solve unique and complex problems
Data Visualization
A team player with strong communication and interpersonal skills
Excellent PC skills (database software and major desktop applications)
Proficient in Microsoft Word, PowerPoint and Excel (analysis, pivot tables & vlookup)
Familiar with Google applications including Google Drive, Mail, Calendar etc.
Excellent time management and prioritization
Ability to meet tight deadlines in a fast-paced environment
Ability to work autonomously once trained
Excellent analytical and problem-solving skills
Flexibility to work extended hours as per customer needs
Inquisitive and detailed oriented (comfortable asking questions)
Ability to learn and quickly develop new skills
Nice to Have Skills:
Has worked with either Python/R
Experience in SQL
Experience in Power BI
Knowledge of manufacturing, procurement and electronics industry
Some education and/or experience in the finance or accounting field
Activities
Create and Manage Dashboards based on Executive and Regional Needs
Automate and manage existing workflows with Python and PowerApps
Updating and Maintaining Databases in Azure and other Software.
Compile, analyze and reporting of indirect procurement data
Create and present a Monthly Operating Report
Assist Commodity Managers with spend analysis and the categorization of key spend area
Perform routine reporting tasks that involve spend, performance reports and invoice analysis
Send out RFX packages, manage proposals, timelines, questions & answers related to RFQs
Setting up NDA documents with potential vendors
Develop vendor comparison charts (price, capabilities)
Set up site visits and vendor meetings
Participate to volunteering activities within Celestica volunteer programs
Physical Demands
Duties of this position are performed in a normal office with exposure to manufacturing environments.
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, using a calculator, etc.).
Additional Details
Area: Global Supply Chain Management – Global Indirect Procurement
Start Date: May 2024
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 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.
Celestica
- Celestica Jobs