SQL Data Analyst Intern

Agents, brokers and direct customers all buy through our platforms, with policy administration on Guidewire.

The internship

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Our headquarters is in Boulder, and about a third of the team works remotely from other countries. Remote internship with a team based in Boulder. The stipend is paid at the end of each month. Core hours overlap with US Central time, 9:00 AM to 1:00 PM CT. Reliable internet and a power backup are a must.

Responsibilities

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Create charts and short slide decks for the monthly review call
• Maintain the data dictionary and keep dashboard filters up to date
• Track marketing campaign results using Google Analytics 4 data
• Answer ad hoc data requests from sales and support within a day or two
• Analyse funnel drop-offs and summarise findings in a one-page note
• Join a weekly call with the analytics lead to review your work

Who can apply

• Based in Sri Lanka
• Available for the full internship period
• Undergraduates or recent graduates in IT, computer science, management or a related field
• Basic SQL, enough to write SELECT queries with joins and filters
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts
• Available 20 to 40 hours a week, Monday to Friday
• Comfort with numbers and strong attention to detail

Preferred

• Familiarity with DAX in Power BI

What you'll learn

• Top interns are considered for a junior analyst opening
• Certificate, letter of recommendation and flexible hours
• You will build at least one dashboard that managers use every week
• How business metrics like CAC, churn and retention are actually calculated

Duration: 2 months

Start date: Immediately

Stipend: $250 - $300/month

Perks

• Mentorship from senior team members
• Performance bonus
• Certificate
• Internet allowance

We review applications as they come in.

Duration: 2 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Quayside Insurance Agency.