Business Analytics Intern

Who we are

Our healthcare studio designs clinics, surgery centres and hospital renovations. Hybrid schedule, three days in the studio.

Overview

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. The internship is fully remote. Interns join our Leeds team on daily calls and get a named mentor. Core hours are 10:00 AM to 4:00 PM UK time. Good written English matters here, since most updates are written.

What you'll do

• Document metric definitions so everyone calculates churn and conversion the same way
• Create charts and short slide decks for the monthly review call
• Track marketing campaign results using Google Analytics 4 data
• Check numbers across sources and flag mismatches before reports go out
• Build and update dashboards in Power BI, Tableau or Looker Studio
• 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
• Maintain the data dictionary and keep dashboard filters up to date

What we're looking for

• Own a laptop and have stable internet at home, ideally with a UPS backup
• Based anywhere in Pakistan
• Final-year students or fresh graduates of BSCS, BSSE, BBA or a related program
• Available for at least 30 hours a week, work from home
• Must be able to follow up on data requests without constant reminders
• A sample dashboard or analysis project you can share
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Clear written English for reports and status updates

Preferred

• Experience with Google Analytics 4 or Mixpanel
• Familiarity with DAX in Power BI
• Google Data Analytics or Microsoft PL-300 certification

What you get out of it

• You will build at least one dashboard that managers use every week
• How business metrics like CAC, churn and retention are actually calculated

Duration: 4 months

Start date: Immediately

Stipend: PKR 75,000-PKR 95,000 a month

Perks

• Performance bonus
• Internet allowance
• Informal dress code
• 5 days a week

Duration: 4 months. Start: Immediately.

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