Lead Data Designer
Kingfisher plc
Get a reply from this employer
Your resume and cover letter, tailored to exactly what they’re hiring for.
Benefits offered by this job
Job summary
Kingfisher plc in Kraków is seeking a Lead Data Designer to shape how data is ingested from source systems into the Enterprise Data Warehouse and transformed for reporting. You will define data mappings, ensure coherence with data models, and partner with Data Engineers, Architects and QA to deliver robust data solutions.
Fluent English and 5 years in data modelling/architecture are required. You will collaborate across teams, participate in design reviews, and mentor junior designers.
Qualifications
- Fluent English and senior data modeling/architecture experience.
- Experience designing data ingestion and data warehouse solutions.
- Familiarity with non-tabular and event-based data processing.
- Ability to document data mappings and harmonisation clearly.
- Knowledge of security and access control concepts is a plus.
Responsibilities
- Design data warehouse solutions driven by business demand.
- Clarify complex requirements with the business to ensure delivery.
- Identify and document data sources and profile their contents.
- Create and maintain logical/physical data models for warehouses.
- Create/update source-to-target mappings and data transformations.
- Support Data Engineers in implementation and delivery.
- Support Quality Engineers in testing data warehouse objects.
- Provide guidance to junior team members on data management.
Skills
Tools
Job description
We’re Kingfisher, a team made up of over 74,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:
- 27,000 - 31,000 PLN gross per month on an employment contract
- 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
Overview
Who we are and what we create?
We’re Kingfisher, a team made up of over 74,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:
- 27,000 - 31,000 PLN gross per month on an employment contract
- 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
Role Purpose:
The Lead Data Designer role supports the business by deciding what data should be ingested from source systems into the Enterprise Data Warehouse, and how this data should be transformed to make it suitable for consumption in reporting or other downstream systems.
The role is accountable for: analysing and documenting source systems’ data as needed to meet the business requirements; determining the method and frequency for ingesting the data into the data warehouse; defining and documenting any data mapping, harmonisation, derivations, calculations, or other transformations required to make the data easy to use by the business; ensuring that the target data model is coherent and works in conjunction with the other data models in the data warehouse.
Responsibilities:
- Designing data warehouse solutions driven by business demand
- Understanding difficult solution requirements, working with the business to clarify them if necessary
- Identifying and documenting the possible data sources that may be required and analyse/profile the data they contain working with the source system and/or business experts to understand how the business processes create and update data
- Creating and maintaining logical and physical data models for the data warehouse solutions, working with the Platform Data Architect to ensure they fit with the data roadmap and principles
- Creating and updating source to target data mappings, defining transformations and calculations, and capturing metadata (e.g. attribute definitions, datatypes, PII classification, etc.) working with the Platform Principal Data Designer to make sure they are in line with our principles and conventions
- Supporting Data Engineers in the implementation of the designs
- Supporting Quality Engineers in the testing of the data warehouse objects
- Providing guidance to more junior members of the team on all aspects of data management and modelling
- Supporting the wider team with other ad-hoc design or analysis work
What's the job
Role Purpose:
The Lead Data Designer role supports the business by deciding what data should be ingested from source systems into the Enterprise Data Warehouse, and how this data should be transformed to make it suitable for consumption in reporting or other downstream systems.
The role is accountable for: analysing and documenting source systems’ data as needed to meet the business requirements; determining the method and frequency for ingesting the data into the data warehouse; defining and documenting any data mapping, harmonisation, derivations, calculations, or other transformations required to make the data easy to use by the business; ensuring that the target data model is coherent and works in conjunction with the other data models in the data warehouse.
Responsibilities:
- Designing data warehouse solutions driven by business demand
- Understanding difficult solution requirements, working with the business to clarify them if necessary
- Identifying and documenting the possible data sources that may be required and analyse/profile the data they contain working with the source system and/or business experts to understand how the business processes create and update data
- Creating and maintaining logical and physical data models for the data warehouse solutions, working with the Platform Data Architect to ensure they fit with the data roadmap and principles
- Creating and updating source to target data mappings, defining transformations and calculations, and capturing metadata (e.g. attribute definitions, datatypes, PII classification, etc.) working with the Platform Principal Data Designer to make sure they are in line with our principles and conventions
- Supporting Data Engineers in the implementation of the designs
- Supporting Quality Engineers in the testing of the data warehouse objects
- Providing guidance to more junior members of the team on all aspects of data management and modelling
- Supporting the wider team with other ad-hoc design or analysis work
Required Skills:
- Strong attention to detail
- A collaborative approach to work
- 5 years experience as a data modeller/data architect, with proven experience in modelling high-complexity data
- Experience in working with non-tabular data and event-based data processing
- Fluency in English, both written and spoken
- Knowledge of Databricks Unity Catalog – especially metadata and system tables
- Understanding of row-level security and attribute-based access control
What we offer.
Private medical healthcare at LUXMED (including dental care) for you and your family.
Medicover sports card (Fit&More package).
Language courses, accounting courses, access to LinkedIn Learning and the possibility of co-financing studies and certification.
Life insurance at Generali financed by the employer.
Opportunity to earn annual bonus that aligns to work level of role.
Parking spaces and LOTOS card.
Co-financing of monthly tickets.
Co-financing of monthly tickets for the public transport in Krakow (50% discount).
At Kingfisher, being all-in means contributing fully to our ambitions, supporting one another, and helping create a culture where we succeed together.
Continuously curious. Listen to understand. Always improving.
We are brave
Aim high. Act with courage. Move with pace.
We win together
Lead with customer. Commit to deliver. Help each other win.
Our employees know us best. We wouldn’t be Kingfisher without them. So, we want to share what they think with you.
Development and progression is a high priority at Kingfisher, I’ve always felt well supported.
I’m proud to work for Kingfisher, I’ve had great opportunities that have enabled me to contribute to an exciting forward-thinking company.
There are so many ways you can grow, learn, and develop here at Kingfisher. At whatever pace suits you.
Improving without instruments to help you learn is near impossible. That's why we make sure you have everything at your fingertips to find exactly what you need to keep growing.
With plans that ask you what you want to achieve and when you want to achieve them by, tracking progress and keeping development at the forefront of conversation is easy.
The scale of group functions within Kingfisher is huge. That means you have the chance to build different career paths within multiple areas of the organisation.
We aren't selfish here at Kingfisher. Whatever your level of experience, you'll work with colleagues who are always welcoming and ready to share their knowledge whenever you need it.
So your ambitions are high? Good thing we have opportunities to find experiences in line with more senior roles and responsibilities. Here, you can evolve your career, no matter your level.
We’re an innovative, international retailer on a journey to actively make a difference. Always striving to take that next step. You can be part of the difference. From bottom to top you can progress in a collaborative environment. So, why not Kingfisher?
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
