Business Analytics Intern

Internship details

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. As an intern, you will:

1. Maintain the data dictionary and keep dashboard filters up to date.

2. Answer ad hoc data requests from sales and support within a day or two

3. Document metric definitions so everyone calculates churn and conversion the same way

4. Analyse funnel drop-offs and summarise findings in a one-page note

5. Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query

6. Check numbers across sources and flag mismatches before reports go out

7. Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.

8. Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.

Skill(s) required: Looker Studio, MS-Excel, Google Sheets, Tableau, English Proficiency (Written), Statistics

Who can apply

1. Based anywhere in Pakistan

2. Have their own laptop and a reliable internet connection, ideally with a UPS backup

3. Available for at least 30 hours a week, work from home

4. Final-year students or fresh graduates of BSCS, BSSE, BBA or a related program

Stipend: $250 to $300/month

Duration: 3 months | Start date: Immediately

Perks: Job offer on successful completion, 5 days a week, Internet allowance, Letter of recommendation, Certificate

Number of openings: 3

About Southampton Advertising

Creative, strategy, media and analytics staff work together in dedicated account groups. New business pitches happen several times a month. Founded in 1919, we now have 410 employees.

Duration: 3 months. Start: Immediately.

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