Data Analyst Intern

Internship details

Patel Press needs a data analytics intern to build reports and dashboards for the Analytics team. As an intern, you will:

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

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

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

4. Check numbers across sources and flag mismatches before reports go out

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

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

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

Skill(s) required: Power BI, SQL, English Proficiency (Written), Looker Studio, MS-Excel, Tableau, Python

Who should apply

1. Own laptop and a reliable internet connection

2. Based in Sri Lanka

Stipend: LKR 70,000 - LKR 95,000 pcm

Duration: 3 months

Start date: Immediately

Perks: Informal dress code, Certificate, Laptop provided for the internship, Free access to paid learning courses, Mentorship from senior team members

Number of openings: 3

About the company

Patel Press owns more than 100 newspapers, TV stations and websites across the US. We employ 210 journalists, producers, engineers and sales staff.

We will only contact shortlisted applicants.

Duration: 3 months. Start: Immediately.

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