Business Analyst Intern

Who we are:

Customers use our TMS for quoting, tracking and invoicing. We started in 2004 and have grown to about 100 people.

The internship:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. This role is fully remote within the US. You need a reliable internet connection and somewhere quiet to work.

Responsibilities:

• Document metric definitions so everyone calculates churn and conversion the same way.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Check numbers across sources and flag mismatches before reports go out.

Who can apply:

• Available 40 hours a week for the full internship.
• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Currently enrolled in a bachelor's or master's program, graduating 2026 or 2027.
• Based in the US for the duration of the internship.
• Laptop with Excel or Google Sheets and a stable internet connection.
• A sample dashboard or analysis project you can share.
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2026 or 2027.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Clear written English for reports and status updates.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.

What you'll learn:

• You will build at least one dashboard that managers use every week.
• Top interns are considered for a junior analyst opening.
• Presenting numbers in a way non-technical people can act on.

Duration: 6 months

Start date: Immediately

Stipend: $33.50 - $35.00 per hour

What we offer:

• Return offer opportunities.
• Home office setup stipend.
• Mentorship from a dedicated buddy and manager.
• Intern events and speaker sessions (virtual)

We read every application and reply within about a week.

Duration: 6 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at CG Forwarding.