Purchasing Data Management Analyst

AISIN World Corp. of America•Northville Charter Township, MI

1d•Onsite

About The Position

The Purchasing Data Management Specialist supports AISIN’s Controlled Purchasing System (CPS) for raw materials and integrates MRO data across AISIN North American plants. The role develops and maintains data structures, systems, and processes for supplier, material, and part information, including data consolidation, normalization, cross-referencing, validation, and automation. Working with Purchasing, Finance, Engineering, Material Engineering, Design, and plant teams, the position connects data systems with cost-tracking, RFQ, and tariff-management workflows; establishes data governance, version control, access, backup, and security practices; and supports cost benchmarking and predictive analysis. The role also provides data insights for supplier mapping, cost reduction, and risk assessment, documents processes, improves reporting usability, and trains users. The position is based in Northville, Michigan, with approximately 5–10% travel. Duties are generally performed onsite when necessary, with some duties customarily performed offsite. The employee must be able to work in a fast-paced environment, manage multiple assignments to deadlines, work effectively as a team member, and comply with safety requirements. Weekend and holiday work may be required as business needs warrant.

Requirements

2–5 years of experience in data system design and integration.
Strong understanding of relational data structures, such as 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 such as Power Query and Access.
Bachelor’s degree in Data Management, Computer Science, or a related field.
Must be able to operate a personal computer, telephone, and other office equipment.
Must be able to work effectively in a fast-paced environment, manage multiple assignments, and complete work within deadlines and budget (if applicable) with satisfactory quality.
Must be able to operate as an effective team member and comply with safety laws and company safety policies.
Must maintain an acceptable attendance record and be willing and available to work weekends and holidays as necessary to meet business needs.
Must be willing and available to travel as necessary and desirable to meet business needs.

Nice To Haves

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

Responsibilities

Develop, structure, and maintain data management systems supporting AISIN’s Controlled Purchasing System for raw materials and integrating MRO data across AISIN North American plants.
Design data tables mapping raw material grades to selected Tier-2 suppliers under the AISIN CPS program.
Build a centralized MRO data structure consolidating items by manufacturer number and plant-specific details, progressing toward unified AISIN MRO part numbering by sub-commodity type.
Develop automated data import processes that merge information from ERP systems, plant spreadsheets, and supplier data files.
Establish data normalization and cross-reference logic to maintain data integrity and eliminate redundancy.
Collaborate with Purchasing, Finance, and Engineering to connect data management systems with cost-tracking, RFQ, and tariff-management workflows.
Define version control and revision history methods for supplier and part information.
Automate data validation, including duplicate checks, completeness verification, and formatting consistency.
Define data architecture and indexing strategies for efficient search and reporting across multi-plant data sets.
Establish data governance practices, including 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 the development of cost benchmarking and predictive analysis capabilities.
Provide Raw Material, MRO, and Commodity Teams with data insights for supplier mapping, cost reduction, and risk assessment.
Create documentation such as data dictionaries and process flows.
Participate in cross-functional workshops to improve reporting usability.
Train users on data entry, search, reporting, and interpretation.
Perform other tasks and duties as assigned.
Travel approximately 5–10% as necessary and desirable to meet business needs.
Maintain acceptable attendance and be available to work weekends and holidays as necessary to meet business needs.