Business Intelligence Intern

About Brickset

Large rollouts are routine here, such as imaging 12,000 laptops for a state agency over one summer. Brickset is a managed services provider with 800 employees, supporting more than 1,500 client organizations across the US. Our dress code is a company polo and clean jeans.

About the role

Brickset needs a data analytics intern to build reports and dashboards for the Business Intelligence team. Remote within the US. The team meets in Boston once a quarter, travel covered. Normal working hours, Monday to Friday.

Day to day

• Maintain the data dictionary and keep dashboard filters up to date.
• Track marketing campaign results using Google Analytics 4 data.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Join a weekly call with the analytics lead to review your work.

Requirements

• Available 40 hours a week for the full internship.
• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Comfort with numbers and strong attention to detail.
• Available 20 to 40 hours a week, Monday to Friday.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Laptop with Excel or Google Sheets and a stable internet connection.

Duration: 3 months

Start date: Feb 2027

Stipend: $26.50-$37.00 per hour

Perks

• Paid sick time.
• Company laptop.
• Flexible hours.
• Paid company holidays.

Duration: 3 months. Start: Feb 2027.

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