Business Intelligence Placement

We employ 660 people across underwriting, claims, actuarial, IT and customer service. EMN Benefits is a property and casualty insurer writing policies in 30 states through independent agents.

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. The company is based in Columbus, the US. We are a distributed team spread across a few time zones. The internship is fully remote. Interns join our Columbus team on daily calls and get a named mentor. Core hours are 9:00 AM to 1:00 PM US Eastern.

Responsibilities

• Prepare the weekly MIS report and send it to the team lead every Monday.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• 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.
• Maintain the data dictionary and keep dashboard filters up to date.
• Create charts and short slide decks for the monthly review call.
• Join a weekly call with the analytics lead to review your work.

Requirements

• Eligible to work in Italy.
• Based in Italy for the duration of the internship.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Available 20 to 40 hours a week, Monday to Friday.
• Comfort with numbers and strong attention to detail.
• Laptop with Excel or Google Sheets and a stable internet connection.

Bonus points

• Python with pandas for data cleaning.
• Familiarity with DAX in Power BI.
• Prior project with real business data from a college club, family business or freelance client.

What you'll learn

• Certificate, letter of recommendation and flexible hours.
• Presenting numbers in a way non-technical people can act on.
• Top interns are considered for a junior analyst opening.
• Writing SQL against a real production warehouse.

Duration: 4 months

Start date: Dec 2026

Stipend: $1,850 - $2,350 per month

What we offer

• Company laptop.
• Flexible hours.
• Certificate of completion.
• Online learning budget.
• Possibility of a full-time offer.

Duration: 4 months. Start: Dec 2026.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at EMN Benefits LLC.