Senior Data Warehouse Modeller

Kingfisher plc; Kraków; On-site; PLN 256,680 - 312,480; Full time

Benefits offered by this job

Private medical healthcare

Life insurance

Sports card

Co-financing of studies

Wellbeing programme

Probation period training

Job summary

A leading home improvement company in Kraków is seeking a Senior Data Warehouse Modeller to design and maintain data warehouse solutions. This role involves collaborating with business teams to clarify requirements, identifying data sources, and supporting the implementation of data models. Candidates should have at least 2 years of data modelling experience or 5 years of data warehousing experience, strong SQL skills, and an understanding of data lifecycle management. The position offers a competitive salary and a flexible work environment.

Qualifications

• 2 years experience as a data modeller or 5 years experience working with data in data warehouses.
• Understanding of data lifecycle management.
• Experience working with data in Databricks.

Responsibilities

• Design data warehouse solutions driven by business demand.
• Understand and clarify difficult solution requirements.
• Identify and document possible data sources.
• Create and maintain logical and physical data models.
• Maintain source to target data mappings and transformations.
• Support Data Engineers and Quality Engineers in implementation.
• Provide guidance to junior team members on data modelling best practices.

Skills

Intermediate-level SQL querying

Attention to detail

Collaborative approach

Curious mindset

Data modelling experience

Non-tabular data processing

Data lifecycle management knowledge

Experience with Databricks

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.

Competitive Benefit Package

• 23,000 - 28,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 Senior Data Warehouse Modeller 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 junior members of the team on data modelling and/or technical best practices
• Supporting the wider team with other ad-hoc design or analysis work

Required skills

• Intermediate-level SQL querying, including data profiling
• Strong attention to detail
• A proactive and curious mindset
• A collaborative approach to work
• 2 years experience as a data modeller or 5 years experience of working with data in data warehouses
• Experience of non-tabular data and event-based data processing
• Understanding of data lifecycle management
• Experience of working with data in Databricks

Private Health Care

Private medical healthcare at LUXMED (including dental care) for you and your family.

Child Insurance

Life insurance at Generali financed by the employer.

Sports Card

Medicover sports card (Fit&More package).

Courses

Language courses, accounting courses, access to LinkedIn Learning and the possibility of co-financing studies and certification.

Life Assurance

Life insurance at Generali financed by the employer.

Bonus

Opportunity to earn annual bonus that aligns to work level of role.

Parking

Parking spaces and LOTOS card.

Kingfisher Pension Scheme

Co-financing of monthly tickets.

Transport Discount

Co-financing of monthly tickets for the public transport in Krakow (50% discount).

Our Behaviours

At Kingfisher, we are united by our 6 core behaviours

Constantly improving our customer experience

Acting with humanity and care

Be curious

Thriving on learning, thinking beyond the obvious

Be inclusive

Acting inclusively in diverse teams to achieve together

Be agile

Working with trust, pace and agility

Be accountable

Championing the plan to deliver results and growth

Training & Development

There are so many ways you can grow, learn, and develop here at Kingfisher. At whatever pace suits you.

Application Process

Step 1: Application – Send in your application via our Kingfisher Careers website.

Step 2: Review – A member of the Talent Acquisition team will then review your application and let you know if you have progressed to the next stage of the process.

Step 3: Interview 1 – You’ll then have a telephone interview/one to one conversation with a recruiter.

Step 4: Interview 2 – As you progress, you’ll be invited to attend a face to face or virtual interview.

Step 5: Feedback – Your recruiter will be in contact with feedback and, if successful, the details of your job offer!