Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead a team to create impactful Power BI reports and manage data for M&S Online.
- Company: Join M&S, a fast-evolving company focused on quality and customer service.
- Benefits: Enjoy a 20% discount, competitive holidays, and 24/7 wellbeing support.
- Other info: Be part of a diverse team that values collaboration and innovation.
- Why this job: Make a real impact with data while developing your skills in a supportive environment.
- Qualifications: Experience in team leadership, SQL, Power BI, and handling large datasets.
The predicted salary is between 60000 - 75000 £ per year.
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 a 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 deliver 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.
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 would benefit from any support or reasonable adjustments during any stage of the recruitment process, please let us know when completing your application.
Lead Analytical Engineering And Reporting Analyst in London employer: MARKS&SPENCER
Contact Detail:
MARKS&SPENCER Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Lead Analytical Engineering And Reporting Analyst in London
✨Tip Number 1
Network like a pro! Reach out to current or former employees at M&S on LinkedIn. A friendly chat can give you insider info and maybe even a referral, which can really boost your chances.
✨Tip Number 2
Prepare for the interview by practising common questions related to analytical engineering and reporting. We recommend using the STAR method to structure your answers – it helps you showcase your skills effectively!
✨Tip Number 3
Show off your technical skills during the interview! Be ready to discuss your experience with Power BI, SQL, and Python. Bring examples of your past work to demonstrate how you've used these tools to drive insights.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in being part of the M&S team.
We think you need these skills to ace Lead Analytical Engineering And Reporting Analyst in London
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter to highlight your experience with Power BI, SQL, and team leadership. We want to see how your skills align with the role, so don’t hold back on showcasing your relevant achievements!
Showcase Your Analytical Skills: Since this role is all about data, be sure to include specific examples of how you've transformed data into actionable insights. We love seeing how you’ve used analytics to drive decisions in previous roles.
Be Clear and Concise: When writing your application, keep it straightforward and to the point. Use bullet points where possible to make it easy for us to read through your qualifications and experiences quickly.
Apply Through Our Website: We encourage you to submit your application directly through our website. It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at MARKS&SPENCER
✨Know Your Power BI Inside Out
Since this role heavily relies on Power BI, make sure you brush up on your skills. Be prepared to discuss your experience with DAX and Power Query, and think of specific examples where you've used these tools to create impactful reports.
✨Showcase Your Leadership Skills
This position requires proven team leadership. Prepare to share examples of how you've successfully led a team, managed stakeholders, and driven a high-performance culture. Highlight any coaching experiences that demonstrate your ability to develop others.
✨Understand the Business Context
Familiarise yourself with M&S's operations and customer journey. Be ready to discuss how your analytical insights can drive decisions in areas like online operations and trade. Showing that you understand the business will set you apart.
✨Prepare for Technical Questions
Expect technical questions related to SQL, PySpark, and Python. Brush up on your coding skills and be ready to solve problems on the spot. Practising common data manipulation tasks can help you feel more confident during the interview.