Data Analyst

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

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.

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)