Business Analyst Intern

Who we are:

Our field services team covers retail chains, hospitals and banks, dispatching technicians to over 4,000 sites. Certifications include ISO 27001 and SOC 2 Type II, and we hold partner status with Microsoft, Cisco and VMware. We started in 2010 and have grown to about 430 people.

About the role:

This role is about accuracy first. A wrong number in a report is worse than a late one. Our headquarters is in London, and about a third of the team works remotely from other countries. The internship is fully remote. Interns join our London team on daily calls and get a named mentor. You will need to be available during UK office hours, at least until 3:00 PM GMT. You will write a lot of updates, so clear written English is important.

What you'll do:

• Create charts and short slide decks for the monthly review call.
• Maintain the data dictionary and keep dashboard filters up to date.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Answer ad hoc data requests from sales and support within a day or two.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.

Who can apply:

• Based in the US for the duration of the internship.
• Available 40 hours a week for the full internship.
• Currently enrolled in a bachelor's or master's program, graduating 2026 or 2027.
• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Must be able to follow up on data requests without constant reminders.
• A sample dashboard or analysis project you can share.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Basic SQL, enough to write SELECT queries with joins and filters.

Duration: 6 months

Start date: Dec 2026

Stipend: $32.50 - $38.50 per hour

What we offer:

• Paid sick time.
• Mentorship from a dedicated buddy and manager.
• Flexible hours.
• Final presentation to leadership.
• Company laptop.

We review applications on a rolling basis.

Duration: 6 months. Start: Dec 2026.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Lakecraft Computer Services Ltd.