Analytics Intern

Our claims organization handles more than 400,000 claims a year, including catastrophe response after hurricanes and hail. We close at 3 p.m. on Fridays in the summer.

About the role

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. Fully remote. You can work from anywhere in the US. Normal working hours, Monday to Friday. Good written English matters here, since most updates are written.

What you'll do

• Join a weekly call with the analytics lead to review your work
• Create charts and short slide decks for the monthly review call
• Track marketing campaign results using Google Analytics 4 data
• Maintain the data dictionary and keep dashboard filters up to date
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Check numbers across sources and flag mismatches before reports go out

Who can apply

• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Based in the US for the duration of the internship
• Available 40 hours a week for the full internship
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2026 or 2027
• Laptop with Excel or Google Sheets and a stable internet connection
• Clear written English for reports and status updates

What you'll learn

• Writing SQL against a real production warehouse
• You will build at least one dashboard that managers use every week
• How business metrics like CAC, churn and retention are actually calculated
• Top interns are considered for a junior analyst opening

Duration: 3 months

Start date: Immediately

Stipend: $33.50 - $39.00/hr

Perks

• Company laptop
• Return offer opportunities
• Home office setup stipend
• Mentorship from a dedicated buddy and manager
• Paid sick time
• Final presentation to leadership

Duration: 3 months. Start: Immediately.

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