Negotiable
Undetermined
Hybrid
Welwyn Garden City, England, United Kingdom
Summary: The Trade Planning Senior Analyst role at Tesco is a 9-12 month Parental Leave Cover Contract focused on shaping price and promotion strategies through advanced analytical techniques. The position requires substantial experience with large data volumes and modern data processing tools, particularly SQL. The successful candidate will collaborate with various teams to deliver strategic projects and insights that enhance the customer experience. This role emphasizes data analysis, visualization, and the ability to communicate effectively with stakeholders.
Key Responsibilities:
- Support the delivery of key strategic projects across product and channel teams.
- Design and perform analyses for strategic projects including indexing, investment modelling, and promotional optimisation.
- Identify and solve complex issues within data for accurate analysis.
- Support the end-to-end process from planning and forecasting to performance review.
- Convert analysis into Tableau dashboards.
- Proactively identify processes for standardisation, simplification, and automation.
- Collaborate with teams across the business to develop solutions for customers.
- Perform ad hoc research and analyses to diagnose performance issues.
Key Skills:
- Substantial experience with SQL (Teradata and Hadoop).
- Strong Excel skills.
- Good data visualisation skills, especially with Tableau.
- Strong written and verbal communication skills.
- Experience with Python, VBA, and other data visualisation tools.
- Bachelor’s degree in Mathematics, Economics, Applied Statistics, Computer Science, Physics, Engineering, or related field.
- Practical use of data with a focus on customer experience.
Salary (Rate): undetermined
City: Welwyn Garden City
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: undetermined
Industry: Other
About the role 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). 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 - EF1 - Hybrid 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. 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.