Excel & Data Analysis Intern

About the work from home internship

SR Technology Group needs a data analytics intern to build reports and dashboards for the Analytics team. Your day-to-day work will include:

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

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

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

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

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

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

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

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

Skill(s) required: Google Sheets, Python, Tableau, Looker Studio, MS-Excel, Statistics, SQL

Eligibility

1. Own a laptop and have stable internet at home

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

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

Stipend: ₹19,000 - ₹24,000/month + performance bonus

Duration: 3 months | Start date: Within 2 weeks

Perks: Internet allowance, Letter of recommendation, Job offer on successful completion, Certificate, Pre-placement offer (PPO) for strong performers, Laptop provided for the internship

Number of openings: 3

About SR Technology Group

Started by a former school district network admin in 2019, the business has grown almost entirely through referrals. We support about 60 local businesses, most within 30 minutes of the office.

Duration: 3 months. Start: Within 2 weeks.

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