About the role

The Data Analyst will build and maintain performance dashboards while providing actionable insights to support commercial and operational decision-making. They will analyze sales, customer behavior, and supply-chain data to identify trends and opportunities across the business.

What they look for

SQL Power BI Data Analysis Excel Tableau Dashboarding Reporting Stakeholder Management Commercial Analysis Demand Forecasting Stock Management Customer Segmentation Python R MongoDB REST APIs

Requirements

Candidates must have at least two years of experience in an analytical role with strong proficiency in SQL and Excel. Experience with visualization tools like Power BI or Tableau is essential for success in this position.

Full description

Role type: Permanent

Salary: £35k to £40k per annum

About VPZ

VPZ is the UK’s leading specialist vape retailer. Since opening our first store in Edinburgh, we have grown to 200 locations across the UK.

We are continuing to invest in data and analytics so that teams across retail, e-commerce, manufacturing and operations can make faster, better informed decisions.

About the Role

As a Data Analyst, you will turn complex information into clear recommendations that influence commercial and operational decisions across the business.

You will build trusted dashboards, investigate performance trends and work with stakeholders to identify opportunities in areas such as store performance, product ranging, customer behaviour, stock management and campaign effectiveness.

This role would suit an analyst who enjoys combining hands-on technical work with commercial problem-solving and stakeholder communication.

What You Will Do

Build and maintain dashboards and recurring reports in Power BI or a comparable visualisation platform.

Analyse sales and operational performance across more than 190 stores, identifying trends, risks and commercial opportunities.

Evaluate product, category, store and channel performance to support ranging and investment decisions.

Present regular performance updates and clear recommendations to senior stakeholders.

Analyse customer behaviour, segmentation, retention and marketing campaign effectiveness.

Support demand forecasting, stock analysis and supply-chain optimisation.

What Success Looks Like

During your first six months, you will:

Establish trusted and consistently used performance dashboards

Improve the speed and reliability of recurring reporting

Deliver analysis that leads to measurable commercial or operational action;

Improve visibility of store, product, customer and stock performance;

Strengthen data quality and reduce unnecessary manual processes.

Essential Experience and Skills

You will be a strong match for this role if you have:

At least two years of experience in a Data Analyst, BI Analyst or comparable analytical role.

Strong SQL skills, including the ability to work with joins, aggregations, CTEs and complex datasets.

Advanced Excel skills.

Experience creating dashboards and reports in Power BI, Tableau or a comparable platform.

The ability to interpret commercial performance and turn analysis into practical recommendations.

Desirable Experience

It would be beneficial, but not essential, if you have:

Experience in retail, e-commerce, FMCG or manufacturing analytics.

Experience extracting data from REST APIs.

Knowledge of MongoDB or another NoSQL database.

Experience using Python or R for analysis, automation or statistical modelling.

Experience in demand forecasting, stock optimisation or customer segmentation.

Please ensure you apply with an up-to-date CV.

Applicants must be 18 years old or above, any subsequent job offer is subject to pre-employment screening and right to work checks.