ERP Item Master Data Mapping Analyst

Position : ERP Item Master Data Mapping Analyst

About Role :

We are embarking on a critical ERP migration and are seeking an experienced ERP Item Mapping Specialist. This role will focus on transitioning items from an old legacy ERP system, primarily used in POS, to our new ERP implementation. The ideal candidate will have expertise in SKU and item mapping within the construction and building industry, with a deep understanding of item management tools and data analysis using T-SQL in SQL Server.

Requirements :

• SKU & Item Mapping Expertise : Experience in SKU and item mapping, especially within the construction and building products industry.
• Data Analysis (T-SQL) : Strong proficiency in using T-SQL for data analysis, item mapping validation, and troubleshooting.
• Item MDM (Stibo) : Familiarity with Stibo or similar item Master Data Management tools for managing item lifecycles, especially during ERP transitions.
• UOM, BOM, and Kits Management : Experience in managing and mapping Unit of Measure (UOM), Bill of Materials (BOM), Kit items, and other product-specific details.
• Familiarity with Building Products : Understanding of building materials such as roofing, siding, windows, gutters, and more, including special order items.
• Item Attribute Updates : Hands-on experience updating BOL codes, MFR names, tax codes, and other critical item attributes during migration.
• Collaboration Skills : Strong communication skills to work closely with business teams, suppliers, and stakeholders to ensure accurate item mapping and data integrity.
• Xref Creation : Assist in creating cross-references (Xref) between old item codes and new item codes to ensure smooth data transition.
• ERP Inventory, Costing, and Pricing Modules : In-depth experience in inventory, costing, and pricing modules of ERP systems to support decision-making during item conversions.
• Product Categories Experience : Experience working with both minor and major product categories to handle item mapping effectively.
• O2C & P2P Cycles : Strong understanding of Order-to-Cash (O2C) and Procure-to-Pay (P2P) cycles to assist in converting open POs, open SOs, and other transactions from the legacy ERP to the new ERP.
• Data Analysis, Visualization & Critical Thinking : Excellent data analysis, data visualization, and critical thinking skills to support the item master team and ensure data accuracy and integrity throughout the conversion process.
• Relevant Experience : The ideal candidate should have at least 3-4 years of recent experience in a similar role, working on ERP migrations and item conversions.
• Ongoing Data Cleanup : Assist with ongoing data cleanup around item setup to ensure accurate data for conversions.
• Lead Discussions : Lead discussions around item-related requirements, mapping issues, and collaborate with integration teams, downstream applications, and third-party teams to support their needs regarding items.
• ERP Item Setup Expertise : Possess a strong understanding of item setup in ERP modules to ensure accurate data migration and system alignment.

Responsibilities :

Preferred Qualifications :

Required Skills : SQL

Basic Qualification :

Additional Skills : Big Data

This is a high PRIORITY requisition. This is a PROACTIVE requisition

Background Check : No

Drug Screen : No