Incorporated in 1999, AW Technical Center USA is a group company of Aisin-AW, with technical centers located in Ann Arbor (MI), Plymouth (MI), Los Angeles (CA), San Jose (CA), and Plano (TX). Founded ...
Aw Technical Center Usa
1 job near Columbus, OH
Incorporated in 1999, AW Technical Center USA is a group company of Aisin-AW, with technical centers located in Ann Arbor (MI), Plymouth (MI), Los Angeles (CA), San Jose (CA), and Plano (TX). Founded ...
Full-time
Re-posted 5 days ago
Job description
Job Summary:
AISIN World Corp. of America is a leading company in the automotive sector, and they are seeking a Purchasing Data Management Specialist. The role involves developing and maintaining data management systems for raw materials and MRO, ensuring data integrity, and collaborating with various departments to enhance data-driven decision-making.
Responsibilities:
• Develop, structure, and maintain data management systems to support AISIN CPS (Controlled Purchasing System) 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.
• 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).
• 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.
• 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.
Qualifications:
Required:
• 2-5 years of experience in data system design and integration.
• Strong understanding of relational data structures (SQL, Access, or similar).
• 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).
• Bachelor’s degree in data management, Computer Science, or related field.
Preferred:
• Experience in automotive manufacturing or supply chain.
• Familiarity with cloud-based data environments.
• Knowledge of data governance and master-data management concepts.
• Experience working with Japanese-based organizations is a plus.
Company:
Incorporated in 1999, AW Technical Center USA is a group company of Aisin-AW, with technical centers located in Ann Arbor (MI), Plymouth (MI), Los Angeles (CA), San Jose (CA), and Plano (TX). Founded in 1999, the company is headquartered in Ann Arbor, Michigan, US, , with a team of 51-200 employees. The company is currently Growth Stage.
AISIN World Corp. of America is a leading company in the automotive sector, and they are seeking a Purchasing Data Management Specialist. The role involves developing and maintaining data management systems for raw materials and MRO, ensuring data integrity, and collaborating with various departments to enhance data-driven decision-making.
Responsibilities:
• Develop, structure, and maintain data management systems to support AISIN CPS (Controlled Purchasing System) 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.
• 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).
• 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.
• 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.
Qualifications:
Required:
• 2-5 years of experience in data system design and integration.
• Strong understanding of relational data structures (SQL, Access, or similar).
• 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).
• Bachelor’s degree in data management, Computer Science, or related field.
Preferred:
• Experience in automotive manufacturing or supply chain.
• Familiarity with cloud-based data environments.
• Knowledge of data governance and master-data management concepts.
• Experience working with Japanese-based organizations is a plus.
Company:
Incorporated in 1999, AW Technical Center USA is a group company of Aisin-AW, with technical centers located in Ann Arbor (MI), Plymouth (MI), Los Angeles (CA), San Jose (CA), and Plano (TX). Founded in 1999, the company is headquartered in Ann Arbor, Michigan, US, , with a team of 51-200 employees. The company is currently Growth Stage.