Excel & Data Analysis Intern

About Ganga Insurance:

Since 1999, the agency has placed crop and farm coverage across Maharashtra. Third-party administration is the other half of the business, processing self-funded health claims. We started in 1999 and have grown to about 80 people.

The internship:

Remote internship for a student who likes spreadsheets and is not scared of messy data. This role is fully remote within India. Normal working hours, Monday to Friday.

What you'll do:

• Create charts and short slide decks for the monthly review call
• 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
• 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
• 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
• Maintain the data dictionary and keep dashboard filters up to date

What we're looking for:

• Can start immediately or within two weeks
• Women returning to work after a career break are welcome to apply
• Comfort with numbers and strong attention to detail
• Some familiarity with Power BI or Tableau, even from a course or certification
• Must be able to follow up on data requests without constant reminders
• Basic SQL, enough to write SELECT queries with joins and filters
• Clear written English for reports and status updates

Preferred:

• Knowledge of basic statistics such as medians, percentiles and correlation
• Experience with Google Analytics 4 or Mixpanel
• Google Data Analytics or Microsoft PL-300 certification

Duration: 3 months

Start date: Immediately

Stipend: ₹21,000 - ₹24,000 per month

What we offer:

• Mentorship from senior team members
• Letter of recommendation
• Flexible work hours

Please include your notice period and salary expectations.

Duration: 3 months. Start: Immediately.

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