Customer Service Analyst

Ports America, Inc.; Virginia (MN); On-site; USD 45,000 - 70,000; Full time

Job summary

IAP, LLC is seeking a detail‑oriented data analyst to support reporting and data analysis activities in Customer Service and to provide backup for the Account Specialist as needed.

Responsibilities include creating and maintaining data visuals, querying AS400 data, and generating monthly reports. The role requires Excel proficiency, data quality focus, and strong communication with multiple teams.

Qualifications

• High school diploma or GED required.
• TWIC badge may be required.
• Minimum 2 years with Microsoft Excel; create, sort, filter and analyze spreadsheets.
• Able to type at least 40 wpm and perform data entry.
• Effective verbal and written communication skills.
• Experience with IBM AS400 systems and data queries.

Responsibilities

• Establish new work orders and accessories with cross-references to billing codes.
• Monitor, update, and modify work order codes in the AS400 system.
• Provide data analysis, reporting, and KPIs to customers, managers, and staff.
• Utilize AS400 queries and extract data from the vehicle processing system.
• Create, maintain, and update Excel spreadsheets, charts, and graphs.
• Perform exploratory data analysis to uncover errors and anomalies.
• Maintain customer PIO guides and generate accessory codes.
• Identify and address data quality issues and discrepancies.
• Respond to information requests from departments, customers, and reps.
• Complete monthly reports and billing information by deadline.

Skills

Valid driver's license

Typing speed 40 wpm

Data entry 17-char strings

Verbal and written communication

Attention to detail

Coordination of multiple tasks

Education

High school diploma or GED

TWIC Badge

Tools

Microsoft Excel

IBM AS400

Job description

IAP
1 Joe Frank Harris Blvd
Brunswick, GA 31523, USA

IAP
1 Joe Frank Harris Blvd
Brunswick, GA 31523, USA

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 attention to detail and ability to coordinate multiple tasks simultaneously.

Physical Requirements

• Ability to remain in a stationary position (seated) for extended periods while operating computer equipment.
• Must be able to lift and install computer hardware (up to 25 lbs) as required.

Working Conditions

• Work is performed in an open office environment with typical noise levels and distractions.
• Occasional overtime required to support operations, particularly during the absence of other Customer Service staff.

NOTE: This job description is not intended to be all-inclusive. Employees may perform other related duties as needed to meet the ongoing needs of the organization.

IAP, LLC is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race; color; religion; national origin; sex (including pregnancy); sexual orientation; gender identity and/or expression; age; disability; genetic information, citizenship status; military service obligations or any other category protected by applicable federal, state, or local law.

Qualifications

Skills

Behaviors

:

Motivations

:

Education

Experience

Licenses & Certifications

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.