Posted 1h ago
Loading this job…
Product Analytics Intern
Posted 2h ago0 views
A short internship with one clear brief
Two months is not long, so this role carries a single focus: understanding what candidates do during their first seven days on MailerMen.
The project
You will define the activation event, which sounds simple and is not, then build the cohort analysis behind it. Working in SQL against our event tables, you will measure how many new candidates complete a profile, run a search and apply within a week, split by acquisition source and by city. Then you find the biggest drop off point and make a case for what should change about it.
What you get out of it
Product analytics is mostly the discipline of asking a smaller question than the one you were handed. You will practise that with a product manager who pushes back on your framing every single time you present. By the end you will have a documented activation metric, a cohort dashboard the product team checks weekly, and one experiment recommendation with the analysis behind it.
Remote from anywhere in India, with a standing check in every morning at eleven. Open to final year students and recent graduates, and you should already be able to write a grouped query with a filter on the aggregate without looking it up.
Responsibilities
- Define the candidate activation event and get that definition agreed across teams
- Build seven day cohort analysis in SQL over the product event tables
- Segment activation by acquisition source and by city
- Identify the largest first week drop off and quantify what it costs
- Present one experiment recommendation with the supporting analysis
Requirements
- Final year student or recent graduate, no prior work experience needed
- Can write grouped aggregate queries with filters on aggregates unaided
- Available for a fixed morning check in each day while working remotely
- Willing to have your framing challenged and to revise it
Skills
Benefits
- A short, sharply defined project with a visible outcome inside eight weeks
- Daily access to the product manager who owns activation
- Completion certificate with written feedback
- Work remotely from anywhere in India