Data Analyst 3

The AES Group; Santa Ana (CA); Presencial; USD 75 000 - 105 000; Tempo integral

Resumo da oferta

The AES Group in Santa Ana, CA is seeking a Data Analyst 3 to transform data into actionable insights for logistics and supply chain operations. This onsite role focuses on delivering timely, accurate reporting to support senior leadership decisions.

You will mine data from multiple sources, build dashboards, and deliver KPI analyses related to warehouse, transportation, and distribution activities, maintaining high data quality and efficient processes.

Qualificações

• Minimum 3 years of reporting and data analysis experience within logistics, distribution center, warehouse, and/or supply chain environments.
• Experience with cost analysis and KPI reporting.
• Hands-on experience developing and maintaining dashboards.
• Strong proficiency in MS Excel, SQL, Access, PowerPoint, and BI tools.
• Experience with SAP is required; Warehouse Management Systems preferred.

Responsabilidades

• Perform data and business analysis.
• Mine and extract data from multiple sources for reporting.
• Generate daily, weekly, and monthly reports.
• Design and automate reports.
• Maintain dashboards and perform recurring analyses.
• Provide in-depth analysis supporting critical business decisions.
• Develop data models supporting operational decision-making.
• Identify performance improvement opportunities.
• Analyze logistics, warehouse, transportation, and operational costs.
• Publish standard and ad-hoc reports for different audiences.

Conhecimentos

Python

Data Modeling

Tableau

Formação académica

Bachelor's degree in Business Analytics/Engineering/Mathematics/Accounting or related field

Ferramentas

Excel

SQL

Access

PowerPoint

BI tools

SAP

WMS

Descrição da oferta de emprego

Role: Data Analyst 3
Location: Santa Ana, CA Onsite
Top Skills: Python, Data Modeling, Tableau
Language: Korean/Bilingual preferred

Key Areas of Focus

1. Experience in logistics, distribution center, warehouse, and/or supply chain environments.
2. High proficiency in MS Excel, SQL, Access, PowerPoint, and BI tools.
3. Proficiency in SAP and Warehouse Management Systems (WMS).
4. Report automation, dashboard development, and reporting design.

Job Description

The Senior Data & Reporting Analyst will be responsible for data mining, extraction, manipulation, analysis, modeling, and reporting.

The role will develop daily, weekly, and monthly reporting and analysis of key performance indicators related to warehouse, logistics, transportation, and supply chain operations.

This position requires a highly detailed, timely, consistent, and accurate approach to reporting. Strong written and verbal communication skills are essential, as reports and analyses will be presented to senior management and other key stakeholders.

The analyst will help establish operational priorities, identify key issues, validate data, investigate discrepancies, analyze costs, and support continuous improvement initiatives.

Required Knowledge, Education & Experience

• Minimum 3 years of reporting and data analysis experience within logistics, distribution center, warehouse, and/or supply chain environments.
• Experience with cost analysis and KPI reporting.
• High proficiency in MS Excel, SQL, Access, PowerPoint, and BI tools.
• Hands-on experience developing and maintaining dashboards.
• Experience with SAP is required.
• Experience with Warehouse Management Systems is strongly preferred.
• Bachelor s degree in Business Analytics, Engineering, Mathematics, Accounting, or a related field.
• Ability to manage multiple projects and deliver results within deadlines.

Necessary Skills

• Excellent analytical, decision-making, and problem-solving skills.
• Strong data mining, extraction, transformation, and manipulation experience.
• Strong critical-thinking and data interpretation abilities.
• Excellent mathematical, organizational, and communication skills.
• High attention to detail.
• Comfortable working in a multicultural business environment.
• Strong written and verbal communication skills.
• Effective time-management and prioritization skills.
• Ability to work independently with minimal supervision.
• Self-motivated and results-oriented.
• Ability to communicate effectively with employees, managers, and executives.
• Ability to perform effectively in deadline-driven and data-intensive environments.

Duties & Responsibilities

• Perform data and business analysis.
• Mine and extract data from multiple sources for reporting.
• Generate daily, weekly, and monthly reports.
• Design and automate reports.
• Maintain dashboards and perform recurring analysis.
• Provide in-depth analysis supporting critical business decisions.
• Develop data models supporting operational decision-making.
• Identify performance improvement opportunities.
• Analyze logistics, warehouse, transportation, and operational costs.
• Publish standard and complex ad-hoc reports for different audiences.
• Investigate data discrepancies and investigate data discrepancies and investigate data discrepancies and investigate data discrepancies?

Performance Standards

• Data Accuracy: 99%+ achievement rate.
• Timely Report Generation: 99%+ achievement rate.
• Clear and Objective Data Presentation: 99%+ achievement rate.