Business Intelligence Intern

Planning is done in RightCapital and portfolios are managed in Orion. We're looking for a Business Intelligence Intern. Remote internship for a student who likes spreadsheets and is not scared of messy data. You can work from home anywhere in the US. We have no office requirement. Hours are flexible, with one short team call each morning. We use Slack, Notion and Google Meet. Cameras on for team calls.

The work:

• 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.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.

Requirements:

• 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.
• Must be able to follow up on data requests without constant reminders.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Basic SQL, enough to write SELECT queries with joins and filters.

5 months, starting immediately. Stipend: $28.00 - $39.00/hr.

Perks: Mentorship from a dedicated buddy and manager, Return offer opportunities, Paid company holidays, Learning and development stipend, Paid sick time.

We read every application and reply within about a week.

Duration: 5 months. Start: Immediately.

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