SQL Data Analyst Intern

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

INTERNSHIP OVERVIEW

Pinehaven is hiring an SQL Data Analyst Intern for Within 2 weeks. Pinehaven needs a data analytics intern to build reports and dashboards for the Business Intelligence team. Our team is spread across 11 countries. Headquarters is in San Diego. You will intern remotely with our team in San Diego. We have hosted remote interns from several countries before. You will need at least 3 hours of overlap with US Pacific time. Equipment is provided, including a laptop.

RESPONSIBILITIES

• Prepare the weekly MIS report and send it to the team lead every Monday.
• Create charts and short slide decks for the monthly review call.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Check numbers across sources and flag mismatches before reports go out.
• Join a weekly call with the analytics lead to review your work.
• Answer ad hoc data requests from sales and support within a day or two.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.

WHO YOU ARE

• Based in Sri Lanka.
• Available for the full internship period.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• A sample dashboard or analysis project you can share.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Available 20 to 40 hours a week, Monday to Friday.

NICE TO HAVE

• Familiarity with DAX in Power BI.
• Prior project with real business data from a college club, family business or freelance client.
• Knowledge of basic statistics such as medians, percentiles and correlation.

WHAT YOU GET OUT OF IT

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

Program dates: Within 2 weeks, 1 month.

Pay: $200 - $300 monthly

BENEFITS FOR INTERNS

• Letter of recommendation.
• Laptop provided for the internship.
• Job offer on successful completion.
• Mentorship from senior team members.
• Internet allowance.
• Flexible work hours.

We will only contact shortlisted applicants.

Duration: 1 month. Start: Within 2 weeks.

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