Analyst_Sourcing & Procurement

Perform detailed analysis on Component Inventory against the Demand, On-Hand Open Order Qtys

• Use advanced data analytics tools like Power BI or Tableau to visualize inventory data.
• Implement predictive analytics to forecast demand more accurately.

Automate the input data consolidation from different Contract Manufacturers

• Use ETL (Extract, Transform, Load) tools like Alteryx or Talend to automate data consolidation.
• Implement APIs to directly pull data from manufacturers systems.

Prepare and submit a monthly STD cost file to finance as per the corporate calendar timelines

• Create a standardized template and automate data entry using Excel macros or Python scripts.
• Set up reminders and workflows in project management tool to ensure timely submission.

Work as a program manager by driving component Qualification process working with cross functional teams to get the Qualification completed on time to achieve planned cost savings

• Use project management software like Jira to track progress and deadlines.
• Regularly hold cross-functional team meetings to ensure alignment and address any roadblocks.

Finalize the quarterly CBOM (Costed Bill of Materials) and Quote files from all contract manufacturers by following the CBOM calendar timelines

• Implement a centralized database to store and manage CBOM data.
• Use version control systems to track changes and ensure accuracy.

Managing Claims management process with Contract Manufacturers and Suppliers

• Develop a standardized claims validation process and effectively track manage claims.
• Regularly review and update the claims process to improve efficiency.

Do market research on new processes Best Practices on procurement and see how it can be leveraged in the existing process

Perform and maintain detailed analysis on Supplier risk assessment with the help of 3rd party vendors

• Regularly review and update risk assessment criteria based on changing market conditions.

Compile and perform Supplier pricing trend analysis to support Commodity Managers for their QBRs

• Create dashboards in BI tools to visualize pricing trends and support decision-making.

Work closely with Commodity Managers and identify the Potential or NPI Suppliers to be evaluated for risk assessments

• Maintain a database of potential suppliers and their risk assessment results.

Maintain Manage Item master pricing list by refreshing the data on regular intervals without any errors

• Use data validation techniques and automated scripts to ensure data accuracy.
• Implement a regular review process to update and verify pricing data.

Who you are and what you bring:

• Any Bachelors degree, preferred in Engineering, with minimum 5+ years of experience in

  Supply Chain Analytics

  .
• Should have very good Analytical Problem-Solving skills.
• Should have hands on experience on excel based Automations, using MS Power Query, Excel VBA Gen AI.
• Should be open minded and should take ownership.
• Should have strong Verbal Communication and Presentation skills.
• Strong professional relationship management with internal and external interfaces.
• Strong interpersonal skills with proven ability to communicate effectively both verbally and in writing with internal customers and suppliers.
• Ability to perform effectively and independently in a virtual environment.
• Ability to effectively manage job responsibilities with minimal supervision