Člen DRILL® Business Services Group
Otevřené projekty
Senior Data/DWH/BI Consultant – freelance – Praha 8

Senior Data/DWH/BI Consultant – freelance – Praha 8

Location: Praha 8 – M-Českomoravská
Start: ASAP
Length of cooperation: longterm
Alocation: 100%
Form of cooperation: IČO – freelance - bodyshop

Most of the work is analysis related, rather than development related
DWH DB Engine: Oracle
DWH ETL Engine: ING Data Stage

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

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


 If you are interested in this project, contact Lucka and send her your CV or link to LI as soon as possible on lucie_vostalova@quicksource.cz.

Thank you.