Business Intelligence Intern

Everyone writes, edits, takes photos and posts to the website. We have been family run since 1992. Most reporters cover more than one beat.

About the role:

This role is about accuracy first. A wrong number in a report is worse than a late one. The company is based in Sydney, Australia. We are a distributed team spread across a few time zones. You will intern remotely with our team in Sydney. We have hosted remote interns from several countries before. You will need some overlap with Australian Eastern time in the mornings. Please make sure you have a quiet place to work and a solid internet connection.

What you'll do:

• Clean and merge data in Excel or Google Sheets using VLOOKUP, XLOOKUP and pivot tables.
• Prepare the weekly MIS report and send it to the team lead every Monday.
• Document metric definitions so everyone calculates churn and conversion the same way.
• Join a weekly call with the analytics lead to review your work.
• Create charts and short slide decks for the monthly review call.
• Analyse funnel drop-offs and summarise findings in a one-page note.
• Write SQL queries to pull sales, order and customer data from PostgreSQL or BigQuery.

Who can apply:

• Authorized to work in the US. CPT and OPT candidates are welcome to apply.
• Based in the US for the duration of the internship.
• Available 40 hours a week for the full internship.
• Available 20 to 40 hours a week, Monday to Friday.
• Laptop with Excel or Google Sheets and a stable internet connection.
• Must be able to follow up on data requests without constant reminders.

Nice to have:

• Knowledge of basic statistics such as medians, percentiles and correlation.
• Familiarity with DAX in Power BI.

What you'll learn:

• You will build at least one dashboard that managers use every week.
• How business metrics like CAC, churn and retention are actually calculated.
• Presenting numbers in a way non-technical people can act on.

Duration: 5 months

Start date: Jan 2027

Stipend: $30.00-$37.50/hr

What we offer:

• Company laptop.
• Learning and development stipend.
• Paid company holidays.

Apply with your resume. A cover letter is optional.

Duration: 5 months. Start: Jan 2027.

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