Trade Planning Senior Analyst

About the role

An exciting opportunity has arisen for a Trade Planning Senior Analyst to join the team here at Tesco on a 9 month Fixed Term Contract.

This role supports the rollout of a wide range of strategic initiatives. The successful candidate will be responsible for helping to shape our price and promotion strategies with timely insight and analysis utilising advanced analytical and modelling techniques.

The ideal candidate will have substantial experience with handling large data volumes with modern data processing tools, especially SQL (Teradata and Hadoop).

You will be responsible for

• Supporting the delivery of key strategic projects across the product and channel teams e.g. Price Index development, Promotional Optimisation, and delivery of the Trade Plan.
• Designing and performing timely and insightful analyses for strategic projects such as indexing & competitiveness, investment modelling, promotional optimisation, price architecture and range optimisation, space allocation, regression analysis and trade plan & promotion forecasting.
• Identifying and solving complex and deep issues within the data to provide accurate analysis.
• Supporting the end-to-end process from planning and forecasting through to performance review and insight.
• Converting analysis into Tableau dashboards.
• Proactively identifying processes where we can standardise, simplify, and automate.
• Working closely with other teams in the Product division, such as Product Proposition, Promotions, Trade Planning, and Space, Range & Display (SRD) to ensure our full commercial strategy is aligned and executed efficiently.
• Collaborating with teams across the wider business, including Category, Insight, and Channel specialists, to identify opportunities and develop the right solutions for our customers and our business.
• Performing ad hoc research and analyses to diagnose recent performance and operational issues.

You will need

Operational Skills:

• Substantial experience with handling large data volumes with modern data processing tools, especially SQL (Teradata and Hadoop).
• Strong Excel skills
• Good data visualisation skills, especially through Tableau
• Strong written and verbal communication, ability to engage with stakeholders at all levels
• Python, VBA, and other data visualisation tool experience

Experience:

• Bachelor's degree or equivalent in Mathematics, Economics, Applied Statistics, Computer Science, Physics, Engineering or related field
• Experience focusing on the practical & pragmatic use of data and a passion for connecting your work directly to the customer experience, making a real and tangible impact

Whats in it for you?

We're all about the little helps. That's why we make sure our Tesco colleague benefits package takes care of you – both in and out of work. Click Here to find out more

• Annual bonus scheme of up to 20% of base salary
• Holiday starting at 25 days plus a personal day (plus Bank holidays)
• Private medical insurance
• 26 weeks maternity and adoption leave (after 1 years' service) at full pay, followed by 13 weeks of Statutory Maternity Pay or Statutory Adoption Pay, we also offer 6 weeks fully paid paternity leave
• Free 24/7 virtual GP service, Employee Assistance Programme (EAP) for you and your family, free access to a range of experts to support your mental wellbeing

About Us

You might know us as a supermarket, technology company or even for our award-winning mobile network. Truth is, we're all of those things, and much more. Our colleagues work with one goal in mind, helping to make every day a little better for our customers, colleagues and communities all over the world. No two customers are the same, neither are our colleagues.

At Tesco, we champion a balance that lets you thrive both in and out of work. Spend 60% of your week collaborating with colleagues at our office locations or local sites and the rest remotely. Whether you're just kicking off your career, juggling passions, or navigating big life events, we're here to support you. We always welcome a conversation about flexible working, so talk to us throughout your application about how we can support.

We're proud to be an accredited Disability Confident Leader, where everyone's welcome. That's why we commit to providing a fully inclusive and accessible recruitment process. If you need support with your application,
click here
for more information. And if you're interested in joining our team but don't tick every box, don't let that hold you back from applying.