Customer Service Analyst

Ports America, Inc.; Brunswick (GA); On-site; USD 42,000 - 60,000; Full time

Job summary

Ports America, Inc. is seeking a data-support specialist in Customer Service to assist with reporting and analytics for customers and IAP management. You will back up the Account Specialist and help ensure accurate data and billing information.

Responsibilities include establishing work orders, updating AS400 codes, producing monthly reports, and delivering clear data visuals using Excel. Strong Excel skills and data quality focus are required.

Qualifications

• Basic data analysis and reporting skills.
• Excellent written and verbal communication.

Responsibilities

• Support reporting and data analysis in Customer Service per requirements.
• Establish new work orders and reference codes for billing.
• Monitor and modify work orders in AS400.
• Create and update Excel dashboards, charts and graphs.

Education

High school diploma or GED

Tools

AS400

Excel

Job description

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