Specialist, Material Costing and Awards

General Overview

Functional Area:  Supply Chain Management (SCM)
Career Stream:  Supply Chain Management (SCM)
Role:  Specialist (SPE)
Job Title:  Specialist, Material Costing and Awards
Job Code:  SPC-SCM-MCA
Job Level:  Level 08
Direct/Indirect Indicator:  Indirect

Summary

• Receive, process, negotiate & submit material cost solution for new business opportunities (bids & awards).
• Maintains global and/or regional responsibility for Cable Assembly or group of commodities for price/value determination, product and/or service negotiations, terms and conditions, supplier relationship development and performance. 
• Develops and executes a procurement strategy for commodity or services including competitive benchmarking, technology direction, supplier analysis, development, selection and pricing strategy.
• Provides guidance to less experienced Commodity Management staff. 
• Provides guidance to counterparts at the sites to ensure process compliance.
• Data Pipeline: Gather required data, organize and manage the data, clean and prepare for modelling.
• Data Analysis: Design, develop and deploy Machine Learning Models for consumption by Business users.
• Story Telling: Develop dashboards and recurring reports to translate data & information into insight.
• Updates material prices database, analyze bill of materials for competitiveness and customer compliance, review with management. 

Detailed Description

• Responsible for all product or service sourcing. 
• Participates in the Customer Materials Commitment process through collection of materials pricing and Customer BOM analysis. 
• Conducts customer bids within the response time objectives. 
• Responsible for supplier performance reviews including performance reviews, business development and supplier awards programs. 
• Has frequent interaction and negotiation with senior executives of industry-leading multi-national companies. 
• Provides support to their internal customers.  
• Provides product cost support for products in assigned geographies. 
• Prepares bids including generation of BOM, cost analysis, negotiate with suppliers, and present bids to management.

Knowledge/Skills/Competencies

• Broad knowledge of the marketplace conditions for the area of specialization including industry pricing, technology and supply/demand trends.
• Working knowledge of Celestica’s global supply chain including strategic policies and objectives.
• Ability to consolidate, manipulate and analyze large quantities of data.
• Ability to handle multiple tasks while maintaining attention to detail and accuracy and working under tight time deadlines.
• Ability to evaluate, prioritize and problem solve a variety of tasks to ensure their timely and accurate completion.
• Ability to communicate effectively, both verbally and in writing, with a wide variety of internal and external customers.
• Proficient development and working knowledge of Power BI required
• Develop and manage Business Intelligence data, and strategies
• Mandarin proficiency is required as the candidate will engage with external customers from China

Typical Experience

• 5 – 7 years experience (aligned to position seniority) in purchasing, commodity or engineering environment
• Minimum 2 years’ experience with Machine Learning and the end-to-end modelling process of supervised learning problems with regression models with Python, R, or AutoML.
• Familiarity with visualization products such as PowerBI or Tableau.
• The ability to quickly familiarize yourself with new languages, tools, frameworks, and to stay informed on developments in ML techniques and technologies
• Strong knowledge of basic computer applications and the ability to learn and use multiple applications specific to this department including ERP and office systems.
• Strong knowledge of purchasing principles and procedures.
• Understanding of specific customer needs.
• Strong communication, negotiation and presentation skills.

Typical Education

• Bachelor’s degree in related field (Commerce or Engineering), or consideration of an equivalent combination of education and experience.
• Supply Chain Management designation would be an asset
• Business or Engineering related degree

Notes

This job description is not intended to be an exhaustive list of all duties and responsibilities of the position. Employees are held accountable for all duties of the job. Job duties and the % of time identified for any function are subject to change at any time.