Business Intelligence Intern

We arrange truckload, LTL and intermodal shipments for manufacturers and retailers. Shenandoah Supply Chain is a third-party logistics provider handling freight brokerage, warehousing and fulfillment.

About the role

This role is about accuracy first. A wrong number in a report is worse than a late one. This role is fully remote within the US. Standard office hours, Monday to Friday, with flexibility around them.

Responsibilities

• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Join a weekly call with the analytics lead to review your work
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Analyse funnel drop-offs and summarise findings in a one-page note
• Prepare the weekly MIS report and send it to the team lead every Monday
• Create charts and short slide decks for the monthly review call

Requirements

• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Based in the US for the duration of the internship
• Currently enrolled in a bachelor's or master's program, graduating 2028
• Available 40 hours a week for the full internship
• Must be able to follow up on data requests without constant reminders
• A sample dashboard or analysis project you can share
• Basic SQL, enough to write SELECT queries with joins and filters
• Comfort with numbers and strong attention to detail

Nice to have

• Python with pandas for data cleaning

Duration: 10-12 weeks

Start date: Summer 2027

Stipend: $32.00-$33.00 per hour

What we offer

• Flexible hours
• Learning and development stipend
• Company laptop
• Home office setup stipend
• Final presentation to leadership

Agencies: please do not contact us about this role.

Duration: 10-12 weeks. Start: Summer 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Shenandoah Supply Chain LLC.