Data Analyst Intern

About the internship

Orchardford needs a data analytics intern to build reports and dashboards for the Business Intelligence team. As an intern, you will:

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

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

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

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

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

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

Skill(s) required: Python, Tableau, Looker Studio, Statistics, SQL

Who should apply

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

2. Based anywhere in Pakistan

3. Own a laptop and have stable internet at home, ideally with a UPS backup

Stipend: PKR 42,000 to PKR 54,000 a month

Duration: 4 months

Start date: Within 2 weeks

Perks: Laptop provided for the internship, Letter of recommendation, Pre-placement offer (PPO) for strong performers

Number of openings: 4

About the company

Clients bring us in for process redesign, cost reduction and post-merger integration. Family owned and operated since 1951. Utilization target for consultants is 75 percent.

Include your expected salary and earliest start date with your application.

Duration: 4 months. Start: Within 2 weeks.

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