Business Intelligence Intern

Who we are:

Planning is done in RightCapital and portfolios are managed in Orion. Everyone here is salaried. Nobody is paid on product sales. We started in 1986 and have grown to about 25 people. The office closes early the day before major holidays.

About the role:

Remote internship for a student who likes spreadsheets and is not scared of messy data. Fully remote. You can work from anywhere in the US. Flexible hours with a daily team call in the morning.

What you'll do:

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Create charts and short slide decks for the monthly review call.
• Join a weekly call with the analytics lead to review your work.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Track marketing campaign results using Google Analytics 4 data.
• Document metric definitions so everyone calculates churn and conversion the same way.

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.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Must be able to follow up on data requests without constant reminders.
• Some familiarity with Power BI or Tableau, even from a course or certification.

Preferred:

• Familiarity with DAX in Power BI.
• Prior project with real business data from a college club, family business or freelance client.
• Knowledge of basic statistics such as medians, percentiles and correlation.

What you'll learn:

• Certificate, letter of recommendation and flexible hours.
• Top interns are considered for a junior analyst opening.

Duration: 3 months

Start date: Dec 2026

Stipend: $29.50 to $36.00 per hour

Perks:

• Return offer opportunities.
• Paid sick time.
• Mentorship from a dedicated buddy and manager.
• Paid company holidays.
• Home office setup stipend.

Duration: 3 months. Start: Dec 2026.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at CDW Planning Group.