Data Architect (OLTP, OLAP, XML, BI, ETL, Togaf)- Amsterdam, Holland

DATA ARCHITECT (OLTP, OLAP, XML, BI, ETL, TOGAF)- AMSTERDAM, HOLLAND - ENGLISH SPEAKING - 12 MONTHS+

(ARCHITECT, ARCHITECTURE, OLTP, OLAP, XML, BI, ETL, TOGAF)

One of our Blue Chip Clients is looking for a Data Architect.

This role will initially be based in London for the first 1-2 months and then the remaining 10 months in Amsterdam.

PLEASE FIND SOME DETAILS BELOW:

Domain Expertise: Data Architecture and Datamodelling for transactional and dimensional systems

Professional qualifications

Relevant professional qualifications in the domain of Enterprise Data Architecture and TOGAF are desirable

Role specific experience

Experience in designing and reviewing conceptual, logical and physical data models, for relational (OLTP), dimensional (OLAP) and document oriented (XML, JSON) databases.

Experience of the full development life cycle of complex large scale and multi-user applications.

Experience in designing and implementing data warehouses, reporting solutions (BI) and data integration flows and batch processes (ETLs).

Experience with and proficient knowledge of the following tools:

o PowerDesigner,

o Sparx Enterprise Architect,

o XML Spy,

o TOAD and SQL Developer,

o ETL tools (eg Oracle Data Integrator, Informatica Data Quality),

o Business Intelligence tools (eg Oracle BI Publisher, Oracle Business Intelligence Enterprise Edition),

Ability to negotiate with stakeholders at all levels.

Desired knowledge of design patterns of ETL-based integrations within large organisations.

Desired experience with data models and standards in the pharmaceutical and medical domains.

Desired experience with working with and designing resources structure for RESTful APIs.

Advanced level knowledge and understanding of application design, systems engineering and integration, in particular in the areas related to the key responsibilities described.

Experience in data design governed by Enterprise Data Architecture is desirable, preferably using TOGAF.

Experience with RUP or comparable systems engineering disciplines.

Role specific skills, competencies

o Develop and maintain logical and physical data models (both transactional and dimensional);

o Develop and maintain canonical message models;

o Reverse engineer and document physical database schemas;

o Define source-to-target mappings for data migrations.

Communication abilities:

o Able to summarise and present successfully key technical issues to the relevant stakeholders (developers, analysts, peers, management and business users) considering the background of the audience;

o Prepare and deliver formal presentations to the relevant stakeholders;

o Experience in managing interactions between the data architecture team and other stakeholders (database administrators, software architects, business analysts, testers, support, management, business, etc.);

Demonstrable leadership capabilities are mandatory.

Please send CV for full details and immediate interviews. We are a preferred supplier to the client.