Data Analyst Intern

WHO WE ARE

Regional offices in Gold Coast and five other cities support agents and policyholders. Our claims organisation handles more than 400,000 claims a year, including catastrophe response after hurricanes and hail.

OVERVIEW

This role is about accuracy first. A wrong number in a report is worse than a late one. You can work from home anywhere in Australia. We have no office requirement. We keep meetings to a minimum and work mostly async.

WHAT YOU'LL DO

• Answer ad hoc data requests from sales and support within a day or two.
• Check numbers across sources and flag mismatches before reports go out.
• Join a weekly call with the analytics lead to review your work.
• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.

WHO CAN APPLY

• Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028.
• Based in Australia for the duration of the internship.
• Available for the full internship period.
• Available 20 to 40 hours a week, Monday to Friday.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Basic SQL, enough to write SELECT queries with joins and filters.

WHAT YOU GET OUT OF IT

• How business metrics like CAC, churn and retention are actually calculated.
• Certificate, letter of recommendation and flexible hours.
• You will build at least one dashboard that managers use every week.

Duration: 5 months

Start date: Jan 2027

Stipend: $3,800 - $4,000 pcm

PERKS

• Access to online training.
• Mentoring from an experienced team member.
• Laptop provided.
• Home working allowance.

Duration: 5 months. Start: Jan 2027.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Gold Coast Risk Advisors Pty Ltd.