Visualisation & Automation Analyst - Financial Services (1 Year FTC) in City of Westminster

The Visualisation & Automation role is responsible for delivering enterprise-level analytical reporting across the M&S Financial Services domain. You will own the end-to-end lifecycle of management information and performance reporting — from building automated data pipelines to developing scalable, insight-led dashboards — enabling near real-time performance tracking and confident, data-driven decision-making. This role plays a key part in providing a single, trusted view of customer and commercial performance, supporting both Financial Services and the wider M&S business. This is a hands‑on technical role, requiring strong experience in Power BI (including DAX and Power Query) and in building automated data pipelines using SQL and PySpark.

What you’ll do:

• Design and deliver a scalable Power BI reporting suite, providing clear, actionable dashboards for stakeholders from operational teams to senior leadership.
• Build and maintain automated data pipelines using SQL and PySpark, ensuring efficient processing of large-scale customer and transactional data.
• Ensure reliable data integration and robust modelling across Credit, Payments, General Insurance, and Travel Money, aligned to M&S standards.
• Partner with stakeholders to translate business requirements into effective analytical and reporting solutions.
• Uphold strong data governance, quality, and control standards to ensure trusted, high-performing reporting for decision‑making.

Who you are:

• Highly numerate and data literate, with a strong analytical mindset.
• Advanced Power BI skills, including building complex dashboards using DAX and Power Query.
• Proven experience designing and managing automated data pipelines using SQL and PySpark.
• Strong problem‑solving skills, with the ability to work with large, high‑volume datasets and optimise for near real‑time performance.
• Solid understanding of data modelling, analytical best practices, and scalable reporting architectures.

What’s in it for you?

• 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 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.