Insight & Reporting Analyst
What You’ll do
Your key accountabilities will include
Design, build and maintain scalable ETL/ELT pipelines using SQL and PySpark within Databricks.
Transform raw data into clean, structured and reusable data models for downstream BI and analytics.
Develop trusted datasets that support reporting, self-service analytics and business decision-making.
Optimise data workflows and automate processes using Power Platform and orchestration frameworks.
Collaborate with Data Engineers, Analysts and stakeholders to deliver high-quality data products and Power BI integration.
Who you are
Your skills and experience will include
Strong SQL capability, with experience writing complex queries and building scalable data solutions.
Advanced knowledge of Power BI, Power Query, DAX and M for reporting and analytical delivery.
Experience working with Databricks, PySpark and cloud-based data workflows.
Able to translate business requirements into structured, reliable datasets for analytics teams and stakeholders.
Comfortable working collaboratively across BI, Data Engineering and different technical and non-technical teams, with retail or FMCG experience a plus.
What's in it for you
Being a part of M&S is exactly that - playing your part to bring the magic of M&S to our customers every day. We’re an inclusive, dynamic, exciting, and ever evolving business built on doing the right thing and bringing exceptional quality, value, service to every customer, whenever, wherever and however they want to shop with us.
Here are some of the benefits we offer that make working for M&S just that little bit more special…
After completing your probationary period, you’ll receive 20% colleague discount across all M&S products and many of our third-party brands for you and a member of your household.
Competitive holiday entitlement with the potential to buy extra holiday days!
Discretionary bonus schemes awarded based on how you achieve your personal objectives and our performance as a business.
A generous Defined Contribution Pension Scheme and Life Assurance.
A dedicated welcome to our teams with a tailored induction and a wide range of training programmes to develop your skills.
Amazing perks and discounts via our M&S Choices portal to maximise your financial and personal wellbeing.
Industry-leading parental, adoption and neonatal policies, providing support and flexibility for your family.
Access to a fantastic range of wellbeing support for all colleagues including access to our 24/7 Virtual GP and PAM Assist to support you and your family.
A charity volunteer day to support a charity or cause you're passionate about through a dedicated day away from work.
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.
#hybridrole #LI-hybrid #LI-HB1