Data Architect (OLTP, OLAP, XML, BI, ETL, TOGAF)- Amsterdam, Holland -
Posted on Dec 8, 2018 by Octopus Computer Associates
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
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 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 & responsibilities
Develop modelling standards, guidelines and best practices.
Contribute to the enterprise and projects specific data architecture and business reporting and information flow design.
Develop and maintain subject area conceptual data models for relational, dimensional and document oriented systems.
Take part in the peer review of data related deliverables.
The Data Architect will also play the role of Data Modeller when required, and as such, will:
o Capture, model and describe data requirements, data definitions, business rules, data quality requirements, data security requirements;
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.
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.
Contracts IT Ltd
Ubique Systems UK Limited
Gazelle Global Consulting