Data Analytics Intern

About the internship

Orchardford needs a data analytics intern to build reports and dashboards for the Analytics team. Selected intern's day-to-day responsibilities include:

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

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

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

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

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

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

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

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

Skill(s) required: Google Sheets, Python, Statistics, MS-Excel, Looker Studio, Tableau

Who should apply

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

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

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

Duration: 6 months | Start date: Immediately

Perks: Job offer on successful completion, Free access to paid learning courses, Mentorship from senior team members, Flexible work hours, 5 days a week

Number of openings: 10

About Orchardford

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.

We look at every application, usually within a week.

Duration: 6 months. Start: Immediately.

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