JOB PURPOSE    

Under minimal supervision and utilizing Mary Kay Inc’s Business Systems, provides analytical support to one or more areas of Integrated Supply Chain’s Data Management department which is responsible for establishing and upholding company-wide protocols concerning the collection and use of data necessary for global supply chain operations. Using a moderate level of knowledge provides initial setup and implementation of master data including general item master information, branch relationships, bills of material, work center routings and global formula book and page data.  This information is required for proper supply chain systems functionality and is also centralized for collecting and maintaining all Mary Kay international market’s master data information.

ESSENTIAL DUTIES AND RESPONSIBILITIES     

1. Item Master Part Setup & Maintenance/BOMs

Creates and maintains Mary Kay Inc.’s supply chain systems data fields and tables that contain item attribute information for finished goods, components, bulk and raw materials. Responsible for implementing product data information and subsequent changes into the ERP system.  Interfaces frequently with numerous cross-functional supply chain and corporate departments regarding the item master data and uses established business rules to determine data validity.  Attends project meetings to learn about changes that may require modifications to product data and provides valuable input at the team level. Monitors the timeline of upcoming projects in Agile to track the upcoming activities and ensures data is gathered in a timely manner to complete by due date.

2. Routings/Specifications

Performs and analyzes tasks associated with creating and managing work center routings as assigned by project.  Information may include scrap rates, yield, line speed, crew size, etc. Analyze requirements for new products and create finished good specifications to support the production execution of the product. Action specification modification requests for existing finished goods or bulk items to determine the scope of change to the product, create a plan of action and provides direction to manage the change process, and follow-up to ensure changes are made in a coordinated and timely fashion. This analysis provides the framework for finished goods and sub-assembly specifications utilized for product production and quality inspection globally.         

3. MRP

Having a full understanding of forecast, BOM setup, routings, stock types, planning families and planning codes, performs Material Requirements Planning (MRP) modeling cycles to ensure proper data set up and ERP signals are posting and addresses integrity reporting issues to verify data accuracy. Ensures data from R&D branch plant is set up correctly in the production environment by reviewing MRP detailed messages and providing direction to resolve discrepancies that exist.

4. Ensures data integrity in Mary Kay Inc’s supply chain systems. Provides direction in data management, governance, and data quality of master data requirements to other functional data owners. Develops and utilizes various reporting tools that accurately track key indices regarding workload, project status, audit reports, international support and turnaround time. Obtains necessary information from subsidiaries and domestic departments as required. Ensures all documentation for the Data Management department is regularly maintained for accuracy and up to date business rules. Prepares and participates in special projects to optimize business processes.

5. International Part Requests, International BOM Requests, International JDE Implementation & Support

Provides key support and analysis due to the centralization of master data for Mary Kay subsidiaries.  As requested, proactively assigns international-specific item numbers and bills of material where required. Under minimal supervision, is responsible for cross-departmental support of Mary Kay Business Systems international implementation and upgrades.