Purchasing Data Management Analyst

Job Title: Purchasing Data Management Specialist (Raw Material & MRO Support)

Company: AISIN World Corp. of America

Department: Business Management, Purchasing - Materials & Machinery

Location: Northville, MI

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

• Develop, structure, and maintain data management systems to support AISIN Controlled Purchasing System (CPS) for Raw Material and to integrate MRO data across all AISIN North American plants.
• 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.
• Other tasks and duties as assigned.
  
  

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 in automotive manufacturing or supply chain.
• 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

• Familiarity with cloud-based data environments.
• Knowledge of data governance and master-data management concepts.
• Experience working with Japanese-based organizations.
  
  

Education/Training/Certifications

• Bachelor’s degree in Data Management, Computer Science, or related field.