Datawarehouse Developer

Vor Ort
6 Monate (Verlängerung möglich)
ORCA Solution AG
flag_no Österreich
Jennifer Sloot

Dieses Projekt ist archiviert und leider nicht (mehr) aktiv.
Sie finden vakante Projekte hier in unserer Projektbörse.
We are looking for a DWH Developer in the area of Vienna:

Tasks and Responsibilities:
- Designs and maintains the physical data model of the Group Data Warehouse and related data marts based on the GDWH
- Establishes the foundation for development of data integration/ETL procedures by providing appropriate fine-tuned physical data models implementing business rules specified by Business Analysts through conceptual/logical data models
- Steers and improves the “Data Modeling” process within IM CC
- Defines steps, interactions, metadata and handover of data model instances within modeling activities in IM CC from conceptual/logical data modeling (by Business Analysts), creation and maintenance of physical data models, to usage of physical models (by ETL core and interface developers)
- Acts as communication point between Business, Business Analysts, Developers and Support Engineers
- Presents and explains the physical GDWH data model to ETL and report developers, support engineers and data quality analysts within IM CC, BI CC and NWBs
- Prepares and structures documentation on the data model and metadata of the data model according to needs of business analysis and developers
- Designs, develops and maintains technical and business Metadata models and repositories for GDWH and related components (data models, ETL procedures, interfaces, mappings, connected applications and others)
- Proposes and advises solution designs for Metadata Management solutions to RI Head Office and NWB IT

Job dimensions
- Self-contained acting Subject Matter Expert
- Reports to Team Leader & Development
- Works in close cooperation with:
- Developers and concept design specialists in Development
- Business Analysis, Test Management, Integration & Support teams
- Business Analysts BI Competence Centers
- GDWH developers and business analysts in NWBs

- Minimum 5 Years working experience in the area of Data Warehouse and Business Intelligence
- Deep understanding and 3 years working experience with conceptual, logical and physical as well as relational and dimensional Data Warehouse modeling principles
- Deep understanding of Teradata, MIS, Finance & Controlling and OFSA is a must
- Good understanding and experience with software development life cycles
- Cross cultural as well as cross-hierarchical communication skills
- Good understanding of Information Management Infrastructure concepts and tools (Data Warehousing, Metadata Management, Master Data Management, Data Integration, Data Quality)
- Deep understanding and working experience with data modeling tool(s) (preferably PowerDesigner), Oracle 10/11g RDBMS, SQL and PL/SQL, Metadata Management repositories and tools (preferably ASG Rochade)
- Excellent command of English
- Teamwork oriented
- Willingness to travel up to 20%


6 months with option on extension (up to 1 year or more)

Should you wish to apply, please send your latest CV in WORD format together with your availability and the ALL INCLUSIVE rate in Swiss Francs you require.

ORCA Solution AG
Aeschengraben 10
4010 Basel

Telefon: +41 (0)
ORCA Solution AG