Insight Analyst

Job Title: Insight Analyst

Location: Melbourne

Salary: $93,000 - $104,000 pa

Hours: 39 hours per week

Contract: Permanent, full-time

Second-generation ownership: the founder's daughter runs the agency now. We have been writing policies for the same farms and small businesses since 2003. Licensing (property and casualty, life and health) is paid for, with study time during work hours.

The position:

Analyst role with a mix of recurring reporting and project work. Most of your day will be in SQL, Excel and Power BI or Tableau. This is an in-person role at our Melbourne location.

Essential duties and responsibilities:

• Write SQL queries against the data warehouse to pull and join data for analysis.
• Investigate data quality issues and work with data engineering to fix them at the source.
• Field ad hoc requests through a ticket queue and prioritise them with your manager.
• Automate recurring Excel reports with Power Query, Python or scheduled SQL.
• Prepare weekly and monthly KPI reports for department leads.
• Clean and reconcile data from CRM, ERP and spreadsheet sources.
• Create forecasts and simple models in Excel or Google Sheets.

What we're looking for:

• 2+ years of experience in a data or reporting analyst role.
• Clear written and verbal communication with non-technical stakeholders.
• Basic statistics: averages vs. medians, distributions, significance.
• Strong SQL (joins, CTEs, aggregations, window functions)
• Able to juggle several requests and say when a deadline isn't realistic.
• Bachelor's degree in statistics, economics, business, math or a related field.

Benefits:

• Above-award pay rates.
• 17.5% leave loading.
• Annual bonus.
• Employee assistance program.

Shortlisting will begin immediately.

Start: Within 30 days.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Melbourne Insurance Group.