Data Analyst Wanted

About Palermo Perfumes

Palermo Perfumes is a rapidly growing Australian fragrance business specialising in high-quality designer-inspired perfumes. Our operations include a Melbourne head office and production facility, a national retail network, a growing e-commerce business and distribution operations supporting stores throughout Australia.

As our business continues to expand, we are seeking a Data Analyst to turn information from our retail, online, production and inventory operations into practical insights that support business decisions.

About the Role

This is a permanent, full-time position based at Palermo Perfumes’ Melbourne head office.

The Data Analyst will collect, organise, check and analyse business data using appropriate analytical and information technology tools. The role will translate findings into clear reports, dashboards and visual presentations that help management understand performance, identify trends and plan improvements.

Working with management and operational teams, the successful candidate will analyse fragrance sales, customer purchasing patterns, stock movements and production information across Palermo’s business.

Key Responsibilities

• Consult with management and operational teams to define business questions, reporting needs and the data required for analysis.
• Collect and combine data from Palermo’s retail, e-commerce, inventory and production systems, including Shopify, Katana and relevant business records.
• Clean, validate, and structure datasets, investigating missing information, duplicate records, and inconsistencies in product codes, sales transactions, and stock movements.
• Analyse fragrance sales by product, store, region, and sales channel to identify demand patterns, seasonal changes, and performance differences.
• Examine customer purchasing patterns, repeat purchases, product combinations and promotion results to support product-range and marketing decisions.
• Analyse inventory turnover, stock availability, returns and slow-moving products to identify opportunities to improve stock allocation and replenishment.
• Prepare analytical forecasts using historical sales and seasonal trends to support production and inventory planning.
• Compare production output, stock transfers and sales data to identify variances and investigate potential operational issues.
• Develop and maintain interactive dashboards, charts and recurring reports showing agreed business performance measures.
• Explain analytical findings, assumptions and limitations clearly, and present practical recommendations to management.
• Document data sources, calculation methods and reporting definitions to maintain consistent and reliable reporting.
• Improve recurring data preparation and reporting processes while maintaining appropriate confidentiality and access controls.

Qualifications and Experience

The successful applicant will have:

• A bachelor’s degree or higher qualification in Data Analytics, Business Analytics, Statistics, Mathematics, Information Technology, Computer Science or a closely related quantitative discipline.
• At least one year of relevant professional experience in data analysis, business intelligence or analytical reporting.
• Experience collecting, cleaning, combining and interpreting business datasets.
• Strong Excel skills and practical experience using SQL to extract and analyse data.
• Experience developing dashboards and visual reports using Power BI, Tableau or a comparable tool.
• An understanding of statistical analysis, trend analysis and forecasting methods.
• Experience with retail, e-commerce, inventory or manufacturing data will be highly regarded.
• Familiarity with Shopify, Katana or comparable business systems will be advantageous.

Skills and Attributes

• Strong analytical thinking and problem-solving skills.
• High attention to detail and a commitment to data accuracy.
• The ability to explain technical findings in clear business language.
• Strong communication, organisation and time-management skills.
• The ability to work independently and collaborate with different operational teams.

What We Offer

• A permanent, full-time role within a growing Australian fragrance business.
• Exposure to data across retail, e-commerce, production and distribution operations.
• The opportunity to develop reporting tools that directly support business decisions.
• A collaborative working environment with opportunities to improve analytical processes as the business grows.