Lead Analytical Engineering and Reporting Analyst
- Team
- Digital & Tech
- Store
- London Support Office
- Location
- London, Greater London
- Contract type
- Permanent
- Position type
- Full Time
- Salary
- Competitive + Benefits
- Closing date: 8th May 2026
Everyone is welcome at M&S. No exceptions. It’s your background, abilities and differences that make you, uniquely you. And when you’re part of M&S, that individuality has the potential to make waves.
This section tells you all you need to know about the position and its responsibilities, outlining everything we hope to see in a successful candidate.
To lead a team of analysts in the development of high-quality Power BI reporting whilst owning the underlying M&S Online analyst data layer. This includes the transformation of Data Engineering supplied data and API-driven data ingestion to enable report creation
This position combines hands-on reporting and dashboard delivery with the technical ownership of a curated data layer, balancing insight delivery and robust analytics engineering.
The role ensures M&S Online data is reliably shaped and modelled for consistent, trusted and actionable reporting insight that drive decisions on M&S’s operational excellence and across the entirety of the Customer browse, purchase and return journey
Domain specific accountabilities for automation and reporting include M&S Online Operations, D&T Product Teams, Food Digital and Brands whilst also owning M&S Online Customer/Trade via the management of highly skilled team.
Analytical Engineering
• Transform and curate Data Engineering supplied data into reporting-ready datasets.
• Maintain API-driven data ingestion pipelines into the analytical layer.
• Implement data validation and performance optimisation.
• Ensure consistency and governance in metrics
Reporting
• Build and maintain Power BI dashboards for M&S Online.
• Develop semantic models, star schemas, and standardised KPIs.
• Translate business requirements into clear, actionable, and visually compelling reports.
• Drive self-service reporting adoption by providing reusable datasets and training/support.
• Maintain dashboard consistency, usability and performance.
• Support leadership and operational decision-making with timely, accurate reporting
This is a highly technical role that requires extensive knowledge and application of Power BI (DAX, Power Query) but also analytical languages (SQL, PySpark, Python) to build all required pipelines
Aside from setting the general direction of development, this is an outward facing role in which collecting and interpreting requirements is key, as is playing back the final delivered products.
• Develop and lead a team of analysts, driving a high-performance culture across the team
• End to end delivery of reporting for M&S Online KPIs with a focus on Operational areas, Trade and Experimentation
• Building roadmaps to set the direction of the team - identifying opportunities for new reporting products and enhancements
• Strong stakeholder management - gather requirements and delivering to their requirements
• Continuously evolving or delivering new Insights to keep pace with changing demands
• Drive improvements in automation, optimisation and general best practices
• Actively develop relationships & collaboration between Digital & Tech and M&S Online teams
• Always Thinking customer and putting them at the centre of all that we deliver
Who you are
Everyone's Welcome
We are ambitious about the future of retail. We’re disrupting, innovating and leading the industry into a more conscientious, inspiring digital era. We’re transforming how we work together and offering our most exciting opportunities yet. Marks & Spencer strives to be an inclusive organisation, trusted and admired by our colleagues, customers and suppliers. Join us and make change happen.
We're at our best when we're close to customers, and for many of us at M&S, that means working in store every day.
To stay close to customers, our support teams are in the office three days a week as we believe that skills are developed through collaboration, and that spending time together makes us more creative and connected. It also means we can solve problems as soon as they arise, learn and grow as a team, build trust, and get closer to our colleagues.
Take part in our M&S Digital & Tech team days. Grow your digital and data skills through our BEAM Academy. Or challenge yourself at one of our business-wide hackathons. We also partner with Women in Data, Databricks and Cajigo to increase opportunities for women in digital and data.
Your voice and your ideas matter here. Our 8 colleague networks are places to find support, listen to each other and encourage debate. You can pitch ideas ‘Straight to Stuart’, our CEO, or get involved in our BIG (Business involvement Group).
Here’s what to expect at each stage of the application process. This can change depending on the role you’ve applied to. If you need any reasonable adjustments made at any stage, let us know and we can help.
Fill in our short application form and hit submit.
Depending on the role you are applying for, you may be invited to do an assessment. Your Talent Acquisition Partner will guide and inform you along the way.
We'll invite you to join us for an interview. This could be remote or in person. Here, we'll ask you some role based technical questions and examine the behaviours we're looking for.
After we’ve made our decision, we’ll be in touch. If you’ve been successful, we’ll officially invite you to join the team and let you know the next steps.