Data Analyst Wanted

Palermo Perfumes; Melbourne; On-site; AUD 70,000 - 110,000; Full time

Job summary

Palermo Perfumes, based in Melbourne, Australia, is seeking a Data Analyst to transform data from retail, online, production and inventory into practical insights for decision-making. The role involves collecting, cleaning and analysing data using SQL and BI tools, creating dashboards, and translating findings into actionable recommendations for management across store networks and e-commerce operations.

The successful candidate will work with management and cross-functional teams, focusing on

Qualifications

• Bachelor degree or higher in Data Analytics, Business Analytics, Statistics, Mathematics, IT, CS or related quantitative field.
• At least 1 year of experience in data analysis, BI or analytical reporting.
• Experience collecting, cleaning, combining and interpreting business datasets.
• Strong Excel skills and practical SQL experience to extract and analyse data.
• Experience developing dashboards/visual reports using Power BI, Tableau or similar tools.
• Understanding of statistical analysis, trend analysis and forecasting methods.
• Familiarity with Shopify, Katana or similar systems is advantageous.

Responsibilities

• Consult with management to define questions, reporting needs and data requirements.
• Collect and combine data from retail, e-commerce, inventory and production systems.
• Clean, validate and structure datasets; investigate missing data and inconsistencies.
• Analyse fragrance sales by product, store, region and channel to identify demand patterns.
• Examine customer purchasing patterns and promotion outcomes to support product-range decisions.
• Analyse inventory turnover, stock availability, returns and slow-moving products.
• Prepare forecasts using historical sales and seasonal trends for production and inventory planning.
• Develop and maintain interactive dashboards and recurring reports showing performance measures.
• Explain findings clearly and present practical recommendations to management.
• Document data sources and reporting definitions to maintain consistency.
• Improve recurring data preparation and reporting processes with appropriate confidentiality.

Skills

Data Analytics

SQL

Power BI

Tableau

Forecasting

Excel

Retail Data

Education

Bachelor’s degree in a quantitative field

Tools

Power BI

Tableau

Shopify

Katana

Job description

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 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.