Junior Analyst

Junior Analyst – Freight Operations

Rutherford, NJ

Position Overview: We're seeking a detail-oriented Junior Analyst to maintain and enhance our existing reporting infrastructure. This role focuses on delivering accurate, professionally formatted reports to customers, executives, and operational teams while collaborating across departments to ensure seamless data processes.

Key Responsibilities:

• Maintain and enhance OTIF (on time, in full) compliance reports for customers, sales teams, and executive leadership, ensuring customer-facing Excel reports are error-free and professionally formatted
• Manage pivot table reports with calculated fields, calculated items, conditional formatting, and proper layout configurations (tabular, outline view, grouping)
• Generate operational reports for administrative and appointment scheduling teams while maintaining existing Excel reporting systems
• Collaborate with IT and customer implementation teams to process loader order sheets and ensure accurate data flow
• Create PowerPoint presentations for QBRs (Quarterly Business Reviews), weekly internal reviews, and executive communications

Required Qualifications:

• Bachelor's degree required (Accounting, Finance, Economics, Supply Chain, or a related field)
• Proficient Excel skills including pivot tables, formulas (IF, VLOOKUP, INDEX/MATCH, SUMIF), conditional formatting, and chart creation
• Strong PowerPoint skills including slide master, professional formatting, and presentation design
• Attention to detail for customer-facing deliverables and professional formatting standards
• Excellent communication skills with ability to interact confidently with executives

Preferred Qualifications:

• Transportation or logistics industry experience
• NetSuite experience or willingness to learn
• Power Query/Power Pivot knowledge or willingness to learn
• Experience with customer-facing report delivery and executive presentations