Senior DWH Analyst

MADIFF

Warsaw, Poland5d ago

Free account needed to apply or save. It takes a minute, and we'll bring you right back to this job.

Key details

Location
Warsaw, Poland
Work style
Hybrid
Level
Senior
Job type
Full-time
Experience
5–8 yrs
Function
Operations & Strategy
Focus area
other
Posted
5d ago

Skills

azuredata analysisdata mappingdata modelingdata qualitydata structuresdata validationdata warehousingdatabricksetlprototypingsqltechnical documentation

About the role

We are looking for a Senior DWH Analyst to support the development and optimisation of complex Data Warehouse solutions within a large-scale banking environment. The role focuses on data modelling, source-to-target mapping, ETL processes, SQL prototyping, and data transformation logic, translating business requirements into detailed technical specifications and scalable data structures. The consultant will work closely with DWH Developers throughout implementation, testing, and data validation, ensuring the accuracy, consistency, and reliability of data processing across multiple source systems.

Responsibilities

• Gather and analyse user requirements
• Translate business requirements into DWH data requirements
• Identify the required information within the data warehouse
• Design target data models
• Identify source systems and source data
• Prepare detailed source-to-target mappings
• Design data processing logic
• Prepare and test SQL prototypes
• Support developers during implementation
• Test completed solutions
• Validate data quality and correctness
• Coordinate technical work related to changes in the DWH
• Prepare analytical and technical documentation

Requirements

• Minimum 5 years experience as a DWH / Data Warehouse Analyst
• Minimum 5 years experience in data modelling and DWH processes
• Very good SQL knowledge
• Practical experience working with data warehouses
• Experience building or developing DWH solutions
• Experience designing data models
• Source-to-target data mapping
• Understanding of ETL and data processing
• Experience analysing data from multiple source systems
• Ability to prepare and validate SQL queries
• Experience working with developers on DWH implementations
• Strong analytical skills
• Fluent Polish
• English minimum B2

Nice to have

• Banking or financial services experience
• Microsoft Azure
• Databricks
• Experience with complex enterprise data environments
• Higher education in IT or a related field

Benefits

• Flexible hybrid work model (1 day/week on-site in Warsaw/Gdańsk/Wrocław)

Get jobs like this as soon as they're posted

ApplyHour checks company career sites all day and ranks every opening against your profile. Free to join.

Create a free account