Business Analyst (Commercial)

Woolworths Group; Auckland; Hybrid; NZD 70,000 - 90,000; Full time

Job summary

A leading retail company in Auckland is seeking a Commercial Analyst to support trading teams with commercial insights, structured analysis, and performance reporting. The ideal candidate will have a tertiary qualification in a quantitative field and strong skills in SQL and Excel, along with relevant experience in commercial analysis. This role offers a hybrid working model and various programs to prioritize well-being.

Benefits

Hybrid working model

Well-being programs

Team discounts

Competitive leave policy

Qualifications

• 1–3 years' experience in commercial analysis or finance business partnering.
• Understanding of trading performance metrics and margin drivers.

Responsibilities

• Deliver timely and accurate trading, pricing, and promotional reporting.
• Analyse trading performance to identify trends and opportunities.
• Support pricing reviews and supplier funding initiatives.
• Develop insights to optimize sales and margin outcomes.
• Collaborate with Category Managers and Finance Partners.

Skills

Strong commercial acumen

Proficiency in data analysis tools like Excel and SQL

Excellent communication skills

Solutions-oriented mindset

Attention to detail

Education

Tertiary qualification in a quantitative field

Tools

SQL

Excel

Job description

Overview

We are Woolworths Group | Ko Woolworths Tātou

We are Woolworths Group. 200,000+ bright minds, passionate hearts and unique perspectives connected by a shared Purpose – ‘to create better experiences together for a better tomorrow.’ It’s that Purpose that fuels our ambition to explore new ideas, make brave commitments and innovate better ways to meet the food and everyday needs of more than 24 million customers every week.

If you’re excited to turn today’s blue sky thinking into a better tomorrow for future generations, you’ll find yourself supported and enriched in a dynamic, inclusive and empowering workplace that reflects the diverse communities we serve. With a culture of genuine care, a flexible approach to work and opportunities across the group to grow your career and make a meaningful impact, the possibilities for what we can achieve together are endless.

What you’ll do | Hei mahi

As a Commercial Analyst within the Commercial Enablement team, you will support the trading teams by providing commercial insights, structured analysis, and performance reporting that drive better trading outcomes. You will play a key role in supporting promotional effectiveness, pricing initiatives, and margin improvement programs, enabling the business to make commercially sound decisions.

The Key Responsibilities Include

• Deliver timely and accurate trading, pricing, and promotional reporting to support commercial decisions.
• Analyse trading performance to identify key trends, opportunities, and risks.
• Support pricing reviews, promotional reset programs, and supplier funding initiatives through robust commercial analysis.
• Develop clear, business-focused insights that enable trading teams to optimise sales and margin outcomes.
• Maintain and improve reporting frameworks, ensuring outputs are commercially relevant and action-oriented.
• Collaborate closely with Category Managers, Commercial Managers, and Finance Partners to align insights with trading priorities.
• Uphold high standards of commercial integrity and reporting accuracy.

What you’ll bring | Hei koha

You’ll bring strong commercial acumen, proficiency in data analysis tools like Excel and SQL, and the ability to translate complex data into clear business insights. Also, you’ll possess excellent communication skills, a proactive, solutions-oriented mindset, and meticulous attention to detail.

To Be Successful In This Position, You Will Have

• Tertiary qualification in a quantitative field (Commerce/Business, Accounting, Computer Science, Maths, Statistics)
• 1–3 years' experience in commercial analysis, trading support, or finance business partnering, preferably in Retail or FMCG
• Highly proficient in SQL and Excel
• Understanding of trading performance metrics, margin drivers, and promotional effectiveness
• Strong communication, influencing, and collaboration skills with high attention to detail

What you’ll experience | Ngā Huanga

Our Team Members Are At The Heart Of Everything We Do And We’re Always Looking For Ways To Support Your Career Journey And Reward Great Work

• A commitment to flexibility through a hybrid working model which combines time spent at a support office or hub and time working from home, supporting both in-person connection and balancing the flexibility that remote working provides for our teams
• High-impact role supporting our teams who enrich our communities.
• A global business with endless career possibilities around every corner and across every discipline – with valuable exposure to a vast and exciting business network.
• A range of programs to help you prioritise and manage your wellbeing, including 24/7 access to the Sonder app.
• A progressive and competitive leave policy that gives you more space for what matters to you.
• Team discounts across our range of Woolworths Group brands you know and love and a robust rewards program that celebrates and incentivises purpose-driven work.

Everyone belongs at Woolworths Group | No Woolworths tātou

Diversity, equity, inclusion, and belonging are key to realising our purpose of better together for a better tomorrow. We recognise the value our team’s diversity brings to our business, customers, and communities and that teams with diverse experiences and backgrounds enrich our group and are better able to innovate and solve problems. As one of the largest employers in Australia and New Zealand, we aim to create a truly inclusive workplace where everyone feels that they belong, can be their best selves, and reach their full potential.

We encourage all candidates to apply; please let us know in your application if we can support you with any adjustments in the hiring process.