Category Analytics Assistant

Care Pharmaceuticals Pty Ltd; Australia; Hybrid; AUD 65,000 - 90,000; Full time

Benefits offered by this job

Birthday leave

Charity day

Early finish Fridays

Flexible working

Paid parental leave

Study support

Professional membership support

Employee Assistance Program

Salary continuance insurance

Job summary

Care Pharmaceuticals seeks a Category Analytics Assistant to support the Head of Category ANZ and the wider team with accurate preparation, maintenance and interpretation of category, channel, shopper and customer data.

You will prepare and maintain weekly and monthly dashboards, track sales, market share and promotional performance, and assist with range reviews, customer meetings and forecasting inputs to drive decisions.

Qualifications

• 1 to 3 years in category analytics, sales analytics or related role.
• Strong Excel capabilities with pivot tables, formulas and data cleaning.
• Proficient PowerPoint skills for concise, visuals-led presentations.
• Commitment to data accuracy and attention to detail.

Responsibilities

• Prepare and maintain weekly and monthly category, channel and brand dashboards.
• Track sales, market share, distribution, rate of sale and promotional performance.
• Compile reports using market, customer, shopper and internal data sources.
• Support data governance, validation and quality checks across datasets.
• Summarise data into insights and actions for range reviews and business reviews.
• Build insight-led presentation materials for retailer meetings and reviews.

Skills

Excel

PowerPoint

Data analysis

Education

Bachelor’s or higher in Business/Commerce/Data Analytics

Tools

IQVIA

Quantium

Aztec

Circana

Nielsen

Job description

Care Pharmaceuticals is mid-size consumer health company with an established and growing consumer healthcare business with a strong presence across the Australian/NZ pharmacy and grocery market. Our portfolio includes well-known healthcare brands such as Hydralyte, FESS, Zatiden, Murine, and Dermal Therapy.

As part of Prestige Consumer Healthcare, we combine the agility and close-knit culture of a locally focused business with the scale and resources of a broader international consumer healthcare organisation. We’re a collaborative, hands-on team where people are encouraged to take ownership, build strong relationships and make a genuine contribution to the growth of the business.

About the role

The Category Analytics Assistant supports the Head of Category ANZ and broader Category team through accurate preparation, maintenance and interpretation of category, channel, shopper and customer data. This role provides the analytical foundation that enables insight-led decision making across range reviews, customer presentations, business reviews, promotional evaluations, data governance, forecasting inputs and category strategy development.

Key responsibilities

Category Reporting & Dashboard Support

Prepare and maintain weekly and monthly category, channel and brand performance dashboards.

Track sales, market share, distribution, rate of sale, promotional performance and customer performance.

Compile and update recurring reports using market, customer, shopper and internal data sources.

Convert raw data into clear tables, charts and summaries that support commercial decision making.

Data Governance & Accuracy

Support data cleansing, validation and quality checks across IQVIA, Quantium, retailer scan data, customer data, internal sales data and Excel reporting files.

Maintain naming conventions, category hierarchies, product classifications, brand groupings, pack formats and SKU mapping files.

Identify data gaps, inconsistencies or unusual movements and escape to the Head of Category or relevant team member.

Market, Shopper & Customer Analysis

Support analysis of market trends, category growth drivers, shopper behaviour and channel performance.

Assist in identifying key movements in sales, market share, distribution, pricing, promotional activity and competitor performance.

Prepare supporting analysis for range reviews, customer business reviews, joint business planning and category strategy projects.

Summarise data into clear insights, implications and recommended actions.

Customer Presentation & Range Review Support

Assist in building insight-led customer presentation materials for retailer meetings, range reviews and category reviews.

Prepare charts, tables and supporting data points for sell-in stories, range submissions and activation recommendations.

Support post-promotional evaluations by compiling sales performance, promotional uplift, distribution change and rate of sale analysis.

Assist with data inputs required for category forecasting, demand planning and NPD performance tracking.

Track NPD performance post-launch against distribution build, sales performance, rate of sale and market penetration assumptions.

Maintain historical benchmarks to support future forecasting assumptions.

AI, Tools, Systems & Process Improvement

Use Excel, PowerPoint, Microsoft Copilot and other approved AI-enabled tools to support category reporting, analysis, presentation development and workflow efficiency.

Apply AI tools responsibly to assist with data summarisation, insight generation, first-draft commentary, report automation, presentation storylines and quality checking.

Build capability in key data platforms including IQVIA, Quantium and other relevant market or customer data sources.

Identify opportunities to simplify, automate or improve recurring reporting processes while maintaining data accuracy, confidentiality and human review of AI-assisted outputs.

Maintain shared folders, reporting trackers, templates and category reference documents with agreed file naming and version control.

Assist with data inputs required for category forecasting, demand planning and NPD performance tracking.

Track NPD performance post-launch against distribution build, sales performance, rate of sale and market penetration assumptions.

Maintain historical benchmarks to support future forecasting assumptions.

Cross-Functional Collaboration

Work closely with the Head of Category ANZ, Retail Activation Managers, Sales, Marketing, Finance, Supply Chain and other cross-functional stakeholders.

Provide analytical support for monthly business reviews, annual planning, customer projects, brand planning and commercial initiatives.

Respond to internal data requests in a timely and professional manner.

About you

1 to 3 years’ experience in category, sales analytics, commercial analysis, data analysis, retail analytics, FMCG, consumer healthcare or a related commercial support role.

Strong Excel capability, including pivot tables, formulas, data cleaning, charts and structured reporting.

Strong PowerPoint skills with the ability to turn data into clear, concise and visually effective slides.

High attention to detail and strong commitment to data accuracy.

Ability to work with large datasets and identify trends, exceptions and commercial implications.

Strong organisational skills with the ability to manage recurring reporting deadlines.

Clear written and verbal communication skills and ability to work collaboratively with sales, category, marketing and finance stakeholders.

Interest in FMCG, consumer healthcare, pharmacy, grocery and retail category management.

Tertiary qualification in Business, Commerce, Marketing, Data Analytics, Economics, Finance or a related field.

Highly Preferred

Experience using IQVIA, Quantium, Aztec, Circana, Nielsen, retailer scan data or similar category data platforms.

Experience in pharmacy, grocery, consumer healthcare, OTC, FMCG or retail environments.

Experience preparing customer presentations, dashboards or business review materials.

Working knowledge of Power BI, Power Query, Power Pivot or other data visualisation tools.

Experience supporting range reviews, promotional analysis, NPD tracking or market share reporting.

Understanding of category management principles including range, space, pricing, promotion, distribution and shopper insights.

Experience maintaining master data files, product hierarchies or SKU mapping tables.

Additional leave benefits, including Birthday Leave and a Charity Day

Early 3pm finishes on Fridays

Flexible working options

Paid parental leave

Study support and professional membership support

Employee Assistance Program and salary continuance insurance