Associate (MIS)

Williams-Sonoma, Inc.; Gurugram District; On-site; INR 700,000 - 900,000; Full time

Job summary

Williams-Sonoma, Inc. is seeking a Procurement Operations specialist to consolidate SKU-level vendor costing, manage pricing revisions, and reconcile data across PLM and costing tools. This role emphasizes data accuracy, audit trails, and timely MIS reporting.

The candidate should have 3+ years in sourcing/procurement operations, strong Excel and Power BI skills; PLM familiarity is a plus. You will drive cost controls, validation of data, and improvements to trackers and reporting, reducing

Qualifications

• 3+ years in sourcing/procurement operations, costing, product data, MIS, or vendor management.
• PLM experience and SKU/product lifecycle understanding.
• Advanced Excel skills and data validation.
• Strong analytical ability and attention to detail.
• Power BI knowledge is an advantage.

Responsibilities

• Consolidate and maintain SKU-level vendor costing.
• Manage vendor pricing revisions, negotiated discounts, and approved cost changes.
• Update and reconcile data across PLM, costing tools.
• Validate data for missing SKUs, duplicates, incorrect costs, and unusual price movements.
• Maintain strong version control, data accuracy, and audit trail.
• Prepare costing MIS, exception reports, and management updates.
• Improve and automate trackers and reporting processes to reduce manual effort.

Skills

Advanced Excel (XLOOKUP, VLOOKUP,Pivot

Power BI

Analytical thinking

Stakeholder coordination

Tools

PLM

Power Query

Excel

Job description

• Consolidate and maintain SKU-level vendor costing.
• Manage vendor pricing revisions, negotiated discounts, and approved cost changes.
• Update and reconcile data across PLM, costing tools.
• Validate data for missing SKUs, duplicates, incorrect costs, and unusual price movements.
• Maintain strong version control, data accuracy, and audit trail.
• Prepare costing MIS, exception reports, and management updates.
• Improve and automate trackers and reporting processes to reduce manual effort.

Key Responsibilities

• Consolidate and maintain SKU-level vendor costing.
• Manage vendor pricing revisions, negotiated discounts, and approved cost changes.
• Update and reconcile data across PLM, costing tools.
• Validate data for missing SKUs, duplicates, incorrect costs, and unusual price movements.
• Maintain strong version control, data accuracy, and audit trail.
• Prepare costing MIS, exception reports, and management updates.
• Improve and automate trackers and reporting processes to reduce manual effort.

JOB DESCRIPTION

• Consolidate and maintain SKU-level vendor costing.
• Manage vendor pricing revisions, negotiated discounts, and approved cost changes.
• Update and reconcile data across PLM, costing tools.
• Validate data for missing SKUs, duplicates, incorrect costs, and unusual price movements.
• Maintain strong version control, data accuracy, and audit trail.
• Prepare costing MIS, exception reports, and management updates.
• Improve and automate trackers and reporting processes to reduce manual effort.

Candidate Profile

• 3+ years in sourcing/procurement operations, costing, product data, MIS, or vendor management.
• Preferrable PLM experience and understanding of SKU/product lifecycle.
• Advanced Excel skills XLOOKUP/VLOOKUP, Pivot Tables, SUMIFS/COUNTIFS and data validation.
• Strong analytical ability, attention to detail, ownership, and stakeholder coordination.
• Power Query / Power BI knowledge is an advantage.

Success Measures

• High accuracy of SKU and costing data.
• Timely vendor pricing consolidation and PLM updates.
• Minimal data discrepancies and pending exceptions.
• Reliable sourcing trackers and MIS.
• Improved process efficiency and reduced manual errors.

Hiring Manager

https://www.linkedin.com/in/puneethrprofessional