Purchasing Data Management Analyst

aisincareers; Northville (MI); On-site; USD 85,000 - 115,000; Full time

Job summary

AISIN World Corp. of America is seeking a Purchasing Data Management Specialist (Raw Material & MRO Support) in Northville, MI.

You will design, implement, and maintain data systems to support AISIN's CPS for Raw Material and MRO data across North American plants. Responsibilities include building data tables for supplier mapping, automating data imports from ERP and plant files, and ensuring data integrity through normalization.

Qualifications

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

Responsibilities

• Develop, structure, and maintain data management systems to support the CPS for Raw Material and to integrate MRO data across AISIN NA plants.
• Design data tables to map Raw Material grades to Tier-2 suppliers under the CPS program.
• Build a centralized MRO data management structure with unified part numbering.
• Develop automated data import processes from ERP systems, plant spreadsheets, and supplier data files.
• Establish data normalization and cross-reference logic to ensure data integrity.

Skills

Data system design

Data integration

SQL/Access

Cross-functional collaboration

Excel proficiency

Power BI familiarity

Education

Bachelors in Data Management, CS, or related

Tools

Power BI

Power Query

Access

SQL & relational databases

Job description

Job Title: PurchasingData 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.