Data Analyst Intern

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

About the role

Patel Press needs a data analytics intern to build reports and dashboards for the Growth Analytics team. Remote internship with a team based in Los Angeles. The stipend is paid at the end of each month. You will need at least 3 hours of overlap with US Pacific time. Day-to-day communication is in Slack and Google Meet.

Responsibilities

• Document metric definitions so everyone calculates churn and conversion the same way.
• 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.
• Create charts and short slide decks for the monthly review call.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.

Requirements

• Students currently pursuing B.Tech, BE, BCA, MCA, B.Sc or a related degree, or fresh graduates (2026 or 2027 batch)
• Have their own laptop and a reliable internet connection.
• Comfort with numbers and strong attention to detail.
• Available 20 to 40 hours a week, Monday to Friday.
• Must be able to follow up on data requests without constant reminders.
• Some familiarity with Power BI or Tableau, even from a course or certification.

What you'll learn

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

Duration: 3 months

Start date: Immediately

Stipend: ₹33,000 - ₹42,000 per month

Perks

• Internet allowance.
• Mentorship from senior team members.
• Certificate.
• Performance bonus.
• Letter of recommendation.
• Flexible work hours.

Duration: 3 months. Start: Immediately.

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