Data Analyst

VPZ; City of Edinburgh; On-site; GBP 36,000 - 52,000; Full time

Job summary

VPZ, the UK’s leading specialist vape retailer, is seeking a Data Analyst at our Head Office in Newbridge, Edinburgh. You will turn complex information into clear recommendations that influence commercial and operational decisions.

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

Qualifications

• At least two years of experience in a Data Analyst, BI Analyst or comparable analytical role.
• Strong SQL skills, including joins, aggregations, CTEs and complex datasets.
• Advanced Excel skills.
• Experience creating dashboards and reports in Power BI or Tableau.
• Experience in retail, e-commerce analytics is advantageous.
• Experience with REST APIs, MongoDB, Python or R is beneficial.

Responsibilities

• Build and maintain dashboards and recurring reports in Power BI or Tableau.
• Analyse sales and operational performance across 190 stores to identify trends and opportunities.
• Evaluate product, category, store and channel performance to support decisions.
• Present regular performance updates and recommendations to senior stakeholders.
• Analyse customer behaviour, segmentation, retention and campaign effectiveness.
• Support demand forecasting, stock analysis and supply-chain optimisation.

Skills

SQL

Excel

Data interpretation

Stakeholder communication

Tools

Power BI

Tableau

REST APIs

MongoDB

Python

R

Job description

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.

Please note this role requires 5 days on site, here at Head Office in Newbridge, Edinburgh.

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

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