Insights and Automation Analyst

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

Benefits offered by this job

Team member discounts across Wesfarmrs

Novated leasing options

Employee Assistance Program (EAP)

Job summary

Wesfarmers Health is seeking an Insights & Automation Analyst to join the Merchandise Central team on an 18-month maximum-term contract. You will help transform how Merchandise teams operate through AI, automation and data-driven insights, collaborating across Buying, Space Planning, Trade Planning and more.

You will build AI-powered reporting and decision-support tools, while driving adoption and efficiency across functions.

Qualifications

• Experience in reporting, analytics or business intelligence roles.
• Retail or FMCG experience is desirable but not essential.
• Hands-on experience with AI tools and automation is necessary.
• Experience building dashboards/reports in Power BI and strong Excel skills.

Responsibilities

• Identify opportunities to apply AI and automation across Merchandise functions.
• Design AI agents using Copilot to support reporting and decision-making.
• Re-engineer processes with Power Automate and AI-enabled solutions.
• Drive adoption of AI tools and automation across teams with practical use cases.
• Develop and maintain Power BI dashboards, reports, and metrics.
• Establish scalable reporting frameworks with a single source of truth.
• Build supplier scorecards and performance reporting.
• Analyse promotional performance and forecast accuracy.

Skills

Reporting & analytics

Business intelligence

Excel

AI tools

Copilot/AI agents

SQL (Desirable)

Education

Business/Commerce/Data Analytics degree

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
• Strong Excel skills
• 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.