Insight Analyst Intern

Who we are

We operate two 24/7 network operations centres and a security operations centre, staffed in three shifts.

About the role

Pinehaven needs a data analytics intern to build reports and dashboards for the Revenue Operations team. Remote internship with a team based in San Diego. 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

• 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
• Track marketing campaign results using Google Analytics 4 data
• Answer ad hoc data requests from sales and support within a day or two
• Join a weekly call with the analytics lead to review your work
• Analyse funnel drop-offs and summarise findings in a one-page note
• Check numbers across sources and flag mismatches before reports go out
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query

What we're looking for

• Eligible to work in South Korea
• Available for the full internship period
• Based in South Korea for the duration of the internship
• Currently enrolled in a bachelor's or master's degree, graduating 2028
• A sample dashboard or analysis project you can share
• Basic SQL, enough to write SELECT queries with joins and filters
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Clear written English for reports and status updates
• Some familiarity with Power BI or Tableau, even from a course or certification
• Available 20 to 40 hours a week, Monday to Friday

Preferred

• Knowledge of basic statistics such as medians, percentiles and correlation
• Experience with Google Analytics 4 or Mixpanel

What you'll learn

• Top interns are considered for a junior analyst opening
• Writing SQL against a real production warehouse

Duration: 6 months

Start date: Jul 2027

Stipend: ₩2,600,000 - ₩3,200,000 monthly

Perks

• Company laptop
• Possibility of a full-time offer
• Letter of recommendation
• Mentorship

Duration: 6 months. Start: Jul 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Pinehaven, Inc..