Data Analyst Intern

About Bayside Strategies:

Headquartered in Melbourne, the firm is employee-owned. Bayside Strategies is a management and technology consulting firm with 450 employees worldwide.

The internship:

This role is about accuracy first. A wrong number in a report is worse than a late one. Remote, open to candidates across Australia. A quiet workspace and good internet are required.

Responsibilities:

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Check numbers across sources and flag mismatches before reports go out.
• Create charts and short slide decks for the monthly review call.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Answer ad hoc data requests from sales and support within a day or two.
• Analyse funnel drop-offs and summarise findings in a one-page note.

What we're looking for:

• Available for the full internship period.
• Eligible to work in Australia.
• Based in Australia for the duration of the internship.
• Currently enrolled in a bachelor's or master's degree, graduating 2027.
• Available 20 to 40 hours a week, Monday to Friday.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Must be able to follow up on data requests without constant reminders.
• A sample dashboard or analysis project you can share.

What you get out of it:

• You will build at least one dashboard that managers use every week.
• Top interns are considered for a junior analyst opening.

Duration: 3 months

Start date: Immediately

Stipend: $26.00 - $33.00 per hour

Perks:

• Mentoring from an experienced team member.
• Access to online training.
• Paid holiday accrued during the placement.

Applications close when we find the right person, so get in early.

Duration: 3 months. Start: Immediately.

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