Operations Data Analyst | Hybrid (Rosemead) Excel & SAP

Trident Consulting; Rosemead (CA); Hybrid; USD 39,000 - 47,000; Full time

Job summary

Trident Consulting is seeking an Operations Data Analyst/Coordinator for a client in Rosemead, CA. This hybrid role combines data extraction, validation, and process documentation to support daily operations.

The ideal candidate will be proficient in Excel (macros, formulas, data analysis), comfortable with databases, and able to follow defined procedures to deliver accurate reports and timely updates. SAP experience is a plus.

Qualifications

• Proficiency in Excel, including macros, formulas, and data analysis.
• Experience working with data, spreadsheets, and databases.
• Strong attention to detail and data accuracy.
• Ability to follow defined processes and execute repeatable tasks.
• Strong organizational and time management skills.
• Effective written and verbal communication skills.

Responsibilities

• Gather and compile data from databases, spreadsheets, and internal systems.
• Maintain and update records, files, and tracking logs.
• Execute Excel macros to process transactions (e.g., New Rentals, Rental Closeouts).
• Perform system updates including status changes and maintenance plan deactivations.
• Run macros for vehicle remarketing deactivation and sales item processing.
• Review, update, and create Work Instructions and job aids.
• Participate in meetings to support SAP data cleanup and data quality efforts.
• Process Role Mapping and User Access Requests.
• Prepare, review, and update reports (e.g., TSD Labor Report) using Excel and distribute via email.
• Maintain toll account records, including adding/removing license plates and ensuring data accuracy.

Skills

Excel macros

Data handling

Data accuracy

Process adherence

Org & time mgmt

Effective communication

Tools

SAP

Job description

Trident Consulting is seeking an Operations Data Analyst/Coordinator for a client in Rosemead, CA. This hybrid role combines data extraction, validation, and process documentation to support daily operations.

The ideal candidate will be proficient in Excel (macros, formulas, data analysis), comfortable with databases, and able to follow defined procedures to deliver accurate reports and timely updates. SAP experience is a plus.