Trade Planning Senior Analyst (9-12 month Parental Leave Cover Contract)

Tesco UK; Welwyn Garden City; Hybrid; GBP 45,000 - 65,000; Full time

Job summary

Tesco is offering an exciting opportunity for a Trade Planning Senior Analyst to join their team for a 9-12 month Parental Leave Cover Contract. This role involves supporting strategic initiatives, utilizing advanced analytical techniques to shape pricing and promotion strategies, and collaborating across teams to ensure efficient execution.

Qualifications

• Experience with large data volumes and data processing tools.
• Strong analytical skills and attention to detail.
• Ability to engage with stakeholders effectively.

Responsibilities

• Support strategic projects like Price Index development and Promotional Optimization.
• Perform analysis for promotional and pricing strategies.
• Collaborate with various teams to enhance commercial strategies.

Skills

SQL

Excel

Data visualization

Python

VBA

Education

Bachelor’s degree in Mathematics, Economics, Applied Statistics, Computer Science, Physics, Engineering or related field

Tools

Tableau

Teradata

Hadoop

Job description

An exciting opportunity has arisen for a Trade Planning Senior Analyst to join the team here at Tesco on a 9-12 month Parental Leave Cover 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).

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

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

#LI - EF1

#LI - Hybrid

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.