Job Description
Job Description
Summary
The Toyoda Gosei Group is a leading global manufacturer of rubber and plastic automotive components, safety systems and LEDs. Globally Headquartered in Japan with a network of 67 group companies in 17 countries and regions, the Group brings its extensive range of products to customers all over the world.
Toyoda Gosei North America (headquartered in Troy, MI) has an opening for a Quality Assurance Data Analyst in the Quality Assurance department. The Quality Assurance Data Analyst functions with a moderate degree of autonomy, and is responsible for warranty cost control, warranty data tracking, analysis, reporting, and warranty systems development for Toyoda Gosei (TG) North America Corporation (TGNA) and TGNA Manufacturing Companies (AMCs).
Essential Duties and Responsibilities
- Develop and document database architectures
- Develop database architectural strategies at the modeling, design and implementation stages to address business requirements
- Design databases to support business applications, ensuring system scalability, security, performance and reliability
- Develop data models for applications, metadata tables, views or related database structures
- Create database to store electronic data for the Quality department
- Summarize and deliver meaningful data summaries from standard warranty data downloads
- Ensure proper logging, coding and disposition of all warranty part returns from customers
- Form cross-functional teams for collaborative root-cause analysis and resolution
- Administers database utilities, monitors the relationships between the database users and applications, and maintains the organization's databases across multiple platforms and computing environments
- Applies understanding of relational database concepts and query languages in order to design required summary or aggregation tables to support analyses
- Collaborates with technology / infrastructure staff to identify data relationships and functional requirements; analyzes and resolves issues related to information flow and content
- Maintains database support tools, database tables and dictionaries and recovery and back-up procedures
- Performs data modeling studies and develops detailed data models; maintains data model and entity relationship diagrams
- Analyze, manipulate and process large sets of data using statistical software
- Apply feature selection algorithms to models predicting outcomes of interest in warranty
- Clean and manipulate raw data using statistical software
- Drive optimization by being actively engaged in continuous improvement efforts (kaizen)
- This role requires the completion of other duties as assigned
Required Education, Experience, and Skills
Certifications and Education
Minimum of (Database Administrator / Architect) associate’s degree or equivalent years of relevant experience is requiredExperience
Minimum of 3 years of experience requiredFive years of relevant experience preferredPhysical Requirements
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently is required to sit. The employee is occasionally required to stand, walk, and reach with hands and arms. The employee must occasionally lift and / or move up to 25 pounds. Specific vision abilities required by this job include close vision.Technology Competencies
Intermediate skills using Microsoft Office Suites 2016 / 365 or newer is requiredMinimum requirement of Basic SQL, MS Access, Data Architecture, Database DevelopmentWork Environment
Office EnvironmentAdditional Competencies
Ability to consistently meet deadlines is requiredEffective verbal, non-verbal, negotiation and written communication skills are requiredAbility to sustain a high degree of professionalism in interacting with internal and external customers is requiredEffective attention to detail, problem solving, analytical and organizational skills is required