About the Role
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.
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
Requirements
- 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
- Data lifecycle management experience
- Experience with non-tabular/event-based data processing and Unity Catalog
Skills
- SQL querying
- Data modelling
- Data architecture
- Data quality management
- Data lifecycle management
- Non-tabular/event-based data processing
- Unity Catalog
Location
- Paddington
- Southampton
Work Type
- Hybrid
- Office-based (12 days/month)
- Occasional travel
Experience Level
- Senior
Benefits
- Competitive benefits package
- Opportunities to stretch and grow your career
About the Company
- Kingfisher is a team of over 74,000 passionate people bringing brands like B&Q, Screwfix, Brico Depot, Castorama and Koctas to life.
- Our purpose is 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.
- We encourage new ideas, support experimentation, and strive to create a workplace where everyone can be their best self.
Equal Opportunity
- 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.
