Data Modeler

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).

Primary Tasks and responsibilities : Result Domain 1: Analyse the Reporting Data Needs Objective:

• identify data needs,related business and transformation rules. Tasks:

• identify what data is needed,

• identify what are the related business and transformation rules,

• identify how they are stored in the different data sources (data profiling).

• propose / review the SQL statements to the Data Reporting Team for using the EDW model.

Result Domain 2: Analyse the Data Model Needs Objective:

• analyses the business requirements Tasks:

• analyse the business requirements concerning the data model needs.

• gather the data model requirements and process knowledge

• model the data so that it corresponds to the needs of the end users.

Result Domain 3: Design, Create and Maintain Logical Data Models Objective:

• designs and documents data modelling solutions Tasks:

• work closely with the Data Architects and the Database Engineers to create optimal logical data models,

• create and maintain data maps and systems interrelationship diagrams.

• design data models that translate complex business data into usable systems (Data Vault, Data Marts).

• After the data model is up and running,test data models to ensure they respond to the business requirements (quality, coherence, performance).

• fix problems that may pop up.

• guarantee the integrity of the data model (assure the proper maintenance and functioning).

• ensure the security management to protect the data in the Data Vault and Data Marts, and the IT infrastructure.

• Ensure that the solution is documented, scalable, performant, maintainable, correct, and of high quality.

Result Domain 4: End-to-end Handling of the Assigned Delivery Objective : Handle the assigned delivery in an end-to-end manner Tasks

• Identify and agree with the requester on the requirements of the assigned delivery together with the Team Coordinator, the Project Manager and the Demand Manager
• Analyse the requirements of the assigned delivery
• Document the requirements of the assigned delivery
• Propose a mock-up to the requested if needed and useful for the assigned delivery
• Propose an estimate and a planning for the assigned delivery to the Team Coordinator, the Project Manager and the Demand Manager
• Follow-up on the execution of the assigned delivery
• Inform the Team Coordinator, the Project Manager and the Demand Manager on the advancement or on the impediments of the assigned delivery
• Ensure that the assigned delivery is delivered within estimate, scope and time.
• Propose and demonstrate the assigned delivery during the Sprint Review.

Result Domain 5: Continuous enhancement of the Data Modeling Standards and Best Practices Objective : Identify, propose, assist and support the implementation of the continuous enhancement of the Data Modeling Standards and Best Practices Tasks :

• Identify and propose enhancements concerning the standards and best practices.
• Identify and propose enhancements concerning the processes and the tools.
• Assist and support the implementation of the defined enhancement actions.
• Participate to the Lessons Learned meetings after the finalisation of sprints, change requests, projects or milestones.

Result Domain 6: Ensure Support Objective:

• providing the necessary support in case of client requests / incidents / problems Tasks:

• contact customer to understand the problem/request/incident

• propose a solution to the customer

• adapt solution in function of customers input, proposals,changerequets,…

• implement the final solution

• follow up - after service

• Strong knowledge of Data Modeling Principles / Methods including Conceptual, Logical & Physical Data Models, Data Vault, Dimensional Modelling

• Strong knowledge of SQL Databases (DDL)

• Strong knowledge of SQL (Querying, optimization of queries) Tool Skills:

• Data analysis and modelling tools (IBM DATA ARCHITECT)

• SQL and/or PL/SQL

• Relational databases (IBM DB2 LUW)

• Data warehouse appliances (NETEZZA)

• Atlassian Suite: JIRA / CONFLUENCE / BITBUCKET

Nice To Have Skills:

• Knowledge of ETL tools and development (DATASTAGE)
• Knowledge of Test Principles (Test Scenarios / Test Use Cases and of Testing)
• Knowledge of ITIL
• Knowledge of OLAP
• Knowledge of NoSQL databases
• Knowledge of Hadoop Components - HDFS, Spark, Hbase, Hive, Sqoop
• Knowledge of Big Data
• Knowledge of Data Science / Machine Learning / Artificial Intelligence
• Knowledge of Data Reporting Tools (TABLEAU)

Non-Technical profile requirements

• Minimum 5 years of experience in a similar function
• Practical Experience in Data Bases and Business Intelligence
• Interpersonal and team collaboration skills
• Analytical and problem-solving
• Motivated
• Autonomous
• Work on simultaneous tasks with limited supervision
• Quick learner
• Communicate complex technical ideas, regardless of the technical capacity of the audience
• Learn and implement new and different techniques
• Understand business requirements
• Customer satisfaction oriented
• Respect the change management procedures, and the internal processes
• Knowledge of AGILE principles

Methodology/Certification requirements

• Higher education (Bachelor / Master), preferably in Science and Informatics, or an equivalent experience

Language proficiencies

• Bilingual (FR/NL)
• Active English