Analytics Intern

Who we are:

Commercial lines, personal lines and specialty programs are run as separate business units. Smith Underwriters is a property and casualty insurer writing policies in 30 states through independent agents.

The internship:

This role is about accuracy first. A wrong number in a report is worse than a late one. Fully remote. You can work from anywhere in the US. Hours are flexible, with one short team call each morning. A quiet workspace and good internet are required.

Responsibilities:

• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery
• Prepare the weekly MIS report and send it to the team lead every Monday
• Analyse funnel drop-offs and summarise findings in a one-page note
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables

Who can apply:

• Available 40 hours a week for the full internship
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• A sample dashboard or analysis project you can share
• Some familiarity with Power BI or Tableau, even from a course or certification
• Laptop with Excel or Google Sheets and a stable internet connection

What you get out of it:

• Certificate, letter of recommendation and flexible hours
• Presenting numbers in a way non-technical people can act on
• How business metrics like CAC, churn and retention are actually calculated

Duration: 10-12 weeks

Start date: May 2027

Stipend: $29.50 - $39.50 per hour

What we offer:

• Paid sick time
• Home office setup stipend
• Paid company holidays
• Flexible hours
• Mentorship from a dedicated buddy and manager
• Return offer opportunities

Duration: 10-12 weeks. Start: May 2027.

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