Lead Analytical Engineering and Reporting Analyst Full Time NEW

What’s In It For You

Working at M&S means being part of something bigger – helping to deliver quality, value and service to millions of customers every day. We’re inclusive, fast-moving and always evolving, with a strong sense of purpose and a focus on doing the right thing.Here are just a few of the benefits that make working here even more rewarding:

• 20% colleague discount on all M&S products and many third-party brands for you and someone in your household, available once you’ve completed your probation· Competitive holiday allowance with the option to buy more· Discretionary bonus schemes linked to your performance and ours· Strong pension and life assurance to help plan for the future· Tailored induction and training to support your development from day one· Exclusive perks and savings through our M&S Choices portal· Market-leading family policies, including parental, adoption and neonatal leave· 24/7 wellbeing support, including virtual GP access and mental health services· One paid volunteer day a year to support a cause that matters to you

What You’ll Do

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

• Proven team leadership and coaching experience
• Proven experience working with huge quantities of customer data ideally within the retail industry or similar.
• Direction setting and stakeholder management
• Advanced SQL, PySpark and Python to curate data
• Exceptional Power BI
• Able to multi-task and prioritise accordingly
• Attention to detail and competent working under pressure

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 are committed to building diverse and representative teams, where everyone can bring their whole selves to work and be at their best. We support each other and work together to win together.If you feel you’d benefit from any support or reasonable adjustments during any stage of the recruitment process, please don’t hesitate to let us know when completing your application. This information will be picked up by our team, so we can try and put steps in place to help you be at your best through this process