Business Analyst Intern - Spring 2027

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 Spring 2027. This role is about accuracy first. A wrong number in a report is worse than a late one. Remote within the US. The team meets in New York City once a quarter, travel covered. Few meetings, lots of written updates. You will write a lot of updates, so clear written English is important.

Your projects

• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• 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.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Join a weekly call with the analytics lead to review your work.
• Create charts and short slide decks for the monthly review call.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Maintain the data dictionary and keep dashboard filters up to date.

What we're looking for

• Currently enrolled in a bachelor's or master's program, graduating between December 2027 and June 2028.
• Based in the US for the duration of the internship.
• Must be able to follow up on data requests without constant reminders.
• Comfort with numbers and strong attention to detail.
• Clear written English for reports and status updates.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• A sample dashboard or analysis project you can share.

Preferred qualifications

• Google Data Analytics or Microsoft PL-300 certification.
• Python with pandas for data cleaning.

What you get out of it

• You will build at least one dashboard that managers use every week.
• Top interns are considered for a junior analyst opening.
• Presenting numbers in a way non-technical people can act on.

Program dates: Spring 2027, 4 months.

Intern pay: $35.00 - $45.00 per hour

What we offer

• Paid sick time.
• Paid company holidays.
• Mentorship from a dedicated buddy and manager.

Ferrycrest Mutual is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.

Interview process: a phone call, a meeting with the hiring manager, and a final conversation with the team.

Duration: 4 months. Start: Spring 2027.

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