Insights & Automation Analyst

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

At Wesfarmers Health we strive to make health, beauty and wellness experiences simpler, more affordable and easier to access for all Australians.

Our portfolio includes well-known names like Priceline, Australian Pharmaceutical Industries, as well as our MediAesthetics brands - Clear Skincare Clinics and SILK Laser Clinics. In the digital space, we're proud to have SISU Health and InstantScripts—and most recently, we've launched our newest retail beauty stores, atomica.

About us:

What began in 1910 as a small co-operative of just three pharmacies has grown into Wesfarmers Health—a leading Australian organisation in health, beauty, and wellness.

Today, Wesfarmers Health proudly employs over 3,600 team members, all committed to delivering accessible, innovative, and trusted health and beauty services to Australians nationwide, across retail, medi-aesthetics, digital health, and wholesale and supply chain operations.

What you'll do:

We are seeking an Insights & Automation Analyst to join our Merchandise Central team on an 18-month maximum-term contract. Reporting to the Senior Manager - Merchandise Initiatives, you'll play a pivotal role in transforming how Merchandise teams work through the innovative use of AI, automation and data-driven insights.

Working across Buying, Space Planning, Trade Planning, Strategic Supplier, Merchandise Planning and Merchandise Initiatives, you'll identify opportunities to simplify complex processes, build AI-powered solutions using Microsoft Copilot, create insightful reporting, and help drive a smarter, more efficient way of working.

This is an exciting opportunity for someone who enjoys solving business problems, embracing emerging technologies and making a tangible impact through AI-enabled innovation.

Key activities include:

• 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

What you'll bring:

• Proven experience in reporting, analytics or business intelligence, including internships, placements or early-career roles
• Retail or FMCG experience is desirable but not essential
• Hands-on experience with AI tools, automation or AI-enabled process improvement (e.g. using Copilot, building simple agents or workflows, or automating a manual task) is necessary
• Hands-on experience building dashboards and reports in Power BI
• Exposure to Power Query, Power Automate or SQL is desirable
• Hands-on experience using AI tools such as Copilot or Claude, with the ability to apply them to build practical solutions, not just day-to-day tasks
• Exposure to building or configuring AI agents or Copilot-based solutions (e.g. Copilot Studio) is highly regarded
• Degree in Business, Commerce, Data Analytics, Information Systems or a related discipline

Why us?

• Access to employee benefits across Wesfarmers including team member discounts at Bunnings, Kmart, Target, Officeworks, OnePass, Priceline, atomica, Clear Skincare Clinics and Instant Scripts
• Ongoing professional development and career opportunities across the Wesfarmers Health Division and the broader Wesfarmers Group
• Novated leasing options
• Access to our Employee Assistance Program (EAP) - available to all team members and their immediate family members, 24/7, 365 days a year
• Beautiful outdoor terrace for work and recreation
• Food, coffee and health & wellbeing facilities onsite including a landlord operated gym
• Dedicated end of trip facilities (cycle racks, showers, lockers)

Aboriginal and Torres Strait Islander Applicants

Wesfarmers Health aims to become an employer of choice for First Nations Australians, through investments that attract, empower and retain First Nations team members within our stores, distribution centres, clinics and corporate offices.

As part of the Wesfarmers group, we provide authentic support through a diverse range of programs and initiatives, designed to empower you on your journey towards personal achievement and professional advancement.