Senior BI Developer

This section tells you all you need to know about the position and its responsibilities, outlining everything we hope to see in a successful candidate., This is an opportunity to help us shape and implement the future of self service analytics at M&S by bringing AI and BI together into practical, scalable solutions. We're looking for a Business Intelligence Developer who combines strong technical skills with a problem-solving mindset. You should have strong experience in Power BI modeling and DAX, solid SQL knowledge, and the ability to design efficient, scalable data models. This role suits someone who thrives on collaboration, empowering others through shared learning and is eager to constantly push the boundaries of AI/BI technologies. All the details, * Build & own largescale Power BI semantic models that allow no code drag and drop report development by citizen developers and enable natural language analytics through Power BI Copilot.

• Gather requirements with business analysts & product management; translate business metrics into governed semantic models and logic.
• Partner with data engineering to shape and design dimensional models, ensuring query performance and modelling conventions are set for high performance downstream BI.
• Engineer data for BI - define and validate gold layer tables and views that back semantic models; review Databricks SQL query plans and recommend optimisation strategies.
• User Enablement - deliver training and how to packs for report builders using semantic models. Provide hands-on support to citizen develops; run regular workshops to aid adoption.

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., Supporting colleagues connected to the Armed Forces, aiding their transition to civilian life, and ensuring that they thrive in the workplace., Fostering a supportive and inclusive workplace culture, addressing stigma, providing guidance and raising awareness to empower and assist colleagues affected by cancer.

Do you have experience in Spark?, * Eager to learn and be on the cutting edge of AI/BI technologies.

• Power BI Modelling Expert - Deep knowledge of DAX and dimensional modelling in Direct Query models. Familiarity with external tools such as DAX Studio for performance optimisation. Experience with Fabric a plus.
• Strong SQL knowledge - Able to analyse query plans and suggest data lake optimisations. Experience with Databricks/Python/Spark for data engineering a plus.
• Experience designing star schemas from scratch; Able to turn complex business requirements into logical models and build clear semantics.
• Comfortable collaborating with engineers, analysts, and nontechnical stakeholders; able to create clear, concise documentation.

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.

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.