Product Analytics Intern

ABOUT GARCIA ADVERTISING:

Everyone writes, everyone pulls reports, and everyone sits in on client calls. Our clients usually talk directly to the person doing the work.

OVERVIEW:

Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote within the US. The team meets in Los Angeles once a quarter, travel covered. Normal working hours, Monday to Friday. You need a reliable internet connection and somewhere quiet to work.

RESPONSIBILITIES:

• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Track marketing campaign results using Google Analytics 4 data
• Join a weekly call with the analytics lead to review your work
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Analyse funnel drop-offs and summarise findings in a one-page note

REQUIREMENTS:

• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Currently enrolled in a bachelor's or master's program, graduating 2026 or 2027
• Must be able to follow up on data requests without constant reminders
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2026 or 2027
• Clear written English for reports and status updates

WHAT YOU GET OUT OF IT:

• Writing SQL against a real production warehouse
• Top interns are considered for a junior analyst opening
• Certificate, letter of recommendation and flexible hours

Duration: 6 months

Start date: Immediately

Stipend: $31.00 - $34.00 per hour

PERKS:

• Home office setup stipend
• Learning and development stipend
• Company laptop

We are unable to sponsor visas for this position.

Duration: 6 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Garcia Advertising, LLC.