Excel & Data Analysis Intern

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

Internship overview

Winchbridge Insurance is hiring an Excel & Data Analysis Intern for Immediately. Winchbridge Insurance needs a data analytics intern to build reports and dashboards for the Growth Analytics team. The company is based in Washington, the US. Our team works from several countries. This is a remote internship. You will work with our team in Washington, and the stipend is paid monthly in Indian rupees. Core hours are 9:00 AM to 1:00 PM US Eastern. We use Slack, Notion and Google Meet. Cameras on for team calls.

Your projects

• Track marketing campaign results using Google Analytics 4 data.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Check numbers across sources and flag mismatches before reports go out.
• 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.

What we're looking for

• Women starting or restarting their careers are encouraged to apply.
• Have their own laptop and a reliable internet connection.
• Basic SQL, enough to write SELECT queries with joins and filters.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• Laptop with Excel or Google Sheets and a stable internet connection.

Preferred qualifications

• Familiarity with DAX in Power BI.

What you get out of it

• Writing SQL against a real production warehouse.
• Presenting numbers in a way non-technical people can act on.
• How business metrics like CAC, churn and retention are actually calculated.
• Top interns are considered for a junior analyst opening.

Program dates: Immediately, 6 months.

Compensation: ₹46,000 - ₹49,000 monthly

Benefits for interns

• Letter of recommendation.
• Job offer on successful completion.
• 5 days a week.
• Flexible work hours.

This posting may close early if we receive enough applications.

Duration: 6 months. Start: Immediately.

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