Student Intern, Data Analyst & Quote Controller

Req ID: 122860
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. 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 in the company including the Chief Procurement Office (CPO).

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.

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 2025

Location: 5140 Yonge Street, Toronto

Vacancies: 1

Experience: No formal experience required.

Education: Currently enrolled in a University Internship program. Preference to those completing 3rd year of a 4 year program in a Computer Science, Data Science, or Business/Finance program.

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