Data Warehouse Consultant (20519)

Praha
4/2020 (9m)
Contract via CP
10%
140 000 CZK
« back
This job position is not currently open
Are you looking for a job opportunity in the banking field where you will push your knowledge of SQL and commercial experience with Data Warehouse design/architecture much forward? For our client from banking field I’m currently looking for Data Warehouse Consultant to help bring a new product to the production and integrate the new system to current Data/DWH/BI environment.

What will you be working on:
- create DWH data layers and complete BI reporting (regulatory and operational)
- integrate new (data processing) systems to current Data/DWH/BI environment
- analyze business requirements and translate them to a technical specification
- develop Data Transformations in IBM Data Stage (and given framework)
- design complex data models following group definitions
- migrate existing ETLs & reporting to a new DWH solution
- implement Data Quality rules and mappings
- communicate with group vendors on solution sub-delivery

What you need to know:
- at least 4 years relevant experience in a similar position
- advanced knowledge of SQL.
- experience with relational and dimensional data modelling
- general understanding of ETL processes
- knowledge and commercial experience with Data Warehouse design/architecture
- analytical thinking and technical focus
- english written and spoken

Nice to have:
- experience in the banking industry
- understanding of visual modelling notations and ability to use them in practice (UML,
  BPMN)
- advanced knowledge of Oracle DBMS
- experience with IBM DataStage, IBM Information Analyzer and/or IBM Governance
  Catalog
- experience with Data Quality management
- english fluent