BRCA20013

Data Modeller – Senior

Location

Brussels area

Category:

Project description:

Our customer is currently looking for a Senior Data Modeller. Based on the defined Data Architecture, the Data Modeler designs and documents data modelling solutions, which translate complex business data into usable logical data models. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests.


The Data Modeler is responsible for the development of the logical data models designed to improve efficiency and outputs, and of the Data Vault and Data Marts.
Next to that he is also responsible for the analysis of the data needed for reporting (data needs, data business rules, data transformation rules, data profiling, SQL statements).

Responsibilities:

Primary Tasks and responsibilities
Analyse the reporting data needs:
• The Data Modeler identifies what data is needed, what are the related business and transformation rules, and how they are stored in the different data sources (data profiling). The Data Modeler can also propose / review the SQL statements to the Data Reporting Team for using the EDW model.
• Analyse the Reporting Data Needs: Data Modelers identify what data is needed, what are the related business and transformation rules, and how they are stored in the different data sources (data profiling). They can also propose / review the SQL statements for using the EDW model to the Data Reporting team.

Design, implement, maintain, and extend logical data models:
• The Data Modeler designs and documents data modelling solutions, which translate complex business data into usable logical data models. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests. The Data Modeler is responsible for the development of the logical data models designed to improve efficiency and outputs, and of the Data Vault and Data Marts.
• Analyse the Data Model Needs: Data Modelers analyse the business requirements concerning the data model needs. Gather data model requirements and process knowledge in order to model the data so that it corresponds to the needs of end users
• Design, Create and Maintain Data Models: Data Modelers work closely with the Data Architects and the Database Engineers to create optimal logical data models, then create and maintain data maps and systems interrelationship diagrams. The Data Modeler designs data models that translate complex business data into usable systems (Data Vault, Data Marts).
• Propose and Follow Data Modeling Standards and Best Practices: Data Modelers propose and follow data modelling standards, tools and best practices.
• Ensure that the solution is scalable, performant, maintainable, correct, and of high quality.
• Ensure that the solution is fully documented.

Ensure Security, Testing and Support:
• The Data Modeler ensures the Security and the Testing of the new solutions, and also provides the necessary support.
Tasks:
• Ensure Security: Data Modelers ensure the security management to protect the data in the Data Vault and Data Marts, and the IT infrastructure.
• Ensure Testing: After the data model is up and running, Data Modelers test their data models to ensure they respond to the business requirements (quality, coherence, performance). They fix problems that may pop up. They guarantee the integrity of the data model (assure the proper maintenance and functioning).
• Ensure Support: Data Modelers provide support in case of client requests / incidents / problems.


Technical skills:

Technical profile requirements
• Expert practical and theoretical knowledge of Data Vault Modelling Principles / Methods including Conceptual, Logical & Physical Data Models, Data Vault, Dimensional Modelling
• Expert practical and theoretical knowledge of Data Mart
• Expert knowledge of the Data profilin
• Expert knowledge of SQL (DDL) & SQL (Querying, optimization of queries)
• Working knowledge of IBM Data Architect software
• Good knowledge of ETL tools and development (DATASTAGE)
• Good knowledge of Test Principles (Test Scenarios / Test Use Cases and of Testing)
• Good knowledge of ITIL
• Good knowledge of OLAP
• Good knowledge of NoSQL databases
• Good knowledge of Hadoop Components – HDFS, Spark, Hbase, Hive, Sqoop
• Good knowledge of Big Data
• Good knowledge of Data Science / Machine Learning / Artificial Intelligence
• Good knowledge of Data Reporting Tools (TABLEAU)
• Very good knowledge of Data analysis and modelling tools (IBM DATA ARCHITECT)
• Very good knowledge of SQL and/or PL/SQL
• Very good knowledge of Relational databases (IBM DB2 LUW)
• Very good knowledge of Data warehouse appliances (NETEZZA)
• Very good knowledge of Atlassian Suite: JIRA / CONFLUENCE / BITBUCKET


Methodology/Certification requirements
- Bachelor/Master's Degree Science and Informatics, or an equivalent experience.
- Expert knowledge of Agile methodology

Soft skills:

Language proficiencies
• FR+NL is a must
• ENG

Contact person:

Contact name: Yves Cambron