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.
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.