Jobs · Information Technology · Michigan

Purchasing Data Management Specialist

AW Technical Center USA · Northville, MI · 3 mo ago
Information TechnologyFull-time

Position Responsibilities

The incumbent is expected to perform the following functions that the company has determined are essential to this position:

  • Data Management Creation and Maintenance
  • Design data tables to map raw material grades to select Tier-2 suppliers under the AISIN CPS program.
  • Build a centralized MRO data management structure, consolidating items by manufacturer numbers and plant-specific details, progressing toward unified AISIN MRO part numbering by sub-commodity type.
  • Develop automated data import processes to merge information from ERP systems, plant spreadsheets, and supplier data files.
  • Establish data normalization and cross-reference logic to ensure high data integrity and eliminate redundancy.
  • System Integration and Process Automation
  • Collaborate with Purchasing, Finance, and Engineering to connect the data management system with existing cost-tracking, RFQ, and tariff-management workflows.
  • Define version control and revision history methods for supplier and part information.
  • Automate data validation (duplicate checks, completeness verification, and formatting consistency).
  • Strategic Data Management Development
  • Define data architecture and indexing strategies for efficient search and reporting across multi-plant data sets.
  • Establish data governance: user access standards, backup routines, and security controls.
  • Work with Purchasing, Material Engineering, Design, and Plants to maintain structured update processes and data ownership.
  • Support development of cost benchmarking and predictive analysis capabilities.
  • Collaboration & Continuous Improvement
  • Support Raw Material, MRO, and Commodity Teams with data insights for supplier mapping, cost reduction, and risk assessment.
  • Create clear documentation (data dictionary, process flows).
  • Participate in cross-functional workshops to improve reporting usability.
  • Train users on data entry, search, reporting, and interpretation.

Required Skills and Abilities

  • Essential Skills and Experience: 2-5 years of experience in data system design and integration.
  • Strong understanding of relational data structures (SQL, Access, or similar).
  • Experience consolidating data from ERP or plant-level systems.
  • Strong analytical ability and attention to data integrity.
  • Ability to work cross-functionally with Purchasing, Finance, and Engineering.
  • Advanced proficiency in Excel and data tools (Power Query, Access; Power BI a plus).

Beneficial Skills and Experience

  • Experience in automotive manufacturing or supply chain.
  • Familiarity with cloud-based data environments.
  • Knowledge of data governance and master-data management concepts.
  • Experience working with Japanese-based organizations is a plus.

Education/Training/Certifications

  • Bachelor’s degree in data management, Computer Science, or related field.

Similar jobs