Business Analytics Intern

Internship details

Most of the job is SQL, Excel and Power BI. You will answer questions from managers with numbers and a short explanation. As an intern, you will:

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

2. Track marketing campaign results using Google Analytics 4 data

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

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

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

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

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

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

Skill(s) required: MS-Excel, Statistics, Google Sheets, Power BI, Looker Studio

Eligibility

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

2. Available for a full-time (work from home) internship for the full duration

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

4. Own a laptop and have stable internet at home

Stipend: ₹20,000-₹27,000 monthly

Duration: 6 months

Start date: Within 2 weeks

Perks: Flexible work hours, Internet allowance, Pre-placement offer (PPO) for strong performers, Mentorship from senior team members, 5 days a week

Number of openings: 2

About Mayhew IT

Headquartered in Ahmedabad, the company has grown since 1988 by acquiring regional IT providers.

Please submit your CV in English.

Duration: 6 months. Start: Within 2 weeks.

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