Excel & Data Analysis Intern

About the internship

This role is about accuracy first. A wrong number in a report is worse than a late one. Selected intern's day-to-day responsibilities include:

1. Analyse funnel drop-offs and summarise findings in a one-page note.

2. Document metric definitions so everyone calculates churn and conversion the same way.

3. Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query

4. Track marketing campaign results using Google Analytics 4 data.

5. Check numbers across sources and flag mismatches before reports go out

6. Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.

7. Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.

8. Maintain the data dictionary and keep dashboard filters up to date.

Skill(s) required: Python, Data Analytics, Google Sheets, Statistics, SQL, Looker Studio

Who can apply

1. Can start immediately or within two weeks

2. Students currently pursuing B.Tech, BE, BCA, MCA, B.Sc or a related degree, or fresh graduates (2027 batch)

3. Women wanting to start or restart their career can also apply

4. Are available for a full-time work from home internship for the entire duration

Stipend: $500 - $530/month

Duration: 6 months

Start date: Immediately

Perks: Internet allowance, Informal dress code, Certificate, Pre-placement offer (PPO) for strong performers, Job offer on successful completion

Number of openings: 5

About the company

Customers use our platform to manage equipment rentals: reservations, check-out, damage photos, invoicing and QuickBooks sync. The product is a mobile app plus a React web dashboard, with a Python and PostgreSQL backend on AWS. On-call rotates weekly and pays a flat stipend whether or not the pager goes off.

Duration: 6 months. Start: Immediately.

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