Data Analyst: Insights for Retail, E‑Commerce & Production

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