erp item master data mapping analyst

erp item master data mapping analyst.

beloit , wisconsin (remote)

posted today

job details

summary

$65 – $75 per hour

contract

bachelor degree

category computer and mathematical occupations

reference1067213

job details

job summary:

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:

Lead the mapping of items (SKUs) from the legacy ERP system to the new ERP platform, ensuring accuracy and consistency in the data transition.

Responsible for the item mapping, setup & lifecycle management of item master data.

Utilize T-SQL to conduct data analysis, ensuring that item mapping aligns with business rules and requirements.

Work with business teams to understand and implement rules related to item mapping, supplier assignment, and product categorization.

Ensure seamless mapping and support of Unit of Measure (UOM), Bill of Materials (BOM), Kit items, and other product details.

Update critical item attributes, including BOL codes, manufacturer (MFR) names, and tax codes.

Provide hands-on support for the creation and maintenance of special-order items and ensure their accurate mapping during the ERP transition.

Collaborate with business stakeholders to maintain accurate item data using Stibo, the item Master Data Management (MDM) tool.

Provide overall support throughout the item creation, maintenance, and migration process, ensuring all items are transitioned properly from the old ERP system to the new one.

Preferred Qualifications:

Construction/Building Products Industry Experience: Familiarity with product catalogs and item management in industries related to construction, roofing, siding, windows, gutters, and building materials.

ERP Migration Experience: Previous experience in migrating item data from legacy ERP systems to new platforms is highly desirable.

Stibo MDM Experience: Deep understanding of Stibo or similar MDM tools for handling item creation, updates, and maintenance.

location: BELOIT, Wisconsin

job type: Contract

salary: $65 – 75 per hour

work hours: 8am to 5pm

education: Bachelors

responsibilities:

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.

Responsibilities:

Lead the mapping of items (SKUs) from the legacy ERP system to the new ERP platform, ensuring accuracy and consistency in the data transition.

Responsible for the item mapping, setup & lifecycle management of item master data.

Utilize T-SQL to conduct data analysis, ensuring that item mapping aligns with business rules and requirements.

Work with business teams to understand and implement rules related to item mapping, supplier assignment, and product categorization.

Ensure seamless mapping and support of Unit of Measure (UOM), Bill of Materials (BOM), Kit items, and other product details.

Update critical item attributes, including BOL codes, manufacturer (MFR) names, and tax codes.

Provide hands-on support for the creation and maintenance of special-order items and ensure their accurate mapping during the ERP transition.

Collaborate with business stakeholders to maintain accurate item data using Stibo, the item Master Data Management (MDM) tool.

Provide overall support throughout the item creation, maintenance, and migration process, ensuring all items are transitioned properly from the old ERP system to the new one.

qualifications:

Experience level: Experienced

Minimum 8 years of experience

Education: Bachelors

skills:

SQLEqual Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.Pay offered to a successful candidate will be based on several factors including the candidates education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).This posting is open for thirty (30) days.