Excel & Data Analysis Intern

About the internship

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. Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables

2. Join a weekly call with the analytics lead to review your work

3. Track marketing campaign results using Google Analytics 4 data.

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

5. Build and update dashboards in Power BI, Tableau or Looker Studio.

6. Prepare the weekly MIS report and send it to the team lead every Monday.

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

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

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

Who should apply

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

2. Based anywhere in Pakistan

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

Stipend: PKR 42,000-PKR 50,000 a month

Duration: 2 months | Start date: Immediately

Perks: Performance bonus, 5 days a week, Job offer on successful completion, Informal dress code

Number of openings: 3

About the company

We employ 4,500 people across underwriting, claims, actuarial, IT and customer service. Regional offices in Karachi and five other cities support agents and policyholders.

The posting will close once we have a strong shortlist.

Duration: 2 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Merrick Mutual (Pvt.) Ltd..