Data Analytics Intern

Who we are:

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

Overview:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. You will intern remotely with our team in San Diego. We have hosted remote interns from several countries before. Our standups are at 9:00 AM Pacific. You will need a stable internet connection and a backup power source (UPS or inverter).

Day to day:

• Maintain the data dictionary and keep dashboard filters up to date
• Document metric definitions so everyone calculates churn and conversion the same way
• 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
• Create charts and short slide decks for the monthly review call
• Analyse funnel drop-offs and summarise findings in a one-page note
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery

What we're looking for:

• Are able to join within 15 days
• Own a laptop and have stable internet at home
• Can commit full time, from home, for the whole internship
• Clear written English for reports and status updates
• Laptop with Excel or Google Sheets and a stable internet connection
• Basic SQL, enough to write SELECT queries with joins and filters
• Comfort with numbers and strong attention to detail
• Some familiarity with Power BI or Tableau, even from a course or certification
• Available 20 to 40 hours a week, Monday to Friday

What you'll learn:

• Certificate, letter of recommendation and flexible hours
• How business metrics like CAC, churn and retention are actually calculated

Duration: 3 months

Start date: Immediately

Stipend: $500 - $600 monthly

What we offer:

• Free access to paid learning courses
• Informal dress code
• Performance bonus

Please mention your notice period and expected salary.

Duration: 3 months. Start: Immediately.

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