Analyst 2, Supply Chain

Analyst 2, Supply Chain Requisition ID: (19010778) Primary Location: Philippines-National Capital Region-Quezon City
Job Function: Supply Chain & Logistics
Job Posting Date: Aug 22, 2019, 8:50:26 AM

Description
Major responsibilities of a Supply Chain Analyst 2 supporting Strategic Sourcing are as follows:Develops and assist in the execution of eRFI’s, eRFP’s, and eAuctions and evaluating supplier proposals and responses; Performs spend analysis to identify opportunities for cost improvement and value delivery; Prepares KPI reports , CTPAT, Contract Management and process documentation; Maintains databases and procurement tools; Gather data in order to perform comparative analysis for a specific commodity and/or supplier for identifying and implementing value add activities such as cost reductions, innovation, risk management, etc. within the supply chain base.
ResponsibilitiesDuty 1: Metrics, Reporting and Analytics
Extracts/generates quantitative information from databases using intermediate coding (e.g. tables, basic queries) Ex. Spend and On Time delivery. Combines extracted data from different system tools in one single database using tables and intermediate queries (MS Access).
Communicates with resource person to get input/raw data needed for report generation ? Performs data validation to achieve data consistency.
Calculates data using available fields within the gathered information. (basic math).
Analyzes the data and provides in depth interpretation and recommendation based on findings (e.g. price parity, DPO Parity, KPI metrics) thru comparative analysis (e.g. comparing actuals vs historical information).
Creates supply chain related reports based on standard templates using multiple sources (financial exhibits, etc.).
Creates, develops or updates work instruction for standard processes or activities.
Identifies continuous improvement project ideas.
Conducts basic/overview/ awareness training on product, process and ERP/business tools, including on-boarding and/or new user training.
Duty 2: System Support and Maintenance
Extracts/generates quantitative information from databases using intermediate coding (e.g. tables, basic queries) Ex. Spend and On Time delivery. Combines extracted data from different system tools in one single database using tables and intermediate queries (MS Access).
Maintains the business system and track changes in data to ensure data integrity (ex parts analysis, IM administration and other business system tools).
Modifies and tests data load script to automatically upload data to the system.
Validates, encodes changes related to the system (e.g. part number, collection plan) and completes the setup based on agreed turn-around-time.
Troubleshoots basic technical errors (e.g. no spend, MIN spend vs IM spend, undefined characters, pass/fail option of collection is not working).
Collaborate and communicate with suppliers, get commercial information (e.g. transfer price, lead time) or other related information needed to update the system.
Creates, develops or updates work instruction for standard processes or activities.
Identifies continuous improvement project ideas.
Duty 3: eSourcing
Coordinates and routes information and updates to POC and suppliers through meetings (calls) and e-mail.
Collects, analyzes, reviews and ensures accurateness of all commercial and engineering (drawings and specification) data that will be used in the eSourcing event.
Prepare documentation (e.g. opportunity overview, RFQ, supplier agreement, cost breakdown file) for the eSourcing event.
Handles the parameter set-up and execution of an eSourcing event.
Responds to basic (e.g. event parameters) issues or concerns by providing recommendation and solution.
Responds to complex (e.g. engineering, commercial) issues or concerns by providing recommendation and solution.
Conducts eSourcing training to suppliers.
Provides bid summary report.
Facilitates the online bid award.
Creates, develops or updates work instruction for standard processes or activities.
Identifies continuous improvement project ideas.Duty 4: Contract Management
Gathers data from various data sources (e.g. cost breakdown, Schedule, POC, parts, price list, T&C).
Validates the correctness and completeness of the data by performing clean-up, normalization, formatting using MS excel formulas.
Collects and uploads legacy contracts in Oracle.
Encodes pricing agreement using standard template (e.g. LOI, PAS, Supplier Schedule A).
Creates or revise contract using Oracle.
Routes and coordinates contract approval and revision updates between commodity managers and legal department.
Communicates new pricing agreement with the supplier to the EMS site.
Directs supplier to comply with pricing agreement.
Creates, develops or updates work instruction for standard processes or activities.
Requirements
Education: BS IE, BS OPERATIONS MANAGEMENT, BSBA in Supply Chain, Purchasing or other Engineering/Management related discipline.

Job Related Experience: At least 2.5 years combined related experience in Buying, Planning, Supply Chain, Logistics and data mining, manipulation, analysis and reporting of supply chain data.
Specific Knowledge
Basic understanding of MRP, ERP and SRM systems and tools.
Familiarity with basic commodities.
Able to read, analyze & interpret various data types in Excel, Outlook or PDF formats.
Has experience in analyzing data in different formats and finding commonalities or discrepancies.
Can understand/interpret technical documents such as product datasheets & price lists, manuals, catalogs.
Good working knowledge on data interpretation & business processes.
Knowledge in supply chain, buying, planning functions.
Able to perform ad hoc and project-spend analysis and reports.

Skills:
Intermediate Microsoft Excel proficiency (Level 2).
Proficient in other Microsoft office programs: Power Point, Word, Outlook.
Good level communication skills for interacting with technical & non-technical people via email or phone correspondence in fluent English.
Can provide data in an efficient and understandable manner.
Uses Oracle or other similar applications for data entry.
Capable of simultaneously using various systems/tools to complete requests.

About EmersonAt Emerson, we are innovators and problem-solvers, focused on a common purpose: leaving our world in a better place than we found it. Each and every day, our foundational values—integrity, safety and quality, supporting our people, customer focus, continuous improvement, collaboration and innovation—inform every decision we make and empower our employees to keep reaching higher.As a global technology and engineering leader, we provide groundbreaking solutions for customers in industrial, commercial, and residential markets.Our Automation Solutions business helps process, hybrid, and discrete manufacturers maximize production and protect personnel and the environment while optimizing their energy and operating costs. Our Commercial & Residential Solutions business helps ensure human comfort and health, protect food quality and safety, advance energy efficiency and create sustainable infrastructure.Emerson, a Fortune 500 company with $17.4 billion in sales, more than 20 Innovation, Solutions & Engineering Centers, and 200 manufacturing locations worldwide, is committed to helping employees grow and thrive throughout their careers.Whether you're an established professional looking for a career change, an undergraduate student exploring options or a recent MBA graduate, you'll find a variety of opportunities at Emerson. Join our team and start your journey today.