Power BI & Data Modeling Lead (Hybrid)

M&S; Greater London; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading retail company in Greater London seeks a Power BI Modelling Expert to build and own large-scale Power BI semantic models. Key responsibilities include gathering requirements, collaborating with data engineering, and providing user enablement. The ideal candidate will have deep knowledge of DAX, strong SQL skills, and experience designing star schemas. This role offers competitive benefits, including a 20% colleague discount and a Defined Contribution Pension Scheme, in a hybrid work environment.

Benefits

20% colleague discount

Competitive holiday entitlement

Discretionary bonus schemes

Defined Contribution Pension Scheme

Dedicated welcome and tailored induction

Wide range of training programmes

Wellbeing support programs

Charity volunteer day

Qualifications

• Deep knowledge of DAX and dimensional modelling.
• Able to analyse query plans for data lake optimisations.
• Experience with Fabric is a plus.

Responsibilities

• Build & own largescale Power BI semantic models.
• Gather requirements with business analysts & product management.
• Partner with data engineering to design dimensional models.
• Define and validate gold layer tables and views for BI.
• Deliver training and support for report builders.

Skills

Power BI Modelling Expert

Strong SQL knowledge

Experience designing star schemas

Familiarity with DAX Studio

Collaboration with technical teams

Tools

Databricks

Python

Spark

Job description

A leading retail company in Greater London seeks a Power BI Modelling Expert to build and own large-scale Power BI semantic models. Key responsibilities include gathering requirements, collaborating with data engineering, and providing user enablement. The ideal candidate will have deep knowledge of DAX, strong SQL skills, and experience designing star schemas. This role offers competitive benefits, including a 20% colleague discount and a Defined Contribution Pension Scheme, in a hybrid work environment.