Senior Data Architect: Enterprise Data Warehouse

Kingfisher; Greater London; Hybrid; GBP 75,000 - 110,000; Full time

Job summary

Kingfisher is hiring a Senior Data Designer to decide what data enters the Enterprise Data Warehouse and how it is transformed for reporting and downstream use. Based in our Paddington or Southampton offices, you will work in a hybrid model with around 12 days a month in the office, and occasional store, supplier visits and conferences, plus travel to Banner and GBS Krakow.

You will design performant data warehouse models, translate complex business requirements into clear data designs, document

Qualifications

• Experience as a data modeller or data architect, modelling complex data.
• Strong SQL querying skills and data modelling experience.
• Attention to detail with a collaborative approach to work.
• Experience in data quality management.
• Desirable: data lifecycle management.
• Desirable: Unity Catalog or similar tech.

Responsibilities

• 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.

Skills

Data modelling

SQL

Attention to detail

Data quality

Data lifecycle

Unity Catalog

Job description

Kingfisher is hiring a Senior Data Designer to decide what data enters the Enterprise Data Warehouse and how it is transformed for reporting and downstream use. Based in our Paddington or Southampton offices, you will work in a hybrid model with around 12 days a month in the office, and occasional store, supplier visits and conferences, plus travel to Banner and GBS Krakow.

You will design performant data warehouse models, translate complex business requirements into clear data designs, document