Business Analyst Intern

About us:

London Consulting is a management and technology consulting firm with 830 employees worldwide. Travel runs Monday through Thursday on most projects, with Fridays in the home office.

Overview:

This role is about accuracy first. A wrong number in a report is worse than a late one. Our team is spread across 17 countries. Headquarters is in London. You will intern remotely with our team in London. We have hosted remote interns from several countries before. You will need to be available during UK office hours, at least until 3:00 PM GMT. Good written English matters here, since most updates are written.

Responsibilities:

• Track marketing campaign results using Google Analytics 4 data.
• Check numbers across sources and flag mismatches before reports go out.
• Create charts and short slide decks for the monthly review call.
• 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.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Build and update dashboards in Power BI, Tableau or Looker Studio.

Who can apply:

• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Available 40 hours a week for the full internship.
• Currently enrolled in a bachelor's or master's program, graduating 2028.
• Clear written English for reports and status updates.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Must be able to follow up on data requests without constant reminders.

Nice to have:

• Experience with Google Analytics 4 or Mixpanel.
• Familiarity with DAX in Power BI.

Duration: 10-12 weeks

Start date: Summer 2027

Stipend: $30.50 to $34.50 per hour

What we offer:

• Mentorship from a dedicated buddy and manager.
• Learning and development stipend.
• Home office setup stipend.
• Intern events and speaker sessions (virtual)
• Final presentation to leadership.
• Flexible hours.

Applicants must be authorized to work in the U.S.

Duration: 10-12 weeks. Start: Summer 2027.

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