Data Warehouse Modeller

Kingfisher plc

Kraków

Hybrid

PLN 179,000 - 268,000

Full time

8 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Private medical healthcare for you and

Medicover sports card

Life insurance financed by the company

Lunch break included in 8-hour workday

Wellbeing programme

Co-financing of monthly tickets for Kr

Office with home office option

Language courses and LinkedIn Learning

Employee referral programme

Job summary

Kingfisher plc in Kraków is seeking a Data Designer to shape how our data is ingested into the Enterprise Data Warehouse and transformed for reporting and downstream use.

You will analyse source systems, define mappings, and work with Data Engineers and BI teams to ensure a coherent target data model aligned with the data roadmap. This role offers a hybrid office-and-home working arrangement and a supportive environment to grow your data career.

Qualifications

Intermediate-level SQL querying.
Strong attention to detail.
A proactive and curious mindset.
A collaborative approach to work.
2 years experience of working with data in data warehouses or 5 years experience working with MI/BI data.
Fluency in English, both written and spoken.

Responsibilities

Designing data warehouse solutions driven by business demand.
Understanding straightforward solution requirements, working with the business to clarify them if necessary.
Identifying and documenting the possible data sources that may be required and analysing/profiling the data they contain.
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

Skills

SQL querying

Attention to detail

Proactive mindset

Collaborative

2 years data warehousing OR 5 years MI

English fluency

Job description

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.

Who we are and what we create?

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:

16,000 - 24,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

What's the job?

Role Purpose

The 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 straightforward solution requirements, working with the business to clarify them if necessary
Identifying and documenting the possible data sources that may be required and analysing/profiling 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

What You'll Bring

Required skills:

Intermediate-level SQL querying
Strong attention to detail
A proactive and curious mindset
A collaborative approach to work
2 years experience of working with data in data warehouses or 5 years experience working with MI/BI data
Fluency in English, both written and spoken

Desirable Experience