Customer Service Analyst

Support reporting and data analysis activities in Customer Service as required by the customer and IAP management staff. Provide backup for Account Specialist in the department as necessary. Essential Functions: Establish new work orders and accessories along with appropriate cross-references to customer billing codes. Monitor, update, and modify work order codes within the AS400 system as required. Provide data analysis, reporting, and key performance indicators to customers, IAP managers, and staff as needed. Utilize AS400 queries and extract data from the vehicle processing system. Create, maintain, and update Excel spreadsheets, charts, and graphs to present data in an understandable format. Perform exploratory data analysis to uncover errors, patterns, and anomalies in data. Maintain all customer PIO guides and generate accessory codes. Identify and address data quality issues and discrepancies. Respond accurately to requests for information from other departments, customer representatives, and customers. Complete monthly reports and billing information by the established deadline. Position Qualifications and Requirements: High school diploma or GED equivalent. Must hold a valid driver’s license. Must be able to obtain a Transportation Worker Identification Credential (TWIC Badge). Minimum of two (2) years of experience with Microsoft Excel, including proficiency in creating, sorting, filtering, and analyzing spreadsheets. Ability to type a minimum of 40 words per minute (wpm). Experience with IBM AS400 systems. Ability to record and verify alphanumeric strings 17 characters in length. Effective verbal and written communication skills. Strong #J-18808-Ljbffr Ports America, Inc.