At WHSmith our people are at the heart of everything we do. They are the ones that go the extra mile for our customers. The ones that enable our growth.

We are seeking a highly analytical and commercially astute Commercial Data Analyst to join our agile delivery team on a 6-month Fixed Term Contract. This is an exciting opportunity to make a tangible impact by focusing on the performance of our key stores across the UK.

As part of a dedicated agile squad, you will be instrumental in unearthing critical insights that will directly influence strategic decisions, optimise store operations, and enhance profitability in our most commercially significant locations.

Your role will be translating complex data into clear, actionable recommendations.

What you will be doing:

• Performance Analysis: Conduct in-depth analysis of sales, footfall, conversion rates, average transaction value (ATV), units per transaction (UPT), inventory levels, and operational metrics for our largest stores.

• Insight Generation: Identify key trends, anomalies, opportunities for growth, and potential risks within store performance data.

• Stakeholder Engagement: Present complex findings and recommendations clearly and concisely to various stakeholders, including Commercial, Operations, Finance and Merchandising Heads fostering a data-driven culture.

• Trial & Initiative Support: Provide analytical support for new commercial initiatives and operational changes being trialled within the largest stores, measuring their effectiveness and impact.

• Collaboration: Work collaboratively within an agile team, participating in daily stand-ups, sprint planning, and reviews, ensuring data insights are integrated into delivery cycles.

What we are looking for:

Essential:

• Proven experience (2+ years) as a Data Analyst preferably within a retail or consumer-focused environment.

• Strong proficiency in SQL for querying and manipulating large datasets.

• Expertise in data visualization tools such as Tableau, Power BI, Looker, or similar, with a portfolio of impactful dashboards.

• Advanced Microsoft Excel skills (pivot tables, VLOOKUPs, complex formulas).

• Understanding of key retail metrics and commercial drivers.

• Experience working within an agile development methodology.

• Exceptional analytical and problem-solving abilities, with a keen eye for detail.

• Excellent communication and presentation skills, with the ability to translate technical data into business-friendly insights.

• Proactive, self-motivated, and able to manage multiple priorities in a fast-paced environment.

• A degree in a quantitative field such as Mathematics, Statistics, Economics, Computer Science, Business Analytics, or a related discipline.

Desirable:

• Experience with statistical programming languages (e.g., Python, R) for more advanced analysis.

• Direct experience analysing store-level performance data for a large multi-site retailer.

How we reward our teams:

• Competitive salary

• Annual bonus based on company and personal performance

• Hybrid working model from home and in the office

• 24 Days holiday, plus your Birthday off, plus Bank Holidays with an opportunity to buy extra days holiday

• Finish at 4pm on a Friday

• Competitive pension contribution

• Staff discount card for stores and online

About us:

Celebrating 230 years, we’re proud to have grown and evolved into a globally recognised brand present in over 30 countries around the world, and we’re proud to be that air of familiarity people love and trust on their journey, both in life and through life. As a diverse group of over 12,000 colleagues, we are all on the same journey to a better business through our commitments to our planet, people and the communities we serve.

For UK and International Travel our mission is simple - to create value for our stakeholders by providing a platform for global brands responsible for essentials and technology in airports (including our InMotion stores), hospitals, rail stations and other markets. Our office is based in a buzzing part of London close to Liverpool Street Station. We are an ambitious team that thrives on pace, collaboration and innovation resulting in a real entrepreneurial culture at all levels. It’s perfect for people who are happy to use their initiative and embrace life outside their comfort zone.

At WHSmith, we’re all about creating an inclusive and welcoming workplace where everyone can be themselves and do their best. No matter your background, age, disability, gender, gender expression, gender identity, race or ethnicity, marital status, religion, sex, sexual orientation or anything else that makes you, you—you’re welcome here.

We’re also open to flexible working where possible, so if that’s something you need, let’s chat. And if you need any adjustments during the selection process, just let our Talent Acquisition team know—we’re happy to help!