Business Analyst Intern

Catastrophe teams deploy adjusters within days of a major storm. January renewals keep everyone busy for a few weeks.

About the internship

Ferrycrest Mutual is hiring a Business Analyst Intern for Summer 2027. Remote internship for a student who likes spreadsheets and is not scared of messy data. Remote within the US. The team meets in New York City once a quarter, travel covered. Flexible hours with a daily team call in the morning. You will write a lot of updates, so clear written English is important.

What you'll do

• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query
• Create charts and short slide decks for the monthly review call
• 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
• Document metric definitions so everyone calculates churn and conversion the same way

What we're looking for

• Based in the US for the duration of the internship
• Authorized to work in the US. CPT and OPT candidates are welcome to apply
• Must be able to follow up on data requests without constant reminders
• Clear written English for reports and status updates
• A sample dashboard or analysis project you can share

Preferred qualifications

• Familiarity with DAX in Power BI

What you'll learn

• How business metrics like CAC, churn and retention are actually calculated
• Top interns are considered for a junior analyst opening

Program dates: Summer 2027, 12 weeks.

Intern pay: $37.50 - $39.50/hr

Perks

• Final presentation to leadership
• Flexible hours
• Return offer opportunities
• Company laptop

We are an equal opportunity employer. If you need an accommodation during the application process, let us know.

Duration: 12 weeks. Start: Summer 2027.

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