Business Analyst Intern

About the internship

Remote internship for a student who likes spreadsheets and is not scared of messy data. Your day-to-day work will include:

1. Prepare the weekly MIS report and send it to the team lead every Monday

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

3. Create charts and short slide decks for the monthly review call

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

5. Build and update dashboards in Power BI, Tableau or Looker Studio

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

7. Join a weekly call with the analytics lead to review your work

8. Answer ad hoc data requests from sales and support within a day or two

Skill(s) required: Python, English Proficiency (Written), Looker Studio, Google Sheets, Power BI

Eligibility

1. Women starting or restarting their careers are encouraged to apply

2. Are able to join within 15 days

Stipend: ₹18,000 - ₹26,000/month + performance bonus

Duration: 2 months | Start date: Immediately

Perks: Certificate, Informal dress code, Performance bonus, Letter of recommendation

Number of openings: 5

About the company

Second-generation ownership: the founder's daughter runs the agency now. We have been writing policies for the same farms and small businesses since 1952. Family owned and operated since 1952.

Duration: 2 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Arora Mutual Pvt Ltd.