AI Insights & Automation Analyst (18-Month Contract)

Wesfarmers Health; Melbourne; On-site; AUD 90,000 - 130,000; Full time

Benefits offered by this job

Employee discounts

Professional development

Novated leasing

EAP

Onsite gym

Job summary

Wesfarmers Health in Australia is seeking an Insights & Automation Analyst to join the Merchandise Central team on an 18-month maximum-term contract. You will transform how Merchandise operates by implementing AI, automation and data-driven insights.

You'll collaborate across Buying, Space Planning, Trade Planning and Suppliers, design AI-powered Copilot agents, automate processes with Power Automate, and develop Power BI dashboards to deliver a single source of truth.

Qualifications

• Proven experience in reporting, analytics or business intelligence.
• Retail or FMCG experience desirable.
• Hands-on experience with AI tools, automation or AI-enabled process improvement.
• Hands-on experience building dashboards and reports in Power BI.
• Exposure to Power Query, Power Automate or SQL desirable.
• Hands-on experience using AI tools such as Copilot or Claude.
• Exposure to building or configuring AI agents or Copilot-based solutions.
• Degree in Business, Commerce, Data Analytics, Information Systems or a related discipline.

Responsibilities

• Identify high-value opportunities to apply AI and automation across Merchandise functions.
• Design and build business-facing AI agents using Microsoft Copilot to support reporting, analysis and decision-making.
• Re-engineer manual and repetitive processes using Power Automate, Power Query and AI-enabled solutions.
• Drive adoption of AI tools and automation across teams by championing practical use cases.
• Develop and maintain Power BI dashboards, reports and performance metrics.
• Establish scalable reporting frameworks that support a single source of truth.
• Build and maintain supplier scorecards, productivity dashboards and performance reporting.
• Analyse promotional performance, forecast accuracy and trade investment effectiveness.

Skills

BI reporting

AI tools

Automation

Power BI

Copilot/AI agents

SQL familiarity

Education

Bachelor’s degree in Business/Commerce/Data Analytics/IS

Tools

Power BI

Power Query

Power Automate

SQL

Copilot

Job description

Wesfarmers Health in Australia is seeking an Insights & Automation Analyst to join the Merchandise Central team on an 18-month maximum-term contract. You will transform how Merchandise operates by implementing AI, automation and data-driven insights.

You'll collaborate across Buying, Space Planning, Trade Planning and Suppliers, design AI-powered Copilot agents, automate processes with Power Automate, and develop Power BI dashboards to deliver a single source of truth.