MDM Analyst

Date: Dec 1, 2023

Location: Muntinlupa City, National Capital Region (NCR), PH, 1781

Company: W. R. Grace & Co.

Job Description

The MDM (Master Data Management) Specialist is responsible for creation, maintenance, and gatekeeping of Grace’ master data in the following domain: Material Master, Vendor, Customer, FICO, Vendor, Price and perform data analysis and reporting. He/She is also responsible in stakeholder management (internal/external), report generation, data analysis, driving continuous improvement and adoption of new in-scope migrated process.

Key Responsibilities (1 of 4)

Overall

  • Responsible in triaging MDM requests received in mailbox and Cherwell portal and ensuring that tickets are correctly classified and responded to in a timely manner.
  • Responsible in gate keeping master data integrity and accuracy by ensuring all requests and supporting documents relevant to the request are complete and thoroughly reviewed.
  • Approve change requests in SAP MDG created by other MDM Specialists
  • Engage with different stakeholders in the different MDM domains and provide support within the teams in Grace.
  • Support Internal Audit by executing the assigned control processes for each master data domain.
  • Support the MDM supervisor in the preparation of the monthly scorecard by consolidating the data from different sources.
  • Ensure all requests are completed meeting the MDM KPI/SLAs and Quality standards for both day-to-day tasks and special projects.
  • Coordinate with the master data stewards and execute mass data load as directed by the business.
  • Prepare data download and provide reports as requested by GBS Manila and regional business partners.
  • Prepare and submit the Rebilling Report for the GBS Manila site.
  • Identify operational efficiencies, recommend improvements, and maintain a continuous improvement culture for the process.
  • Support the GPO and Strategy and Execution with completion and monitoring of MDM continuous improvement and new in-scope process migration.
  • Collaborate with other teams within the Global Operations to support process streamlining especially those interconnected processes with other teams.

Key Responsibilities (2 of 4)

Overall (continued)

  • Conduct process training to internal / external stakeholders (category managers, product managers) as applicable.
  • Conduct or participate in cross training with other team members to ensure centralization of knowledge in all domains are maintained.
  • Perform ad hoc data analysis and ensuring work instructions are regularly updated.
  • Develop a strong working relationship with peers and partners (Product Managers, Customer Service, Compliance, Internal and External Auditors) without diminishing the effectiveness of the controls.
  • Provide back-up support for the other MDM Specialist’s tasks as needed. 

 

Material Master Data

  • Responsible in processing requests for creation and change of material master data via SAP MDG, Bill of Materials and Routing/Recipe information and ensuring correct direct material costs are maintained.
  • Ensure complete information is provided by the Product Managers in the Material Information Form.
  • Creates production version and product cost collector for production plants.
  • Create cost object and packing instructions for specified plants.
  • Support the Annual DMC process by coordinating closely with the Plant Controllers and Cost Accounting Teams.
  • Creates the change master number annually.
  • Ensures that the Material Information Form is up to date and is published in various Grace Channels.

Key Responsibilities (3 of 4)

Vendor and Customer Master Data

  • Support the Global Supply Chain project by providing analysis on master data duplicates and inconsistencies. 
  • Ensure valid supporting documents are being provided by the requesters prior to creation or change of vendor and customer master data.
  • Provide analysis and regularly prepare the Inactive Vendor Report to be coordinated with the Global Procurement Team.
  • Assess and approve Ariba Vendor Information for Supplier onboarding.
  • Monitor vendor master workflows (critical changes, payment terms update, vendor blocking)
  • Perform Vendor and Customer validation calls for critical field changes.
  • Work closely with the Order Fulfillment Team, analyze and perform Customer master data cleansing.
  • Perform mass customer partner function changes and address updates.

Key Responsibilities (4 of 4)

FICO Master Data

  • Create, change FICO objects (Profit Center, Cost Center, G/L accounts) via SAP MDG.
  • Updates the monthly FOREX rates and annual budget rates into the SAP and Intranet/Blackline systems based on the information provided by the Treasury team.
  • Prepare the weekly cost center creation and change report to the Finance Team.

 

Pricing Master Data

  • Create, change and delete pricing conditions based on the instructions of the regional sales team.
  • Coordinate with Order Fulfilment Team for any discrepancies on the price exception request form provided.
  • Ensure approvals are provided by the Regional Sales Lead prior to performing changes to pricing conditions.

Required Experience

  • Background and exposure in master data entities in SAP ECC, particularly in MM, FICO, SD, PP modules.
  • Experience in ticketing system (CW, Service now)
  • Minimum 5 years work experience related to SAP master data management – in the areas of Customer, Vendor, FICO (Bank, Cost Center, Profit Center, and GL) and Pricing Data. Knowledge in Material Master Data (including BOM, routing/recipe & DMC maintenance) preferred.
  • Experience in SAP Master Data Governance & SAP Ariba preferred, but not required.
  • Process knowledge in the areas of Supply Chain, Material Management, and FICO
  • Proficient in MS applications such as Excel, Word, PowerPoint, and Visio.

Preferred Competency and Personal Traits

  • Results oriented; proactive and can work with minimal supervision.
  • Excellent communication skills.
  • Detail oriented and demonstrates ability to consistently meet tight deadlines and manage multiple projects simultaneously.
  • Strong interpersonal skills-ability to communicate to all levels in the organization and across functions.

Educational Level

  • Bachelor’s Degree – preferably Accounting, Management, or Engineering
  • Six sigma trained/certified preferred, but not required.