Analytics Intern

About Ridgeview Mutual Insurance:

Ridgeview Mutual Insurance is a property and casualty insurer writing policies in 30 states through independent agents.

Overview:

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. You can work from home anywhere in the US. We have no office requirement. Normal business hours, Monday to Friday, with some flexibility.

Day to day:

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables
• Document metric definitions so everyone calculates churn and conversion the same way
• Track marketing campaign results using Google Analytics 4 data
• Build and update dashboards in Power BI, Tableau or Looker Studio
• Analyse funnel drop-offs and summarise findings in a one-page note
• Maintain the data dictionary and keep dashboard filters up to date
• Check numbers across sources and flag mismatches before reports go out
• Prepare the weekly MIS report and send it to the team lead every Monday

Requirements:

• Currently enrolled in a bachelor's or master's program, graduating 2028
• Available 40 hours a week for the full internship
• Based in the US for the duration of the internship
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Clear written English for reports and status updates
• Must be able to follow up on data requests without constant reminders
• Comfort with numbers and strong attention to detail

Bonus points:

• Python with pandas for data cleaning
• Knowledge of basic statistics such as medians, percentiles and correlation
• Prior project with real business data from a college club, family business or freelance client

Duration: 5 months

Start date: Mar 2027

Stipend: $32.50 - $39.50 an hour

What we offer:

• Company laptop
• Intern events and speaker sessions (virtual)
• Mentorship from a dedicated buddy and manager

No recruitment agencies, please.

Duration: 5 months. Start: Mar 2027.

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