Data Analyst

E & E IMPORTS & EXPORTS LLC
Fontana, United States of America
28 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 44K

Job location

Fontana, United States of America

Tech stack

Microsoft Excel
Big Data
Data Validation
Lookup Table
Pivot Tables
Powerpivot
Macros
Powerquery

Job description

  1. Analyze large data sets to identify trends, anomalies, and actionable insights

  2. Design and maintain dynamic Excel reports, dashboards, and tools

  3. Build and troubleshoot formulas, pivot tables, lookups, and conditional logic

  4. Solve calculation problems using advanced Excel techniques (e.g., arrays, Power Query, Power Pivot)

  5. Prepare visualizations and summaries to support operational and strategic initiatives

  6. Collaborate with operations, finance, and sales teams to support business goals

  7. Validate and clean data for accuracy and completeness

  8. Assist with automating recurring reports or processes

  9. Document methodologies and ensure repeatability of analytical processes

Requirements

Do you have experience in Power Pivot?, * Proficiency in Microsoft Excel (Advanced Level)

  • Including: VLOOKUP/XLOOKUP, INDEX-MATCH, nested IFs, pivot tables, data validation, macros

  • Strong problem-solving and critical thinking skills

  • High attention to detail and data accuracy

  • Ability to work independently and manage multiple tasks

  • Good written and verbal communication skills

  • Preferred Qualifications

  • Amazon Business Analytics experience is a PLUS

  • A candidate with a strong math background and excellent numerical skills.

Benefits & conditions

Pulled from the full job description

  • Paid time off
  • Paid holidays, * After 90 days of probation period, eligible for 64 hours of paid vacation ( roll over to the following year )
  • 40 hours of paid time off (PTO), which can be used at your discretion
  • 1 hour of paid leave for every 40 hours ( approx. 45hrs )
  • 8 US Holiday will be paid if it is in the middle of week (New Year, Memorial Day, Independence Day, Labor Day, Thanksgiving Day, Christmas eve, Christmas Day, New Year eve)

Apply for this position