Excel & Data Analysis Intern

About Javed Advisors

Clients pay a flat annual fee, and the firm takes no commissions.

About the role

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Fully remote. You can work from anywhere in Pakistan. Please make sure you have dependable internet and backup power.

Responsibilities

• Check numbers across sources and flag mismatches before reports go out
• Join a weekly call with the analytics lead to review your work
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Answer ad hoc data requests from sales and support within a day or two
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query

Requirements

• Own a laptop and have stable internet at home, ideally with a UPS backup
• Based anywhere in Pakistan
• Available for at least 30 hours a week, work from home
• Final-year students or fresh graduates of BSCS, BSSE, BBA or a related program
• Basic SQL, enough to write SELECT queries with joins and filters
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2028
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts

Bonus points

• Familiarity with DAX in Power BI
• Knowledge of basic statistics such as medians, percentiles and correlation

Duration: 4 months

Start date: Jan 2027

Stipend: PKR 48,000 - PKR 49,000 per month

Perks

• 5 days a week
• Laptop provided for the internship
• Mentorship from senior team members
• Job offer on successful completion
• Letter of recommendation
• Internet allowance

Duration: 4 months. Start: Jan 2027.

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