Job Description

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.

Qualifications

Travel Requirements

• Approximately 5 - 10 %.
• Must be willing and available to travel to such locations and with such frequency as is necessary and desirable to meet business needs.

Work Environment Requirements

With reasonable accommodation:

• Must be able to operate a personal computer, telephone, and other office equipment.
• Must perform job duties onsite, when necessary, except those duties that are customarily or by their nature performed offsite (for example, offsite customer visits).
• Must be able to work effectively in a fast-paced environment.
• Must be able to work on multiple assignments at once, and complete assignments within deadline and budget (if applicable) with satisfactory quality.
• Must be able to operate as an effective team member.
• Must be committed to a high standard of safety and be willing and able to comply with all safety laws and all company safety policies.

Attendance/Work Hour Requirements

• Must maintain an acceptable attendance record.
• Must be willing and available to work weekends and holidays as necessary and desirable to meet business needs.