Data Warehouse Modeller

Quick Facts

• Role: Data Warehouse Modeller
• Focus: Enterprise Data Warehouse design, data ingestion, transformations, and mappings

Description

The Data Warehouse Modeller supports the business by deciding what data to ingest from source systems into the Enterprise Data Warehouse and how to transform it for reporting and other downstream systems. You will analyze and document source systems’ data, define ingest methods and frequency, and ensure the target data model is coherent with other warehouse models. The role also includes creating and maintaining logical and physical data models, source-to-target mappings, and transformation logic along with metadata.

Responsibilities

• Design data warehouse solutions driven by business demand
• Analyze and profile potential data sources and document how business processes create and update data
• Create and maintain logical and physical data models for warehouse solutions
• Define and document source-to-target data mappings, transformations, calculations, and required metadata (e.g., attribute definitions, datatypes, PII classification)
• Support Data Engineers with implementation of the designs
• Support Quality Engineers with testing of data warehouse objects

Requirements

• Intermediate-level SQL querying
• Strong attention to detail
• Proactive and curious mindset
• Collaborative approach to work
• 2 years experience working with data warehouses OR 5 years experience working with MI/BI data
• Fluency in English (written and spoken)

Benefits

• Competitive salary (16,000–24,000 PLN gross per month)
• Private medical healthcare (LUXMED, including dentalcare) for you and your family
• Medicover sports card (Fit&More package)
• Employer-paid life insurance
• Paid 30-minute lunch break within the 8-hour day
• Training & Buddy programme
• Language courses and access to LinkedIn Learning; co-financing studies and certification
• Wellbeing programme
• Co-financing monthly public transport tickets in Kraków
• Flexible working with home office and office in Kraków