BI Developer

Fa Eqid Saasfaprod1

Greater London

Hybrid

GBP 55,000 - 75,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

20% colleague discount across M&S and
Bonuses (discretionary)
Pension scheme

Job summary

Marks & Spencer is seeking a Power BI-focused Data Analytics professional to design, develop and maintain reporting solutions. The role uses SQL and Databricks to transform and prepare large datasets for finance reporting and analytics.

You will build scalable semantic models with dimensional modelling and advanced DAX, supporting complex finance requirements and data-driven decision making across the organization. Hybrid work model in the United Kingdom.

Qualifications

  • Strong Power BI expertise including data modelling, Power Query, Dataflows, advanced DAX and RLS.
  • Experience designing efficient dimensional models with relationships, filter context and performance optimisation.
  • Strong SQL including joining and transforming complex datasets, aggregations, CTEs and window functions.
  • Ability to translate business requirements from Finance stakeholders into technical solutions.

Responsibilities

  • Design, develop and maintain Power BI reporting and analytics using SQL and Databricks to transform and prepare large datasets.
  • Build scalable semantic models using dimensional modelling and advanced DAX for Finance reporting.
  • Work across the data lifecycle to decide where transforms and calculations sit across Databricks/SQL, Power Query/Dataflows, models and DAX.
  • Promote data-driven decision making by enabling Finance teams with advanced analytics and insights.
  • Take ownership from requirements through deployment and ongoing support.

Skills

Power BI
Data modelling
Power Query
Dataflows
DAX
Row‑Level Security
SQL
CTEs
Window functions
Performance tuning

Tools

Power BI Desktop
Databricks

Job description

What You’ll do

Your key accountabilities will include Designing, developing and maintaining Power BI reporting and analytical solutions using SQL and Databricks solutions to transform, aggregate and prepare large datasets for downstream reporting and analytics. Building scalable and performant semantic models, using strong dimensional modelling principles and advanced DAX to support increasingly complex Finance reporting requirements. Working across the data lifecycle, making informed decisions about where transformations and calculations should sit across Databricks/SQL, Power Query/Dataflows, semantic models and DAX. Championing data-driven decision making by helping Finance teams adopt advanced analytics and unlock deeper business insights. Taking technical ownership of solutions from initial requirements and design through development, testing, deployment and ongoing support.

Who you are

Your skills and experience will include Strong Power BI expertise, including data modelling, Power Query, Dataflows, advanced DAX development and Row-Level Security (RLS). Experience designing efficient dimensional models, with a strong understanding of relationships, filter context, aggregation behaviour and performance optimisation. Strong SQL capability, including joining and transforming complex datasets, aggregations, CTEs, window functions and query optimisation. Excellent problem-solving and analytical skills, with a structured and pragmatic approach to decision making, along with strong organisational skills and the ability to manage competing priorities in a fast-paced environment. Ability to work directly with Finance stakeholders to understand, challenge and translate business requirements into technical solutions.

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

BI Developer
BI Developer

M&S Careers • Salford

On-site
GBP 55,000 - 75,000
20% colleague discount across M&S and
Discretionary bonus schemes
Pension scheme
+1
Senior Data Engineer
Senior Data Engineer

Marks & Spencer • Greater London

Hybrid
GBP 90,000 - 130,000
20% colleague discount across M&S
Discretionary bonus schemes
Generous pension scheme
+4
Senior Data Engineer - Customer Data Science
Senior Data Engineer - Customer Data Science

Marks and Spencer plc (UK) • Manor Park

On-site
GBP 60,000 - 90,000
Family-friendly policies (parential/ad
Wellbeing support
Volunteer day
Change Manager
Change Manager

M&S Careers • Chester

Hybrid
GBP 52,000 - 68,000
Colleague discount
Holiday allowance
Pension & life cover
+2
Staff Software Engineer - - Intl Partner Catalogue and Ordering
Staff Software Engineer - - Intl Partner Catalogue and Ordering

Fa Eqid Saasfaprod1 • City of Westminster

On-site
GBP 90,000 - 120,000
20% colleague discount
Discretionary bonus schemes
Strong pension and life assurance
+2
Software Engineering Manager - Warehouse Platform
Software Engineering Manager - Warehouse Platform

Marks & Spencer Group • Greater London

Hybrid
GBP 100,000 - 140,000
20% colleague discount
Holiday allowance with buy option
Discretionary bonus schemes
+6
Programme PMO Analyst
Programme PMO Analyst

Marks & Spencer Group • Greater London

Hybrid
GBP 50,000 - 80,000
20% colleague discount
Generous holiday entitlement
Discretionary bonus schemes
+4
Head of Finance - Group Reporting
Head of Finance - Group Reporting

Marks & Spencer • City Of London

Hybrid
GBP 120,000 - 180,000
20% colleague discount on M&S products
Holiday allowance with option to buy
Discretionary bonus schemes
+6
Head of Finance - Group Reporting
Head of Finance - Group Reporting

Marks & Spencer Group • Greater London

Hybrid
GBP 140,000 - 200,000
20% colleague discount on M&S products
Competitive holiday allowance
Discretionary bonus schemes
+6
Senior Software Engineer - Order Management platform
Senior Software Engineer - Order Management platform

Fa Eqid Saasfaprod1 • United Kingdom

Hybrid
GBP 90,000 - 120,000
20% colleague discount
Discretionary bonus schemes
Pension scheme
+2