Excel & Data Analysis Intern

Internship details

Eastern Technologies needs a data analytics intern to build reports and dashboards for the Revenue Operations team. Selected intern's day-to-day responsibilities include:

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

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

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

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

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

6. Track marketing campaign results using Google Analytics 4 data

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

Skill(s) required: Tableau, SQL, Power BI

Who should apply

1. Own a laptop and have stable internet at home

2. Can commit full time, from home, for the whole internship

3. Women returning to work after a career break are welcome to apply

4. Are able to join within 15 days

Stipend: $450 - $550 per month (fixed)

Duration: 6 months | Start date: Within 2 weeks

Perks: Flexible work hours, Job offer on successful completion, Free access to paid learning courses, Performance bonus

Number of openings: 8

About the company

Product, engineering and support teams work out of offices in Sydney, New South Wales and two nearshore delivery centres.

We review applications as they come in.

Duration: 6 months. Start: Within 2 weeks.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Eastern Technologies Pty Ltd.