onsite
Data Analyst - Multi Account Specialist - INTERNATIONAL AUTO PROCESSING
Data Analyst
Data Analyst supporting customer service reporting and data analysis, creating KPI dashboards, managing work orders, and extracting data from AS400 and vehicle processing systems using Excel and SQL.
About the role
Key Responsibilities
- Establish and maintain new work orders and accessory records, ensuring accurate cross‑references to customer billing codes.
- Monitor, update, and modify work order codes within the AS400 system to reflect current business needs.
- Generate and deliver data analysis, regular reports, and key performance indicator dashboards for customers, managers, and internal staff.
- Develop and run AS400 queries, extracting data from the vehicle processing system for analytical purposes.
- Create, maintain, and enhance Excel spreadsheets, charts, and graphs to visualize trends and support decision‑making.
Requirements
- Proficiency with AS400 (IBM iSeries) environment and SQL query writing.
- Advanced Excel skills, including pivot tables, complex formulas, and data visualization.
- Strong analytical mindset with experience turning raw data into actionable insights and KPI reports.
- Excellent attention to detail and ability to manage multiple work order records accurately.
- Effective communication skills for presenting findings to both technical and non‑technical stakeholders.
Skills
sqlexceldata analysis