SQL Data Analyst Intern

About the internship

This role is about accuracy first. A wrong number in a report is worse than a late one. Selected intern's day-to-day responsibilities include:

1. Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.

2. Analyse funnel drop-offs and summarise findings in a one-page note

3. Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables

4. Join a weekly call with the analytics lead to review your work

5. Document metric definitions so everyone calculates churn and conversion the same way.

6. Track marketing campaign results using Google Analytics 4 data.

7. Prepare the weekly MIS report and send it to the team lead every Monday.

8. Maintain the data dictionary and keep dashboard filters up to date

Skill(s) required: English Proficiency (Written), Python, SQL, MS-Excel, Looker Studio

Who can apply

1. Own laptop and a reliable internet connection

2. Based in Sri Lanka

3. Available for the full internship period

Stipend: LKR 75,000 - LKR 80,000 pcm (fixed)

Duration: 4 months | Start date: Immediately

Perks: Laptop provided for the internship, Letter of recommendation, Job offer on successful completion, Flexible work hours, Mentorship from senior team members, 5 days a week

Number of openings: 10

About Cedarloft Labs

Cedarloft Labs employs 540 people across engineering hubs in Seattle and three other locations, building ERP software for mid-market manufacturers. Annual releases gave way to two-week sprints years ago, and the platform now handles over 200 million API calls a day.

Please submit your CV in English.

Duration: 4 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Cedarloft Labs LLC.