Senior Data/DWH/BI Consultant – banking


Are you experienced consultant and available to start soon on a new position? Are you freelancer? Let´s work on a current project from banking.

Key Responsibilities:

1. Create DWH data layers and complete BI reporting (regulatory and operational) for a new product: Mortgages

• Analyze business requirements and translate them to a technical specification

• Develop Data Transformations in IBM Data Stage (and given framework) as based on a technical specification

• 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


2. Integrate new (data processing) systems to current Data/DWH/BI environment, assure:

• Dependency analysis

• Data migration (mostly data mapping)

• Systems (technical) onboarding/intake

• System upgrades

• Interface changes


Related notes:

Most of the work is analysis related, rather than development related

DWH DB Engine: Oracle

DWH ETL Engine:  Data Stage

Required Background:

• 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

• Czech fluent

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 Stringdata BTL Trask CRAW