Marketing Effectiveness Analyst

ABOUT THE ROLE Are you a data-driven strategist ready to shape the future of our marketing performance? We are looking for a Marketing Analyst to join us. You will act as the commercial co-pilot for the department, transforming raw metrics into a high-impact strategic advantage and ensuring every pound invested delivers maximum return with uncompromising data integrity. Moving beyond traditional reporting, you will interrogate our data ecosystems to uncover emerging trends, spot acquisition and retention opportunities, and diagnose underperformance in real time. Bridging the gap between complex analytics and live trading reality, you will deliver the proactive insights and recommendations needed to pivot, scale, and optimise our campaigns to drive business-critical success. In addition to your contractual pay, any time worked between 22:00 - 06:00 will attract Night Premium at a rate of £5.25 per hour. This will also apply to existing Partners who have enrolled onto Enhanced Hours Premium arrangements. Expected salary - £47,000.00 - £73,500.00 We are looking for candidates up to 60K, depending on experience Contract type - This position is a Permanent Working pattern/flexible working - The Partnership has adopted a hybrid working approach, meaning you'll be able to work a mixture between the office and home-based upon your personal needs, whilst balancing the needs of the business. We typically aim for around three days a week in the office to allow for collaboration and attendance of key meetings. Location - This role is based at our London Head Office campus in Pimlico. Please note this role has a 2-stage interview process. Key responsibilities Data Integrity & Governance: Serve as the lead custodian for marketing data quality. Maintain end-to-end data integrity across tracking, tagging, and reporting platforms while proactively addressing anomalies. Target Setting & Performance Measurement: Partner with the Customer Planning & Performance Manager to establish and track Customer and Marketing plan metrics. Oversee regular weekly, monthly, and ad-hoc reporting. Strategic Alignment: Collaborate with Brand Campaigns and Category Marketing teams, translating raw data into clear strategic frameworks that align activity with core business objectives. Cross-Functional Modelling: Work alongside Commercial, Customer, and Data Insight & Analytics teams to ensure key performance indicators are accurately modelled, unified, and free of data silos. Trend Identification & Actionable Insights: Analyse datasets continuously to detect emerging trends and shifts in consumer behaviour, turning complex analysis into clear, actionable recommendations. Agile Activity Optimisation: Provide data-driven guidance on budget reallocations across weekly, monthly, and quarterly planning cycles, advising marketing teams on where to scale, pivot, or stop campaigns to optimise acquisition and retention. Essential skills/experience you’ll need Highly commercially aware and understanding of business performance in line with Marketing performance Setting Marketing channel KPI’s and OKR’s for owned and paid channels Confident in SQL and joining large data sets using Snowflake Extensive knowledge and creation of reporting and automation techniques using BI tools such as Tableau Experience of delivering and influencing change using own analysis Confident in managing a variety of stakeholders, including Senior Leaders and presenting data stories Working knowledge of Adobe Analytics ​ Desirable skills/experience you’ll need Python and complex data modelling techniques Professional Marketing qualification and setting Marketing channel KPI’s and OKR’s Use of AI to generate insight and reporting tools You can view a copy of the full job outline For internal use only: #LI-HEADOFFICE #LI-MG1 #LI-HYBRID Closing Date: September 5, 2026 Pay: £47,000.00 - £73,500.00 Annual Contract Type: Permanent Hours of Work: 35 Job Level: Partnership Level 7 Where You'll Be Working: London Central Office, 1 Drummond Gate, London, , SW1V 2QQ ABOUT THE PARTNERSHIP We’re the largest employee owned business in the UK and home of our cherished brands, John Lewis and Waitrose. We’re not just employees, we’re Partners, driven by our purpose to build a happier world. As we look to our future, there’s never been a more exciting time to join us. We’re ruthlessly focused on being brilliant at retail. We continue to innovate, adapt and diversify. Never Knowingly Undersold on price, quality and service in John Lewis and passionately serving food-lovers in Waitrose. As Partners we all share the responsibility of ownership and in its rewards. We use our voices to contribute to our success, working together through the good and challenging times, holding true to our behaviours and treating everyone with kindness and respect. We all own making the Partnership somewhere we belong. Embracing our differences and creating an environment where we’re free to be ourselves and can THRIVE. Growing ourselves individually, and as a collective. As Partners, we make all the difference. And, we all own it. Important points to note: It’s important to note that some of our roles are subject to pre-employment vetting (which may include DBS checks for successful candidates). If required, you’ll be informed and provided with information about vetting during the recruitment process and we encourage you to complete any vetting documents quickly to avoid delays. Any DBS checks required will be carried out by a third-party registered body and financial probity checks may also be required for some of our roles. ​ We also recommend that you apply as soon as possible as vacancies can close early if we see a high number of applicants. We want all of our Partners to have a good work-life balance and we support flexible working. This might mean flexible or compressed hours, job sharing or shorter hour contracts, where possible. Please discuss this further with the hiring manager during your interview.