Data Analyst Intern

About Winchbridge Insurance:

We employ 49,500 people across underwriting, claims, actuarial, IT and customer service.

Overview:

Winchbridge Insurance needs a data analytics intern to build reports and dashboards for the Analytics team. Our headquarters is in Washington, and about a third of the team works remotely from other countries. Remote internship with a team based in Washington. The stipend is paid at the end of each month. Expect to work a schedule that overlaps with US Eastern business hours until about noon ET. You get a company laptop and a headset before you start.

Day to day:

• 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.
• Answer ad hoc data requests from sales and support within a day or two.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Check numbers across sources and flag mismatches before reports go out.

Requirements:

• Available for the full internship period.
• Based in Portugal for the duration of the internship.
• Currently enrolled in a bachelor's or master's degree, graduating 2028.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• A sample dashboard or analysis project you can share.
• Pursuing a degree in Statistics, Economics, Commerce, Engineering, Computer Science or a related field, graduating in 2028.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Comfort with numbers and strong attention to detail.
• Clear written English for reports and status updates.

What you'll learn:

• You will build at least one dashboard that managers use every week.
• Writing SQL against a real production warehouse.

Duration: 12 months

Start date: Summer 2027

Stipend: €1,050 - €1,350/month

What we offer:

• Certificate of completion.
• Internet allowance.
• Mentorship.
• Possibility of a full-time offer.
• Letter of recommendation.
• Company laptop.

Only shortlisted candidates will be contacted.

Duration: 12 months. Start: Summer 2027.

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