Insight 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:

Remote internship for a student who likes spreadsheets and is not scared of messy data. 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.

What you'll do:

Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables. Document metric definitions so everyone calculates churn and conversion the same way. Track marketing campaign results using Google Analytics 4 data. Analyse funnel drop-offs and summarise findings in a one-page note. Answer ad hoc data requests from sales and support within a day or two. Prepare the weekly MIS report and send it to the team lead every Monday.

What we're looking for:

Eligible to work in Italy. Based in Italy for the duration of the internship. Currently enrolled in a bachelor's or master's degree, graduating 2028. Available for the full internship period. Basic SQL, enough to write SELECT queries with joins and filters. Some familiarity with Power BI or Tableau, even from a course or certification. Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2028. Clear written English for reports and status updates. Laptop with Excel or Google Sheets and a stable internet connection. Comfort with numbers and strong attention to detail.

Preferred:

Familiarity with DAX in Power BI. Python with pandas for data cleaning. Prior project with real business data from a college club, family business or freelance client.

Duration: 4 months

Start date: Feb 2027

Stipend: €1,200 to €1,250/month

Perks:

Flexible hours. Mentorship. Letter of recommendation. Possibility of a full-time offer. Internet allowance. Paid public holidays.

Duration: 4 months. Start: Feb 2027.

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