As part of the Visualisation & Automation function, it drives the ongoing development of a comprehensive Power BI reporting suite that supports the M&S Online function and wider partner teams, complementing deeper‑dive analytics and insight. Aligned to the vision of the Lead Visualisation Analyst, the role plays a key part in bringing data to life.
The ideal candidate will bring strong technical expertise in Power BI (including DAX and Power Query) alongside hands‑on experience in building automated pipelines in SQL or PySpark, essential for supporting the scale and activity of our customer base.
What you’ll do
Your key accountabilities will include
- Analyse key metrics and trends to provide data-driven recommendations that support innovation and business growth.
- Collaborate with the analytics team to shape and maintain digital data architecture, ensuring best practice, consistency, and clear KPI definitions.
- Translate complex data into visually engaging insights and actionable recommendations that address key business questions.
- Drive testing and optimisation initiatives — including multivariate experiments — to enhance site performance, conversion, and customer experience.
- Champion data accessibility across the organisation by developing self-serve analytics tools, training teams, and enabling a data-informed culture.
Who you are
Your skills and experience will include:
Strong numerical and data literacy, with the ability to interpret and manipulate complex datasets
Advanced visualisation and dashboard development skills in Power BI, including expert knowledge of DAX and Power Query
Technical capability in building and maintaining automated data pipelines using SQL and/or PySpark
Experience working with modern data platforms such as Azure Synapse and Databricks, with additional exposure to APIs
A proactive problem‑solving mindset, with the ability to troubleshoot, optimise, and enhance analytical solutions
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
Everyone’s welcome
We are ambitious about the future of retail. We’re reinventing, innovating and leading the industry into a more conscientious, inspiring digital era. We’re redefining 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.
#LI-ME1
#LI-Hybrid
