Data Warehouse Modeller

Quick Facts

Role: Data Warehouse Modeller

Purpose: Decide what data to ingest from source systems into the Enterprise Data Warehouse and how to transform it for reporting and downstream consumption.

Description

You will analyze and document source system data, determine how and how often it is ingested into the data warehouse, and define the mappings and transformations needed to make data usable for the business. You will create and maintain coherent logical and physical data models that work alongside other warehouse models.

Responsibilities

• Design data warehouse solutions driven by business demand
• Clarify solution requirements with the business
• Identify and document data sources; analyze/profile contained data; work with source and business experts to understand how data is created and updated
• Create and maintain logical and physical data models, aligning with the platform data architect and the data roadmap/principles
• Define and maintain source-to-target mappings, transformations, calculations, and required metadata (e.g., attribute definitions, datatypes, PII classification)
• Support Data Engineers in implementing the designs
• Support Quality Engineers in testing the data warehouse objects

Requirements

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

Benefits

• 16,000–24,000 PLN gross per month
• Private medical healthcare (LUXMED, including dentalcare)
• Medicover sports card (Fit&More package)
• Employer-paid life insurance
• 30-minute lunch break included in the 8-hour day
• Training & Buddy programme
• Language courses and access to LinkedIn Learning
• Wellbeing programme
• Co-financing of monthly public transport tickets in Kraków
• Comfortable office environment with possibility for home office