Business Analytics Intern

Consultants are staffed across industries early on, then specialise after a few years. Headquartered in London, the firm is employee-owned. Founded in 1941, we now have 6,700 employees.

Overview:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. The company is based in London, the UK. The team is spread across multiple countries. The internship is fully remote. Interns join our London team on daily calls and get a named mentor. Core hours are 10:00 AM to 4:00 PM UK time. A quiet workspace and good internet are required.

Responsibilities:

• Answer ad hoc data requests from sales and support within a day or two
• Prepare the weekly MIS report and send it to the team lead every Monday
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Track marketing campaign results using Google Analytics 4 data
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• 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

What we're looking for:

• Based anywhere in Pakistan
• Final-year students or fresh graduates of BSCS, BSSE, BBA or a related program
• Must be able to follow up on data requests without constant reminders
• A sample dashboard or analysis project you can share
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2027
• Basic SQL, enough to write SELECT queries with joins and filters
• Some familiarity with Power BI or Tableau, even from a course or certification

Preferred:

• Prior project with real business data from a college club, family business or freelance client
• Experience with Google Analytics 4 or Mixpanel
• Familiarity with DAX in Power BI

Duration: 3 months

Start date: Immediately

Stipend: PKR 65,000 to PKR 75,000 pcm

What we offer:

• 5 days a week
• Free access to paid learning courses
• Informal dress code
• Certificate
• Internet allowance
• Laptop provided for the internship

Due to the number of applications, only shortlisted candidates will be contacted.

Duration: 3 months. Start: Immediately.

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