SUPPLY CHAIN DATA ANALYST II

QUALIFICATIONS:

BS IE, BS OPERATIONS MANAGEMENT, BSBA in Supply Chain, Purchasing or other Engineering/Management related disciplineAt least 2.5 years combined related experience in Buying, Planning, Supply Chain, Logistics and data mining, manipulation, analysis and reporting of supply chain dataBasic understanding of MRP, ERP and SRM systems and toolsFamiliarity with basic commoditiesAble to read, analyze & interpret various data types in Excel, Outlook or PDF formatsHas experience in analyzing data in different formats and finding commonalities or discrepanciesCan understand/interpret technical documents such as product datasheets & price lists, manuals, catalogsGood working knowledge on data interpretation & business processesKnowledge in supply chain, buying, planning functionsAble to perform ad hoc and project-spend analysis and reportsIntermediate 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 EnglishCan provide data in an efficient and understandable mannerUses Oracle or other similar applications for data entryCapable of simultaneously using various systems/tools to complete requestswork location: SM Cyberwest (across SM North Edsa)work setup: hybrid (2x/week onsite)work schedule: Midshift

DUTIES AND RESPONSIBILITIES:

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 database using tables and intermediate queries (MS Access)Communicates with resource person to get input/raw data needed for report generationPerforms 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

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 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 systemValidates, encodes changes related to the system (e.g. part number, collection plan) and completes the setup based on agreed turn-around-timeTroubleshoots 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 systemCreates, develops or updates work instruction for standard processes or activities.Identifies continuous improvement project ideas.

e-Sourcing

Coordinates and routes information and updates to POC and suppliers through meetings (calls) and e-malCollects, 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 suppliersProvides bid summary reportFacilitates the online bid awardCreates, develops or updates work instruction for standard processes or activities.Identifies continuous improvement project ideas

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 formulasCollects and uploads legacy contracts in ECMEncodes pricing agreement using standard template (e.g. LOI, PAS, Supplier Schedule A)Creates or revise contract using ECM (e.g. MBUSA, BUSA, MSA, SA, PC).Routes and coordinates contract approval and revision updates between commodity managers and legal department.Communicates new pricing agreement with the supplier to the EMS siteDirects supplier to comply with pricing agreementCreates, develops or updates work instruction for standard processes or activities. Coordinates and routes information and updates to POC and suppliers through meetings (calls) and e-mailCollects, 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