Overview

For an international institution based in Amsterdam, we are urgently looking for a (Senior) Data Architect, specialised in data, ETL and BI.

This is an 100% remote position. Candidates need to be fluent in English. Candidates need to be based in Europe and in the position of a workpermit. This position is also open for freelancers, who would like to commit long-term.
This role can be performed remote from any EU country.

Tasks and responsibilities:

  • Develop modelling standards, guidelines and best practices;
  • 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;
  • lay the role of Data Modeller when required, and as such, will:
  • Capture, model and describe data requirements, data definitions, business rules, data quality requirements, data security requirements;
  • Develop and maintain logical and physical data models (both transactional and dimensional);
  • Develop and maintain canonical message models;
  • Reverse engineer and document physical database schemas;
  • Define source-to-target mappings for data migrations;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;
  • Prepare and deliver formal presentations to the relevant stakeholders;
  • Experience in managing interactions between the architecture team and other stakeholders (database administrators, software architects, business analysts, testers, support, management, business, etc.);

Profile:

  • Bachelor or Master degree in an IT related field;
  • +8 years of experience in a similar role.
  • 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 lifecycle of complex large scale and multi-user applications;
  • Experience in designing and implementing data integration flows and batch processes (ETLs);
  • Experience with and proficient knowledge of the following tools:
  • PowerDesigner, Sparx Enterprise Architect, XML Spy, TOAD and SQL Developer, ETL tools (e.g. Oracle Data Integrator, Informatica Data Quality) and/or Business Intelligence tools (e.g. 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;
  • Relevant professional qualifications in the domain of Enterprise Data Architecture and TOGAF are desirable;
  • Fluent in English;

Interested:
Please send your resume to resume@all-european-careers.com.