Marks and Spencer Logo

Marks and Spencer

Lead Analytical Engineering and Reporting Analyst

Posted Yesterday
Be an Early Applicant
In-Office or Remote
Hiring Remotely in United Kingdom
Senior level
In-Office or Remote
Hiring Remotely in United Kingdom
Senior level
Lead a team of analysts to develop Power BI reports, manage data transformation, maintain data pipelines, and ensure consistent reporting across M&S Online operations.
The summary above was generated by AI

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

 

#LI-CA1

Top Skills

Dax
Power BI
Power Query
Pyspark
Python
SQL

Similar Jobs

5 Hours Ago
In-Office or Remote
Mid level
Mid level
Information Technology • Software • Financial Services • Quantitative Trading
Software Engineers at Citadel develop, maintain, and support high-performance trading platforms, focusing on custom software solutions and system stability.
Top Skills: C++
5 Hours Ago
Remote or Hybrid
United Kingdom
Mid level
Mid level
HR Tech • Information Technology • Professional Services • Sales • Software
Responsible for the successful onboarding and management of Service Partners, ensuring customer engagement, performance, and the delivery of exceptional services.
Top Skills: HrmSalesforceSlackTableauZendesk
5 Hours Ago
Remote or Hybrid
United Kingdom
Mid level
Mid level
HR Tech • Information Technology • Professional Services • Sales • Software
The Account Executive will manage the entire sales cycle, focusing on prospecting and closing deals in the mid-market segment, targeting companies with 250-1000 employees.
Top Skills: Salesforce

What you need to know about the Belfast Tech Scene

If asked to name the birthplace of the RMS Titanic, you might not say Belfast. Similarly, if asked to name Europe's leading destination for foreign direct investment in new software development, Belfast might not come to mind. Yet, both are true. The city has emerged as a tech powerhouse, recently ranked among the best in the U.K. for tech careers — especially for software developers. It also leads the U.K. with the highest percentage of software development jobs advertised.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account