Data Analyst Intern

About us:

Volunteers deliver meals, tutor students, sort donations and staff the front desk. We provide emergency shelter, rapid rehousing and case management for families experiencing homelessness. Founded in 1978, we now have 60 employees. The office closes the week between Christmas and New Year's.

Overview:

Remote internship for a student who likes spreadsheets and is not scared of messy data. You can work from home anywhere in Australia. We have no office requirement. Normal working hours, Monday to Friday. You will need a reliable internet connection and a quiet place to work.

Day to day:

• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Build and update dashboards in Power BI, Tableau or Looker Studio.
• Automate repetitive spreadsheet tasks with Python, Apps Script or Power Query.
• Maintain the data dictionary and keep dashboard filters up to date.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Analyse funnel drop-offs and summarise findings in a one-page note.

What we're looking for:

• Based in Australia for the duration of the internship.
• Available for the full internship period.
• Eligible to work in Australia.
• Currently enrolled in a bachelor's or master's degree, graduating 2027 or 2028.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Comfort with numbers and strong attention to detail.
• Clear written English for reports and status updates.
• Good Excel skills: pivot tables, lookups, conditional formatting and basic charts.
• Some familiarity with Power BI or Tableau, even from a course or certification.
• A sample dashboard or analysis project you can share.

What you get out of it:

• Top interns are considered for a junior analyst opening.
• Writing SQL against a real production warehouse.

Duration: 3 months

Start date: Mar 2027

Stipend: $28.00 to $30.00 p/h

What we offer:

• Home working allowance.
• Mentoring from an experienced team member.
• Graduate scheme fast-track interview.
• Flexible working hours.
• Access to online training.

Duration: 3 months. Start: Mar 2027.

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