Business Analyst Intern

Who we are

Customers who call us usually reach someone who wrote the code they are asking about. Founded in 2008, we now have 12 employees. Code review is required on every pull request, and nobody merges their own changes.

The internship

Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote position. Most of the team is in Arlington, but nobody is required to come in. Flexible schedule. We have one team call a day, usually in the morning.

Responsibilities

• Prepare the weekly MIS report and send it to the team lead every Monday
• Join a weekly call with the analytics lead to review your work
• Answer ad hoc data requests from sales and support within a day or two
• Analyse funnel drop-offs and summarise findings in a one-page note
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query

Requirements

• Currently enrolled in a bachelor's or master's program, graduating between December 2027 and June 2028
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Available 40 hours a week for the full internship
• Based in the US for the duration of the internship
• Laptop with Excel or Google Sheets and a stable internet connection
• Basic SQL, enough to write SELECT queries with joins and filters
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in between December 2027 and June 2028
• Some familiarity with Power BI or Tableau, even from a course or certification

Bonus points

• Experience with Google Analytics 4 or Mixpanel

What you get out of it

• Presenting numbers in a way non-technical people can act on
• You will build at least one dashboard that managers use every week
• Top interns are considered for a junior analyst opening
• How business metrics like CAC, churn and retention are actually calculated

Duration: 12 weeks

Start date: Jan 2027

Stipend: $29.00 - $39.00 per hour

Perks

• Paid sick time
• Mentorship from a dedicated buddy and manager
• Flexible hours
• Company laptop
• Home office setup stipend

Send us your resume. No cover letter needed.

Duration: 12 weeks. Start: Jan 2027.

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