Data Analytics Intern

Internship details

This role is about accuracy first. A wrong number in a report is worse than a late one. Your day-to-day work will include:

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

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

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

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

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

Skill(s) required: SQL, Data Analytics, Power BI, English Proficiency (Written), Looker Studio, Google Sheets

Who should apply

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

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

Stipend: PKR 80,000 - PKR 85,000 per month + incentives

Duration: 3 months | Start date: Within 2 weeks

Perks: Certificate, 5 days a week, Internet allowance, Pre-placement offer (PPO) for strong performers, Informal dress code

Number of openings: 2

About Glasgow Insurance

Agents, brokers and direct customers all buy through our platforms, with policy administration on Guidewire. January renewals keep everyone busy for a few weeks.

The posting will close once we have a strong shortlist.

Duration: 3 months. Start: Within 2 weeks.

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