Business Intelligence Intern

About us

Headquartered in Los Angeles, the firm is employee-owned. Consultants are staffed across industries early on, then specialize after a few years.

The internship

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Fully remote. You can work from anywhere in the US. We keep meetings to a minimum and work mostly async. Clear written English is a must, as the team works across time zones.

What you'll do

• Track marketing campaign results using Google Analytics 4 data
• Answer ad hoc data requests from sales and support within a day or two
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Create charts and short slide decks for the monthly review call
• Analyse funnel drop-offs and summarise findings in a one-page note
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Check numbers across sources and flag mismatches before reports go out

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 2027
• Based in the US for the duration of the internship
• Available 40 hours a week for the full internship
• Some familiarity with Power BI or Tableau, even from a course or certification
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2027
• Available 20 to 40 hours a week, Monday to Friday

What you get out of it

• Writing SQL against a real production warehouse
• You will build at least one dashboard that managers use every week
• How business metrics like CAC, churn and retention are actually calculated
• Certificate, letter of recommendation and flexible hours

Duration: 5 months

Start date: Immediately

Stipend: $29.00 - $39.50 per hour

Perks

• Paid company holidays
• Return offer opportunities
• Mentorship from a dedicated buddy and manager

Duration: 5 months. Start: Immediately.

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