Senior Data Warehouse Modeller

Quick Facts

Role: Senior 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

The Senior Data Warehouse Modeller analyzes and documents source system data, defines ingestion methods and frequencies, and specifies transformations and mappings so the target data model is coherent and usable for the business. You will create and maintain logical and physical data models, capture metadata (including attribute definitions, datatypes, and PII classification), and partner with architects, data engineers, and quality engineers to implement and test the designs.

Responsibilities

• Design data warehouse solutions driven by business needs
• Analyze and profile potential data sources; understand how business processes create and update data
• Create and maintain logical and physical data models; align with platform data architecture and roadmap
• Define and update source-to-target mappings, transformations, calculations, and metadata
• Support Data Engineers with implementation
• Support Quality Engineers in testing data warehouse objects
• Guide junior team members on data modelling and technical best practices
• Provide ad-hoc design and analysis support to the wider team

Requirements

• 2+ years experience as a data modeller or 5+ years working with data in data warehouses
• Intermediate-level SQL querying, including data profiling
• Experience with data quality management
• Fluency in English (written and spoken)
• Strong attention to detail
• Proactive and curious mindset
• Collaborative approach to work

Benefits

• 23,000–28,000 PLN gross per month
• Private medical healthcare (including dental) for you and your family
• Medicover sports card (Fit&More)
• Employer-financed life insurance
• 30-minute lunch break included in the 8-hour working day
• Training & Buddy programme
• Wellbeing programme for employees
• Co-financing of monthly public transport tickets in Kraków
• Home office option and comfortable office environment
• Language courses, access to LinkedIn Learning, and support for studies/certifications
• Employee referral programme