Lead Data Warehouse Modeller/Architect

Lead Data Warehouse Modeller/Architect

Who we are and what we create?

We’re Kingfisher, a team made up of over 82,000 passionate people who bring Kingfisher - and all our other brands: Castorama, B&Q, Screwfix, Brico Dépôt and Koçtaş - to life. That’s right, we’re big, but we have ambitions to become even bigger and even better. We want to become the leading home improvement company and grow the largest community of home improvers in the world. And that’s where you come in.

At Kingfisher, our customers come from all walks of life, and so do we. We want to ensure that all colleagues, future colleagues, and applicants to Kingfisher are treated equally regardless of age, gender, marital or civil partnership status, colour, ethnic or national origin, culture, religious belief, philosophical belief, political opinion, disability, gender identity, gender expression or sexual orientation.

We are open to flexible and agile working. Therefore, we offer colleagues a blend of working from home and our office, located in Kraków. Talk to us about how we can best support you! 

At Kingfisher, we value the perspectives that any new team members bring, and we want to hear from you. We encourage you to apply for one of our roles, even if you do not feel you meet 100% of the requirements.

In return, we offer an inclusive environment, where what you can achieve is limited only by your imagination! We encourage new ideas, actively support experimentation, and strive to build an environment where everyone can be their best self.

We also offer a competitive benefit package and plenty of opportunities to stretch and grow your career: 

• Private medical healthcare at LUXMED (including dentalcare) for you and your family
• Medicover sports card (Fit&More package)
• Life insurance financed by the employer
• 30-minute lunch break included in the 8-hour working day
• Work in a highly professional and stimulating atmosphere
• Training & Buddy programme that will allow you to quickly adapt to your new role
• Wellbeing programme for employees
• Co-financing of monthly tickets for the public transport in Krakow
• Comfortable working environment in the office and the possibility of home office
• Language courses, accounting courses, access to LinkedIn Learning and the possibility of co-financing studies and certification
• Employee referral programme

You no longer need to relocate to get the benefits of working in Kraków.
But you can stick to your routine if you want to.
Join Kingfisher and work remotely.

Purpose of the role:

In this role, you will be responsible for creating high-quality Enterprise Data Warehouse data designs. This includes understanding and documenting data sources, ingestion processes, data mappings, and data modelling. You will define key aspects such as data harmonization, calculations, derivations, and transformation logic to ensure consistency and accuracy. 
Additionally, you will lead, mentor, and manage a small team of data designers, guiding them to follow best practices and adhere to established data design standards and principles.

• Design and document ingestions from existing sources
• Collaborate with Principal Data Designer to design and document ingestions from new sources
• Collaborate with stakeholders and data platform teams to create designs that meet or exceed requirements, comply with principles, with supporting documentation delivered accurately and on time
• Keep up to date with the data design principles and be able to explain their benefit and relevance to others
• Identify potential new data design principles
• Contribute to improvements to ways of working and documentation templates
• Peer review colleagues designs to ensure that they meet the requirements and conform to the agreed data design principles
• Ensure junior team members are following the appropriate agreed ways of working
• Support other workstreams by picking up additional data design work when capacity allows
• Support data designer recruitment and onboarding when required

• Advanced Data modelling for enterprise data warehouses
• Works with existing network to expand knowledge
• Gathers and documents relevant documentation beyond guidance
• Understands deliverables and analyses available information and makes sound decisions in an uncertain environment
• Works collaboratively in agile development process
• Engages with key stakeholders inside and outside of own area and experts in the wider team to make good design decisions
• Strong attention to detail
• Supports the wider design team by considering other perspectives and constructively challenging decisions during design review sessions
• Communicates clearly and effectively, in a style which elicits trust
• Manage and mentor a small team
• Proactively works on own development, learning about areas outside own role
• Provides guidance for others to develop themselves
• Excellent command of English (written and spoken)
• Querying and transforming data using SQL, Python/PySpark
• Conducting detailed data profiling and analysis
• Modelling data into a complex facts and dimensions, identifying suitable mappings, aggregations and snapshot tables where appropriate
• Identifying complex data quality rules, considering alternative sources and volumetric analysis