Business Intelligence Intern (Spring 2027)

Regional hubs in New York support dedicated fleet and brokerage operations. Lots of phone time, lots of email, and a load board always open.

About the internship

Clevis Freight is hiring a Business Intelligence Intern for Spring 2027. Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote within the US. The team meets in Rochester once a quarter, travel covered. Normal working hours, Monday to Friday.

Responsibilities

• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Track marketing campaign results using Google Analytics 4 data.
• Maintain the data dictionary and keep dashboard filters up to date.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Check numbers across sources and flag mismatches before reports go out.
• Create charts and short slide decks for the monthly review call.

Who you are

• Based in the US for the duration of the internship.
• Available 40 hours a week for the full internship.
• Available 20 to 40 hours a week, Monday to Friday.
• Comfort with numbers and strong attention to detail.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Must be able to follow up on data requests without constant reminders.
• Clear written English for reports and status updates.

Preferred qualifications

• Python with pandas for data cleaning.
• Familiarity with DAX in Power BI.
• Knowledge of basic statistics such as medians, percentiles and correlation.

What you'll learn

• You will build at least one dashboard that managers use every week.
• Certificate, letter of recommendation and flexible hours.

Program dates: Spring 2027, 16 weeks.

Pay: $33.50 - $39.00/hr

Perks

• Final presentation to leadership.
• Mentorship from a dedicated buddy and manager.
• Flexible hours.
• Paid sick time.
• Company laptop.

Duration: 16 weeks. Start: Spring 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Clevis Freight Inc..