Senior Data Modeller

Kingfisher plc; Greater London; Hybrid; GBP 70,000 - 100,000; Full time

Benefits offered by this job

Competitive benefits package

Job summary

Kingfisher plc is seeking a Senior Data Designer to define ingested data for the Enterprise Data Warehouse and shape transformations for reporting. The role combines design, documentation, and collaboration with data engineers, with 12 days per month in the office and some travel to Banner offices and Krakow.

You will model data, define mappings, and ensure coherent target data models aligned with the data roadmap.

Qualifications

• Experience as data modeller or data architect with complex data modelling.
• Strong SQL querying and data quality management abilities.
• Familiarity with non-tabular data concepts; Unity Catalog is a plus.

Responsibilities

• Design performant, user‑friendly data warehouse models for reporting and insights.
• Translate business requirements into data model designs with stakeholders.
• Identify, analyse, and document source systems and data changes.
• Develop and maintain logical and physical data models aligned with roadmaps.
• Define source‑to‑target mappings, transformations, and metadata.
• Collaborate with Data Engineers and QA to support delivery and junior team members.

Skills

Data modelling

Data architecture

SQL

Data quality management

Unity Catalog

Tools

Unity Catalog

Job description

We’re Kingfisher, A team made up of over 74,000 passionate people who bring Kingfisher - and all our other brands: B&Q, Screwfix, Brico Depot, Castorama and Koctas to life. Guided by our purpose Better Homes. Better Lives. For Everyone. We believe a better world starts with better homes, and we work every day to make that a reality. Join us and help shape the future of home improvement.

Role purpose

The Senior Data Designer defines what data is ingested into the Enterprise Data Warehouse and how it is transformed for reporting and downstream use. The role involves analysing and documenting source system data, designing data ingestion methods and frequencies, and specifying mappings, transformations, and calculations. You will ensure the target data models are coherent, well‑documented, and aligned with the wider data warehouse architecture to support clear, business‑ready insights. This role will be based out of our Kingfisher office in Paddington or Southampton, with an expectation of 12 days a month in the office and could also include a combination of store visits, supplier visits and conferences. There will also be occasional travel to Banner offices and GBS Krakow.

What's the job?

• Design performant, user‑friendly data warehouse models that enable business reporting and insights
• Translate complex business requirements into effective data model designs, working with stakeholders to clarify needs
• Identify, analyse, and document source systems and data, collaborating with subject‑matter experts to understand data creation and changes
• Develop and maintain logical and physical data models aligned with the data roadmap and architectural principles
• Define and maintain source‑to‑target mappings, transformations, calculations, and metadata in line with design standards
• Collaborate with Data Engineers and Quality Engineers to support development, testing, and delivery, while providing guidance to junior team members and supporting ad‑hoc work

What You'll Bring

• Experience as a data modeller or data architect, including modelling complex data
• Intermediate to advanced SQL querying skills
• Strong attention to detail with a collaborative approach to work
• Experience in data quality management
• Desirable: Data lifecycle management experience
• Desirable: Experience with non‑tabular/event‑based data processing and Unity Catalog

How We Work

We believe in flexibility and balance. Our hybrid model blends home working for focus with time spent connecting and collaborating - whether in our offices or at offsite locations. On average, around 60% of your time will involve in-person collaboration. We value the perspectives new team members bring.

What We Offer

An inclusive environment where your potential is limited only by your imagination. We encourage new ideas, support experimentation, and strive to create a workplace where everyone can be their best self. Find out more about Diversity & Inclusion at Kingfisher here. We also offer a competitive benefits package and plenty of opportunities to stretch and grow your career.

Diversity & Inclusion

Our customers come from all walks of life - and so do we. We’re committed to ensuring all colleagues, future colleagues, and applicants are treated equally, regardless of age, gender, marital or civil partnership status, ethnicity, culture, religion, belief, political opinion, disability, gender identity, gender expression, or sexual orientation.