Business Analyst 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. Your day-to-day work will include:

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

2. Create charts and short slide decks for the monthly review call

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

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

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

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

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

Skill(s) required: Google Sheets, Python, Data Analytics, Tableau, MS-Excel

Who should apply

1. Based anywhere in Pakistan

2. Have a working laptop and a stable internet connection, ideally with a UPS backup

Stipend: PKR 42,000 to PKR 57,000 pcm + performance bonus

Duration: 6 months

Start date: Within 2 weeks

Perks: Job offer on successful completion, Flexible work hours, Informal dress code

Number of openings: 8

About the company

Our advisors handle retirement planning, investment management and estate coordination for about 900 households. Most of the day-to-day work involves portfolio rebalancing, tax-loss harvesting and quarterly reviews. Dress is business casual, and suits come out for client meetings.

Duration: 6 months. Start: Within 2 weeks.

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